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
SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?
What command is used to delete the data from the table without deleting the table structure?
How do you use auto increment?
What is the latest mysql?
How can you change the name of any existing table by using the sql statement?
What is the use of mysql_fetch_array () function in php?
How do I run a query in mysql?
What is the default password for mysql?
How do I disable mysql?
What is mysql data directory?
Can varchar be primary key?
What is the phantom problem?
What is the password of mysql?
Do I need to pay for mysql?
How can we convert between Unix & MySQL timestamps?