in a master-master replication with two masters and
alternate slaves running on two systems.can i have a script
or any mysql command to know which one is right now acting
as master.

Answer Posted / lekhrajdeshmukh

i have answer regarding on master and one slave running on
the status:-
show slave status \G;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

774


What command is used to delete the data from the table without deleting the table structure?

639


How do you use auto increment?

694


What is the latest mysql?

663


How can you change the name of any existing table by using the sql statement?

727


What is the use of mysql_fetch_array () function in php?

643


How do I run a query in mysql?

688


What is the default password for mysql?

628


How do I disable mysql?

679


What is mysql data directory?

688


Can varchar be primary key?

661


What is the phantom problem?

723


What is the password of mysql?

682


Do I need to pay for mysql?

650


How can we convert between Unix & MySQL timestamps?

634