Sponsored Content
Top Forums Web Development MySQL DevZone RSS Does MySQL supports Synchronous Replication. Post 302374540 by amit_27 on Tuesday 24th of November 2009 10:53:25 PM
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
 

6 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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
MYSQL_GET_PROTO_INFO(3) 						 1						   MYSQL_GET_PROTO_INFO(3)

mysql_get_proto_info - Get MySQL protocol info

SYNOPSIS
Warning This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include: omysqli_get_proto_info(3) int mysql_get_proto_info ([resource $link_identifier = NULL]) DESCRIPTION
Retrieves the MySQL protocol. o $ link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection is found or established, an E_WARNING level error is generated. Returns the MySQL protocol on success or FALSE on failure. Example #1 mysql_get_proto_info(3) example <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } printf("MySQL protocol version: %s ", mysql_get_proto_info()); ?> The above example will output something similar to: MySQL protocol version: 10 mysql_get_client_info(3), mysql_get_host_info(3), mysql_get_server_info(3). PHP Documentation Group MYSQL_GET_PROTO_INFO(3)
All times are GMT -4. The time now is 08:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy