Différences

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

--- informatique:sgbd:mysql [20/03/2021 18:54] – [Replication] auto_increment_offset cyrille
+++ informatique:sgbd:mysql [21/03/2021 11:28] – [Replication] cyrille
@@ Ligne 181: / Ligne 181: @@
     * avec Master<->Master
     * ''auto_increment_increment'' and ''auto_increment_offset' variables such that one only uses odd numbers for auto-incrementing integer primary keys and the other use even bumbers
+    * [[https://fr.wikibooks.org/wiki/MySQL/Réplication|MySQL/Réplication]]
+  * [[https://www.christophe-casalegno.com/reparation-dune-replication-mysql-mariadb/|Réparation d’une réplication MySQL ou MariaDB]]
   * [[http://missingmanuals.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html?page=1|Advanced MySQL Replication Techniques]] (2006-04-20)
   * [[http://www.ovaistariq.net/528/statement-based-vs-row-based-replication/|Statement-based vs Row-based Replication]] (2011-01)
@@ Ligne 187: / Ligne 189: @@
 Sans arrêter le Master avec l'option "--master-data" de mysqldump.
   * http://dev.mysql.com/doc/refman/5.1/en/replication-howto-mysqldump.html
+TODO :
+  * replication check ?
+  * slave-skip-errors ?
+  * [[https://mariadb.com/kb/en/show-replica-status/|show slave status]] (ou SHOW REPLICA]
+  * SHOW PROCESSLIST; SHOW SLAVE HOSTS;
 ===== Performance =====