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 are the 'mysql' command line options?
Is mysql a dbms?
What is the full meaning of mysql?
What port is mysql running on?
How many columns can be used for creating Index?
Why does mysql have so many connections?
What is mysql port?
What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?
Where is the myisam table stored?
What is blob datatype in mysql?
What is database in php mysql?
What are the 5 r's of managing behaviors?
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)