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?
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/
You cannot if you can't make add another partition or change a currently mounted partition..
My not look into mysql replication?