When it comes to setting up DRBD and MySQL, is the following possible?
- Set up DRBD on an active MySQL server
- Set up DRBD with no downtime allowed
Unfortunately, it is not possible to do either one.
Once you create
You want DRBD to house MySQL Data. Here is what you must do instead
As shown, stopping mysqld is mandatory.
UPDATE 2013-03-16 21:46 EDT
There is something incredibly tough you can try
STEP 01) Setup DRBD on Separate ServerDB2
As I mentioned earlier, you can house mysql on a DRBD mount.
STEP 02) Setup MySQL Replication
Huh ??? How did MySQL Replication enter the picture
STEP 03) Failover Your Application
In simple English, use the IP address of ServerDB2 in your application instead of ServerDB1
You should wait and make sure you have a low peak time to do this failover
STEP 04) Setup DRBD on Separate ServerDB1
This is an oversimplified description but you can look up the actual code to sync a DRBD pair
Here is my old DRBD download-and-install script
You can go to www.drbd.org to find out the latest version number and update the aforemtioned script
Give it a Try !!!