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
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
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
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
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
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
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
LEARN ABOUT PHP
mysql_get_proto_info
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)