up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
drbd works great but use multimaster replication with haproxy in front for load balance/failover. – Shaggy63 Jan 28 '11 at 7:31
feedback

2 Answers

up vote 3 down vote

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/

link|improve this answer
wow. thanks. that's hardcore. I will look into it. – Richard Castle Jan 4 '11 at 19:35
feedback
up vote 0 down vote

You cannot if you can't make add another partition or change a currently mounted partition..

My not look into mysql replication?

link|improve this answer
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 4 '11 at 19:31
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.