Visit Our UNIX and Linux User Community

Special Forums UNIX Desktop Questions & Answers How can I replicate master master and master master MySQL databse replication and HA? Post 302901678 by Palak Sharma on Thursday 15th of May 2014 01:15:26 AM
Old 05-15-2014
Question 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

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.... (2 Replies)
Discussion started by: Beetlejuice
2 Replies

2. AIX

nim master

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

nim master

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

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... (5 Replies)
Discussion started by: Neo
5 Replies

5. 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 Replies)
Discussion started by: vivek d r
2 Replies
nissetup(8)						      System Manager's Manual						       nissetup(8)

NAME
nissetup, ypsetup - Sets up the Network Information Service (NIS) environment SYNOPSIS
/usr/sbin/nissetup /usr/sbin/ypsetup DESCRIPTION
The nissetup (formerly ypsetup) script configures and runs NIS on your system. You can use nissetup to initially set up your NIS configura- tion, to change your current NIS configuration, or to remove your NIS configuration. NIS provides a distributed data lookup service for sharing data among networked systems. Before running nissetup, make sure that your system is connected to a local area network and that the network is configured and running. You must know the name of your NIS domain and your system's role in the domain (master server, slave server, or client). Security Note You invoke nissetup from the SysMan Menu. See sysman(8) for more information. When using the nissetup script to set up a NIS server that is running with enhanced security, you must answer yes to the question about locking the domain name and authorized servers (the ypbind -S option). If you are setting up a master server, the server is bound to itself (done by default). If you are setting up a slave server, the server is bound to itself done by default) and optionally to the master server and any other slave servers. If your system will be the master server for your NIS domain, be sure no other master exists for your domain and that the NIS database files are in the /var/yp/src directory. Note Remove the root entry, if it exists, from the passwd database file. If your system be will be a slave server or client, be sure a master server is already set up for your NIS domain. FILES
Specifies the command pathname NIS parameters pertinent to a specific system Default NIS Databases In the /var/yp/src directory, the default databases are: Group database Host database Sendmail alias database Network group aliases data- base Network database Password database Protocol database RPC database Service database SEE ALSO
Commands: domainname(1), ypwhich(1), svcsetup(8), sysman(8), sysman_station(8), ypbind(8), yppasswdd(8), ypserv(8), ypxfr(8) Files: svc.conf(4) Networking: nis_intro(7), nis_manual_setup(7) Network Administration nissetup(8)

Featured Tech Videos

All times are GMT -4. The time now is 06:22 AM.
Unix & Linux Forums Content Copyright 1993-2021. All Rights Reserved.
Privacy Policy