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édenteProchaine révision | Révision précédente | ||
| informatique:sgbd:mysql:replication [13/01/2022 09:40] – [Quelques configs & manips] cyrille | informatique:sgbd:mysql:replication [21/01/2022 10:09] (Version actuelle) – [mysql replication] cyrille | ||
|---|---|---|---|
| Ligne 7: | Ligne 7: | ||
| Wording / Vocabulaire : **master & slave -> primary & replica**. | Wording / Vocabulaire : **master & slave -> primary & replica**. | ||
| + | |||
| + | * mariadb.com/ | ||
| + | * [[https:// | ||
| Voir [[/ | Voir [[/ | ||
| Ligne 23: | Ligne 26: | ||
| 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.1642063237.txt.gz · Dernière modification : 13/01/2022 09:40 de cyrille