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 08:13] – [Quelques config] 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 13: | Ligne 16: | ||
* [[https:// | * [[https:// | ||
- | * Lui donner un nom --log-basename pour qu'il ne soit pas dépendant du hostname. | + | * Lui donner un nom --**log-basename** pour qu'il ne soit pas dépendant du hostname. |
- | * Définissez expire_logs_days plus long que tout décalage possible du replica. | + | * Définissez |
* max_binlog_size : default & max = 1GB | * max_binlog_size : default & max = 1GB | ||
* [[https:// | * [[https:// | ||
- | * max_relay_log_size : default = 0 | + | |
[[https:// | [[https:// | ||
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.1642058009.txt.gz · Dernière modification : 13/01/2022 08:13 de cyrille