Sunday
Dec302007
MySQL clustering strategies and comparisions

Compare:
1. MySQL Clustering(ndb-cluster stogare)
2. MySQL / GFS-GNBD/ HA
3. MySQL / DRBD /HA
4. MySQL Write Master / Multiple MySQL Read Slaves
5. Standalone MySQL Servers(Functionally seperated)
1. MySQL Clustering(ndb-cluster stogare)
2. MySQL / GFS-GNBD/ HA
3. MySQL / DRBD /HA
4. MySQL Write Master / Multiple MySQL Read Slaves
5. Standalone MySQL Servers(Functionally seperated)
Reader Comments (2)
http://linuxsutra.blogspot.com/2007/02/howto-mysql-drbd-ha.html">MYSQL-HA-DRBD implementation is not complicated.
But this is NOT A SCALABLE solution.
DRBD lets you share data disk. DRBD can be forced to be transaction safe.
You can have one MySQL server serving the shared data at a time.
DST is also a very interesting project. Hope it makes it into the kernel. It's [e]nbd/drbd on steroids.
http://tservice.net.ru/~s0mbre/old/?section=projects&item=dst