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

What is triggers and how it can be used in mysql?

524


How do I change mysql password?

489


What is cast in mysql?

471


Difference between CHAR and VARCHAR?

583


Why mongodb is faster than mysql?

467






Explain about reporting services of MYSQL?

608


What is dbms in mysql?

502


How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

570


How do I edit a table in mysql?

486


what is constraints? Also explain the different types of constraints?

518


What is 'mysqladmin' in mysql?

516


What is a trigger? How you can create a trigger in mysql?

483


Can mysql scale horizontally?

493


How do we delete a row in a table?

532


How do I view mysql logs?

487