Transcontinental iSCSI for databases

Quicksearch

Disclaimer

The individual owning this blog works for Oracle in Germany. The opinions expressed here are his own, are not necessarily reviewed in advance by anyone but the individual author, and neither Oracle nor any other party necessarily agrees with them.

Navigation

< Interesting fact about the Opensolaris development cycle - revisited | Swiss >

Transcontinental iSCSI for databases

Saturday, September 27. 2008

I talked about the advantages of the separated ZIL and the L2ARC even on rotating rust in my article "iSCSI for I/O intensive tasks" in March 2008. I didn´t found the time to write down the findings of my tests as i started LKSF not much later. But Jignesh Shah did some tests with postgres and wrote down his results. He even took the concept a step farther:

Unfortunately the storage that's available is in Colorado while my PostgreSQL server is located in Massachusetts.

He tested an database with local sZIL and L2ARC and a remote iSCSI pool and got excellent results:

Not bad. Cutting the latency of writes of something that would have taken in excess of 8-10 minutes is atleast recorded within 4 seconds on nonvolatile cache/log combination and allowing ZFS to sync it up to the actual storage.

The whole concept of an ZFS augmented iSCSI shows promise even for latency-dependend applications.

Posted by Joerg Moellenkamp in English, Solaris at 14:38 | Comments (0) | Trackback (1)

Defined tags for this entry: iscsi

, l2arc

, solaris

, storage

, sun

, szil

, zfs

Related entries by tags:

View as PDF: This entry | This month | Full blog

Trackbacks

Trackback specific URI for this entry

Is iSCSI really dead? The Register thinks so ...
The Register thinks that FibreChanneloverEthernet(FCoE) will take over the datacenter and proclaims "iSCSI: Game over". Okay, no problem .... there is already a FCoE implementation for Solaris. There is only one simple problem: I´m not sure, that FCoE is

Weblog: c0t0d0s0.org
Tracked: Oct 15, 20:15

Comments

Display comments as (Linear | Threaded)

No comments

Add Comment

Name
Email
Homepage
In reply to
Comment	E-Mail addresses will not be displayed and will only be used for E-Mail notifications. To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above: Standard emoticons like :-) and ;-) are converted to images. Enclosing asterisks marks text as bold (word), underscore are made via _word_.
	Remember Information? Subscribe to this entry