05-15-2014
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.
5 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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.... (2 Replies)
Discussion started by: Beetlejuice
2 Replies
2. AIX
Hi,
I want to know what are steps required to create nim master in aix?
Regards,
Manoj (1 Reply)
Discussion started by: manoj.solaris
1 Replies
3. AIX
Hi,
I want to know how to create nim master in AIX 5.3.
Regards,
Manoj (0 Replies)
Discussion started by: manoj.solaris
0 Replies
4. Web Development
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... (5 Replies)
Discussion started by: Neo
5 Replies
5. Red Hat
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 Replies)
Discussion started by: vivek d r
2 Replies
LEARN ABOUT ULTRIX
ypsetup
ypsetup(8yp) ypsetup(8yp)
Name
ypsetup - set up the yellow pages (YP) environment
Syntax
/usr/etc/ypsetup
Description
A local area network must be set up on your system before you can set up YP. You must know your system's default YP domain name and
whether your system will be a master server, slave server, or client. If your system is to be the master server for your YP domain, be
sure no other master has been established and be sure the files to be distributed are in the directory Note that the files to be distrib-
uted should be modified from the original files by removing the root entry in the file.
If your system is not to be the master server, be sure a master already exists for your YP domain. Once you know this information, run
with the system in multiuser mode and answer its questions.
Once YP is installed on a machine, it cannot be used until the file is modified to contain YP entries on the desired database lines. The
command reminds a user to run or edit the file manually.
Files
Files that Start the YP daemons
Clock daemon database file
Commands pertinent to a specific system
Default YP Map Files
Group database
Host name database
Sendmail alias database
Network group aliases
Network name database
Password file
Protocol name database
Rpc name database
Service name database
See Also
domainname(1yp), ypwhich(1yp), svc.conf(5), svcsetup(8), yppasswdd(8yp), ypserv(8yp), ypxfr(8yp)
Guide to the Yellow Pages Service
ypsetup(8yp)