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 / 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 |
What is DCL in MySQL?
How can I insert images into a Mysql database?
What are string data types?
how to declare unique key in creating a table..?
How to use count function in mysql?
How do I zip a file in mysql?
How to run 'mysql' commands from a batch file?
Is primary key auto increment?
what is the main difference between myisam and innodb
SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?
What is the use of concat() in mysql?
How to update database permissions/privilages.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)