Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|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

2 Answers 2

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

My not look into mysql replication?

share|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

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/

share|improve this answer
    
wow. thanks. that's hardcore. I will look into it. –  Richard Castle Jan 4 '11 at 19:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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