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
How to include character strings in sql statements?
How many tables we can create in mysql database?
How can we get total number of records by query in mysql?
In which year mysql created?
How to dump a table to a file with 'mysqldump'?
How to check server status with 'mysqladmin'?
What is the difference between char and varchar in mysql?
What is the use of mysql_close()?
How do I transfer data from one database to another in mysql?
What is memory table in mysql?
Which is faster mysql or mongodb?
What are mysql queries?
What is myisam?
Consider you have the following three tables which have to be linked together.
How do I clear the command in mysql?