Visit Our UNIX and Linux User Community


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


 
Thread Tools Search this Thread
Special Forums UNIX Desktop Questions & Answers How can I replicate master master and master master MySQL databse replication and HA?
# 1  
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.

Previous Thread | Next Thread
Test Your Knowledge in Computers #481
Difficulty: Medium
Generally speaking, programs do not start out as source code.
True or False?

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 Replies)
Discussion started by: vivek d r
2 Replies

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

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.... (2 Replies)
Discussion started by: Beetlejuice
2 Replies
timed(8)						      System Manager's Manual							  timed(8)

Name
       timed - time server daemon

Syntax
       /usr/etc/timed [ -i | -n network ][ -E ][ -M ][ -t ]

Description
       The  daemon  synchronizes a host's time with the time of other machines in a local area network running It is normally invoked at boot time
       from the file.

       Servers running slow down the clocks of some machines and speed up the clocks of others to bring them all to the average network time.  The
       average	network  time is computed from measurements of clock differences with the Internet Communication Message Protocol (ICMP) timestamp
       request message.

       The service provided by is based on a master-slave scheme.  When is started on a machine, it asks the master for the network time and  sets
       the host's clock to that time.  After that, it accepts synchronization messages periodically sent by the master and calls the or routine to
       perform any corrections on the host's clock.

       It also communicates with the command to set the date globally, and with the control program, If the machine running  the  master  crashes,
       then  the  slaves  elect  a new master from among slaves running with the flag set.  The flag provides time synchronization on any attached
       networks where no current master server is detected.  Such a server propagates the time computed by the top-level  master.   At	least  one
       daemon on each network must run with the option set to allow it to become a master.

Options
       -E     Overrides  the input of slaves.  Use the flag in conjunction with the flag.  It specifies that a master should not average the times
	      of the slaves to calculate the network time but should distribute the time of its local host as the network time.  This flag  allows
	      a master to distribute time to a network while the network time is controlled by an outside agent such as the Network Time Protocol.

       [-i | -n] network

	      -i     Specifies	a  network  to ignore.	Each network that appears as an argument to the flag is added to the list of networks that
		     will ignore.  If the flag is used, accesses all networks to which the host is connected except for those  networks  specified
		     as arguments to the flag.

	      -n     Specifies a network to use.  When the is started, it gathers information about all the network devices connected to the local
		     host.  If neither the flag nor the flag is used, tries to access all the network devices connected to the	local  host.   The
		     network argument to the flag is the name of a network that should access.

		     If the switch is used, only those networks specified by the flag are accessed.

		     Do not use the and flags together.

       -M     Allows  a  slave	time  server to become a master time server if the master server crashes.  A system running the daemon without the
	      flag set remains a slave.  The daemon checks for a master time server on each network to which it is connected.	It  requests  syn-
	      chronization service from the first master server it locates.

       -t     Enables to trace the messages it receives in the file Tracing can be enabled or disabled with the program.

Restrictions
       Any  system  running with the and options set is eligible to become the master, and distribute its local time to all systems running on its
       network.  Run the Network Time Protocol daemon, instead of to prevent this behavior.

Files
       Invokes the			  daemon each time the system boots

       Tracing file for

       Log file for master

See Also
       date(1), adjtime(2), gettimeofday(2), networks(5), ntpd(8), timedc(8)
       Introduction to Networking and Distributed System Services

																	  timed(8)

Featured Tech Videos