I am trying to set up a failover secondary MySQL server that is a mirror of my primary MySQL server using DRBD. The problem is that I am on a rackspace cloud server and I need a second partition on both the primary and secondary servers that I will replicate with DRBD. Rackspace does not allow me to create a second partition. I am left with the default single partition. How can I mirror using DRBD?
Asked
Active
Viewed 760 times
0
-
drbd works great but use multimaster replication with haproxy in front for load balance/failover. – Shaggy63 Jan 28 '11 at 07:31
2 Answers
3
Coincidently there is a blog post related to doing this by a Rackspace employee: http://rackerhacker.com/redundant-cloud-hosting-configuration-guide/setting-up-a-redundant-database-and-caching-layer/
Mat
- 306
- 1
- 2
0
You cannot if you can't make add another partition or change a currently mounted partition..
My not look into mysql replication?
Mike
- 22,310
- 7
- 56
- 79
-
Because this is a wordpress install and all that is needed is failover. This is a very large install and didn't want to get into hyperDB because it is not compatible with w3 total cache. . .Has anyone had experience with MySQL proxy to separate read and write ? This would allow me to stay away from installation which I wasn't involved with from beginning. – Richard Castle Jan 04 '11 at 19:31