Login or Register to Ask a Question and Join Our Community


MySQL DevZone RSS

Does MySQL supports Synchronous Replication.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS Does MySQL supports Synchronous Replication.
# 1  
Old 11-23-2009
Does MySQL supports Synchronous Replication.
Hi All,

Does MySQL supports Synchronous Replication? If it is then From which version it is supported and how?

Any help on this highly appreciated.

Thanks.
# 2  
Old 11-23-2009
You can find your answers at the MySQL web site. For MySQL 5.4:

Quote:
Replication enables data from one MySQL database server (called the master) to be replicated to one or more MySQL database servers (slaves). Replication is asynchronous - your replication slaves do not need to be connected permanently to receive updates from the master, which means that updates can occur over long-distance connections and even temporary solutions such as a dial-up service. Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database.
# 3  
Old 11-24-2009
Thanks for the prompt reply.

Let me know if We can make a setup like using MySQL.

We have master - A and slave - B setup.

Case 1:

If master(A) goes down then slave (B) becomes a master. So changes on slave(B - which is now master) needs to replicate to master (A) when master (A) up.

Case 2.

If master(A) down and then up then it again will become a master and B becomes slave.

Does MySQL supports this kind of mechanism?

Amit
# 4  
Old 11-30-2009
Hi Neo,

Does "Switching Masters During Failover" supports for prior to version 4.1?

I found this point in 5.0 onward manual and not in "MySQL 3.23/4.0/4.1" manual.

Can you please tell me it is supported in prior to 4.1 versions?

Regards,
Amit
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. UNIX Desktop Questions & Answers

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... (0 Replies)
Discussion started by: Palak Sharma
0 Replies

2. Linux

Mysql replication

Need to recover a replication broken error on the mysql slave server. I want to force it to resend the binlog file from the begining. What is the correct value for the: MASTER_LOG_POS ? 0, 1 or 107 ? (2 Replies)
Discussion started by: andriesh
2 Replies

3. Shell Programming and Scripting

Strategical Shell Scripting For MySql Replication

Hi to all guyz , As i'm new to Shell scripting i was been working out to write a shell script for mysql Replication for multiple slave master architecture.i have done the process up with a script of 200 lines but still there are some things which can make my script more effective so i want your... (5 Replies)
Discussion started by: kgrvamsi
5 Replies

4. Web Development

MySQL Replication Issues: Duplicate Key Error

Lately my attention has been focused on distributed MySQL database replication to other web servers. All was going well, but then I noticed the replication would stop and there were there "Duplicate Primary Key" errors in SHOW SLAVE STATUS; I started to trace these down and noticed that this... (2 Replies)
Discussion started by: Neo
2 Replies

5. UNIX for Advanced & Expert Users

capturing synchronous signals

hi, i created 2 threads in which one thread is dedicated to capture signals and handle them. i used the following functions: sigfillset for filling the signal set to be blocked by other threads sigwait for waiting on particular signals pthread_sigmask to mask block the signals. I... (0 Replies)
Discussion started by: skyrulz
0 Replies

6. Solaris

Processor and memory supports

HI i'am Giancarlo D. Jabon student from AMA Computer University is anyone among all of you who knows the maximum processor and memory supports in Sun Solaris 10 Thanks !!!! (3 Replies)
Discussion started by: giancarlodjabon
3 Replies
Login or Register to Ask a Question