Différences

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

--- informatique:sgbd:mysql:replication [13/01/2022 08:13] – [Quelques config] cyrille
+++ informatique:sgbd:mysql:replication [21/01/2022 10:09] – [mysql replication] cyrille
@@ Ligne 7: / Ligne 7: @@
 Wording / Vocabulaire : **master & slave -> primary & replica**.
+  * https://mariadb.com/kb/en/setting-up-replication/
 Voir [[/informatique/sgbd/mysql|MySql]].
@@ Ligne 13: / Ligne 15: @@
   * [[https://mariadb.com/kb/en/binary-log/|Binary Log ]]
-    * 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 **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]]
@@ Ligne 23: / Ligne 25: @@
 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 **SHOW BINARY LOGS**.
-  * 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.
   * If you wish, make a backup of the log files to be deleted