informatique:sgbd:mysql:replication
Différences
Ci-dessous, les différences entre deux révisions de la page.
| Les deux révisions précédentesRévision précédente | Prochaine révisionLes deux révisions suivantes | ||
| informatique:sgbd:mysql:replication [13/01/2022 09:40] – [Quelques configs & manips] cyrille | informatique:sgbd:mysql:replication [13/01/2022 09:41] – [Quelques configs & manips] cyrille | ||
|---|---|---|---|
| Ligne 23: | Ligne 23: | ||
| To be sure replication is not broken while deleting log files, perform the following steps: | To be sure replication is not broken while deleting log files, perform the following steps: | ||
| - | * Get a listing of binary log files on the primary by running SHOW BINARY LOGS. | + | * Get a listing of binary log files on the primary by running |
| - | * Go to each replica server and run SHOW SLAVE STATUS to check which binary log file each replica is currently reading. | + | * Go to each replica server and run **SHOW SLAVE STATUS** to check which binary log file each replica is currently reading. |
| * Find the earliest log file still being read by a replica. No log files before this one will be needed. | * Find the earliest log file still being read by a replica. No log files before this one will be needed. | ||
| * If you wish, make a backup of the log files to be deleted | * If you wish, make a backup of the log files to be deleted | ||
informatique/sgbd/mysql/replication.txt · Dernière modification : 21/01/2022 10:09 de cyrille