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 |
How do I make an action query?
How to convert character strings to numeric values?
What is difference between function and procedure in mysql?
What is full form of xampp?
Can I use mysql for free?
Can mysql and mariadb coexist?
What is a tinyint in mysql?
how many ways we can get the current date in mysql?
Are stored procedures precompiled?
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?
What are the three types of queries?
How do I edit a table in mysql?
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)