Différences

Ci-dessous, les différences entre deux révisions de la page.

--- informatique:sgbd:mysql:replication [13/01/2022 08:02] – [mysql replication] 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**.
+  * mariadb.com/kb
+    * [[https://mariadb.com/kb/en/setting-up-replication/|Setting Up Replication]]
 Voir [[/informatique/sgbd/mysql|MySql]].
-===== Quelques config =====
+===== Quelques configs & manips =====
   * [[https://mariadb.com/kb/en/binary-log/|Binary Log ]]
-    * max_binlog_size : default = 1GB
+    * 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.
+    * max_binlog_size : default & max = 1GB
   * [[https://mariadb.com/kb/en/relay-log/|Relay Log]]
-    * max_relay_log_size : default = 0
+    * **max_relay_log_size** : default = 0
+[[https://mariadb.com/kb/en/using-and-maintaining-the-binary-log/#safely-purging-binary-log-files-while-replicating|Safely Purging Binary Log Files While Replicating]]
+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**.
+  * 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.
+  * If you wish, make a backup of the log files to be deleted
+  * Purge all log files before (not including) the file identified above.
 ===== Essais de réplication =====