How can I replicate master master and master master MySQL databse replication and HA?

Login or Register to Ask a Question and Join Our Community

How can I replicate master master and master master MySQL databse replication and HA?

Tags

centos, desktop, master, mysql, slave

Login to Discuss or Reply to this Discussion in Our Community

Special Forums UNIX Desktop Questions & Answers How can I replicate master master and master master MySQL databse replication and HA?

05-15-2014

Banned

41, 0

Join Date: Mar 2014

Last Activity: 20 August 2014, 10:53 AM EDT

Posts: 41

Thanks Given: 10

Thanked 0 Times in 0 Posts

How can I replicate master master and master master MySQL databse replication and HA?

I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database.

For this I have created two servers and have installed the same application and database on both the servers.

I want to achieve something like this:

1. If the user updates (insert,delete,modify) any record on any server then the same should be replicated on the other server.

2. If one of the server goes down the other should be able to serve the request.

Kindly help me to achieve the same.

Palak Sharma

View Public Profile for Palak Sharma

Find all posts by Palak Sharma

Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Red Hat

Master logs for all the operations performed on mysql DB

is there any such thing as master logs for all the operations performed on mysql database. thing is i need to find the operations performed on mysql on a linux server running on RHEL 5.7 for the past 2 days. One more thing i found out that the bin logs will be refreshed whenever server goes to...

2. Web Development

MySQL Master-Slave Configuration: Don't Replicate a Row of a Table?

Anyone have a clue about this? I have checked the MySQL documentation and it does not seem possible to exclude a row of a table from replication between Master and Slave. It seems that replication in MySQL can only be managed at the table level, not at the row level. Does anyone know a work...

3. AIX

nim master

Hi, I want to know how to create nim master in AIX 5.3. Regards, Manoj

4. AIX

nim master

Hi, I want to know what are steps required to create nim master in aix? Regards, Manoj

5. UNIX for Dummies Questions & Answers

Master Console

I was a sys admin on a HP3000. I was able to virtually move the console where ever I needed it for commands that had to be done at the master console. So I could be at home and perform some functions that you would usually have to do from the console. Now I am sys admin newbee on an AIX pseries....

Login or Register to Ask a Question