I thought a little bit about the idea of transforming server into solid state disks. The idea in the mail of Chris Greer on
zfs-discuss was to use mirrored iSCSI shared ramdisks as a storage for the seperated ZILs. But i think you could use the concept as well for L2ARC as well - e.g. for large databases. One of the sizing rules of databases: More main memory never hurts. Nothing helps the performance of a database more than even more memory. The rule of "main memory never hurts" is based on the fact, that a hard disk has only a few IOPS compared with the main memory and hard drive access massively hurts the performance of your database.
But obviously the size of memory is limited, albeit the this limit is quite high with systems with memory sizes in the range of 512 GB on 4 rack units. But how can you get more memory into your database system, when all DIMM slots are filled with the biggest available DIMMS.
I had an idea while cooking tea this evening while i thought about a discussion with a colleague: Letīs assume an architecture based on a X4600 as a head in front of four X4600 each fully maxed to 512GB. All the nodes are connected with Infiniband. The first X4600 is your normal database server (for example mysql or LarryBase). You put your data into an ZFS storage pool. This storage pool is augumented with L2ARC devices. But now comes the plot twist. Letīs use the 512GB X4600 as huge ramdisks (yes, i know, every engineers heart will crying now) speaking via iSER (no TCP/IP, just RDMA) at 20 GBit/s to the central database node. This would give you a cache in the size of almost 2 TB plus the cache on the database server itself.. By using L2ARC you could use the memory as database caches of other systems without using a database doing a combination of the memory resources by other means, for example the CacheFusion stuff of Oracle. You donīt have to fuse the caches of other databases servers. The other servers
are caches. You donīt have to partition the databases.
It would be interesting how such an system would perform in comparision to a Oracle RAC or other memory implementations. Anybody out there willing to test this ... my Infiniband switches are in the laundry at the moment
Comments
Fri, 21.11.2008 17:32
Yes the Storage 7000 series is nice but... If Sun want to survive, and flourish, duri ng the coming economic d [...]
Fri, 21.11.2008 16:14
no sure if it makes sense to c ompare Sun-Technologie to GM? Sun is like the german car-com panies, number one in th [...]
Fri, 21.11.2008 10:24
http://www.opensolaris.org/os/ community/arc/caselog/2008/685 /materials/tenaya-onepage-txt/
Fri, 21.11.2008 07:35
I will not disclose anything m ore than that
Fri, 21.11.2008 03:08
We have X4600s which have four 146GB HDDs in them. We want t he first two as mirrored root disks and the other two [...]