Can a MySQL DB completely run in memory?

March 10th, 2010 | portal.cgkz.com | edit

My DB is now getting up to 2.2 gig and and the latest site upgrade has significantly increased usage once again.

I'm looking at buying 2 servers and splitting up DB/Web functionalities.

One thing I would like to know is whether it's possible to completely run all a DB's tables in ram and then maybe dump the data onto disk every hour or so.
Assuming there is any performance benefit to such a setup.

Thanks

I doubt you'll be able to do that, plus it's pretty risky, as everything would be lost if there is a power cycle and the dump to disk hasn't been performed. A good quad core with several GB of RAM and some 15K RPM SCSI drives in RAID-10 or RAID-5, depending on your needs should suite you quite well for the db server.

For a 2 server setup like stefaandk asked about, wouldn't people recommend RAID 5 for the webserver & RAID 10 for the mySQL server?
raid 10 definitely for mysql.. on web end don't think it matters much i'd go raid 10 if i had the $$$ on budget but need some redundancy raid 5

MySQL 5.1 greatly enhances multiple core support.

RAID 10 is better than RAID 5, also.

Thank you, I'm also trying to determine whether I should get a fast dual core or a slower quad core.

I just can't seem to find a definitive answer as to whether MySQL makes good use of multiple cores.
Running 5.0

http://dev.mysql.com/doc/refman/5.0/en/faqs-general.html#qandaitem-27-1-7

Apparently, it can use multiple cores :).

MySQL 5.1 greatly enhances multiple core support.

RAID 10 is better than RAID 5, also.
For a 2 server setup like stefaandk asked about, wouldn't people recommend RAID 5 for the webserver & RAID 10 for the mySQL server?

#If you have any other info about this subject , Please add it free.#

Admin

Categories

Links

Can a MySQL DB completely run in memory?