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
What is the difference between now() and current_date()?
How do I find users in mysql?
How do you rename a table?
How do I restore a database in mysql workbench?
How do I copy an entire mysql database?
What is csv?
How To see all the tables from a database of mysql server.
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
Is mysql a dbms?
How to show table structure mysql?
How do I clear the screen in mysql?
What is sqlyog?
How do I completely remove mysql from windows?
how to take mysql database backup?
What is the command used to create a database using php and mysql?