Drupal 6 and MySQL master & slave Replication on EC2
Posted by akhan on September 17, 2011 at 12:55pm
Hello,
We are setting up a server farm on EC2 to host a site built on Drupal 6. I am reaching out to the this community to seek help in setting up the MySQL master-slave replication where Drupal will write to the mast DB and read from the slave DB. Has anyone done this successfully on EC2?
We are using Scalr.net as the front end cloud application and its lets you set-up the MySQL master-slave instances quite easily. Where I need help is how to tell Druapl to write to the master DB and read from the slave.
Many thanks for help in advance.
Regards,
Arshad