You are here

Home » Blogs » Shinguz's blog

MySQL on VMware Workstation/DRBD vs. VMWare ESX Server/SAN

Fri, 2010-01-22 17:05 — Shinguz

Or an active-active failover cluster à la VMware.

Today I have learned about a totally crazy/cool looking architecture where the expensive VMware ESX server was replace by a free/cheap VMware Workstation version in combination with DRBD.

Basically DRBD we name the poor man's SAN and that is exactly what this customer is doing. He replaced the SAN with DRBD and now he can easily move one VMware instance to the other host. Possibly it is not that flexible and powerful as an ESX Server but also not so expensive...

The architecture looks as follows:

VMware architecture

According to this customer it works stable on about a dozed of installations and they have not experienced any troubles during the failovers.

Please let me know your experience, thoughts or concerns with this architecture...

PS: When you consider such an architecture do not expect a very good performance!

Taxonomy upgrade extras: 
mysql
drbd
esx server
san
vmware

Comments

[http://www.blogger.com/profile/04408844340588067447 Charlie] said... You should expect stellar performance, actually! DRBD, when configured well, has less than a 10% overhead. When scaling to > 2 nodes, it's probably recommended to use iSCSI. A pair of redundant iSCSI serveres (replicating with DRBD, of course) can serve 10+ VMware hosts if they have a few bonded gigabit NICs.
Charliecomment Fri, 2010-01-22 23:30

[http://www.blogger.com/profile/17059197203923199652 Oliver] said... I have set up almost identical scenarios on top of Xen, and I found performance to be quite acceptable. I've also implemented the same thing with Oracle 10g XE (which was a little adventure trying to "staple on" HA to a product that does not support it in any way, and is as horribly installed as Oracle), and with Microsoft SQL Server running within Windows 2008 servers which were also VMs on Xen with DRBD as the backing storage. Windows is a special case though as it is hard to get 2008 working on Xen with good PV drivers. Nonetheless, anything is possible.
Olivercomment Thu, 2010-02-04 14:04