Hello, I happen to be in a position to utilize a 6GB FC solid state disk (RAM based with battery and disk backup) on our new storage area network.
I haven't ever used an SSD for MySQL before, but I am aware of the potential performance benefits. My question is, does anyone have any suggestions on how to best deploy it? We have two machines, each dual opteron 250's with 4GB of ram ea. These are to be configured with steeleye's lifekeeper (not done yet) for active/passive failover. Currently we have 4 LUN's available via 2Gbps FC, each with 120 some odd gigs to be used for storage. Also the 6GB SSD. Our current InnoDB table space size is about 200GB. I planned on putting the innodb log log files on the SSD. These are not that large on the system we are gonig to replace, about 90 megs each for 3 of them. Does it make much sense to increase these significantly? Normally this would be bad in case of roll backs (we often do large transactions) that take a long time. Any opinions on how much might the fact that the innodb logs are on the SSD effect the rollback time? Further, I had been thinking to place the most recent mysql binlogs on the SSD as well. Is there anything else other than perhaps temp table space that I might consider placing on SSD? Any input is appreciated. Thanks, Richard
signature.asc
Description: This is a digitally signed message part