Replication
Master-replica, replication, mein, WRITES, master, PAR, HOTE, HAIN — CHANGES, binlog, (binary, log) ke, through, replica, servers, ko, PROPAGATE, kiye, jaate, HAIN. Reads, replicas, se, ki, ja, sakti, hain, LOAD, distribute, karne, ke, liye.
Replication, HIGH, AVAILABILITY, aur, READ, SCALING, DONO, ke, liye, USE, hoti, hai — agar, master, FAIL, ho, jaaye, EK, replica, ko, NAYA, master, PROMOTE, kiya, ja, sakta hai.
-- Master server par:
SHOW MASTER STATUS;
-- Replica server par:
CHANGE MASTER TO
MASTER_HOST='master_host',
MASTER_USER='repl_user',
MASTER_PASSWORD='repl_password';
START SLAVE;- Master-replica, replication, — writes, master, PAR, reads, replicas, se
- binlog, se, changes, replicas, ko, PROPAGATE, hote, HAIN
- High, availability, aur, read, scaling, DONO, ke, liye, USE, hoti, hai
Statement-based, replication, ACTUAL, SQL, statements, ko, replicate, karta hai. Row-based, replication, ACTUAL, DATA, changes, ko, replicate, karta hai — row-based, MODERN, DEFAULT, hai, kyunki, YE, MORE, RELIABLE, hai (jaise, NOW() jaisi, non-deterministic, functions, ke, saath).
MySQL, 5.7+, mein, EK, replica, MULTIPLE, masters, se, DATA, replicate, kar, sakta hai (multi-source, replication) — DATA, ko, MULTIPLE, sources, se, EK, "consolidated" replica, mein, AGGREGATE, karne, ke, liye, useful, hai.