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 the function of myisamchk?
What is msql?
Which statement is used in a select query for partial matching?
Where is the mysql database stored?
Where’s database data actually stored?
What is a transaction? Describe mysql transaction properties.
What are mysql functions?
How do I start mysql in mysql workbench?
How many ways we can we find the current date using MySQL?
Which is best pdo or mysqli?
Why do we use group by and order by function in mysql?
What are the differences between innodb and myisam engines?
Oracle (3253)
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)