Différences

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

--- informatique:sgbd:mysql [21/03/2021 10:46] – [Replication] cyrille
+++ informatique:sgbd:mysql [21/03/2021 11:48] – [Articles] cyrille
@@ Ligne 180: / Ligne 180: @@
   * [[https://opensolitude.com/2016/09/12/painless-high-availability-failover-mariadb.html|Painless HA failover with MariaDB]] (2016
     * 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
+    * ''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%C3%A9plication|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)
+==== Reprise après échec/panne ====
 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 :
+==== Superviser la réplication ====
   * replication check ?
@@ Ligne 195: / Ligne 198: @@
   * [[https://mariadb.com/kb/en/show-replica-status/|show slave status]] (ou SHOW REPLICA]
   * SHOW PROCESSLIST; SHOW SLAVE HOSTS;
+Dans ''/var/log/syslog'' des lignes comme ''...mysqld[123]: 101015 21:11:19 [ERROR] Slave: Error...''
@@ Ligne 205: / Ligne 210: @@
   * [[http://www.mysqlperformanceblog.com/2007/11/01/innodb-performance-optimization-basics|Innodb Performance Optimization Basics]] sur mysqlperformanceblog.com
+  * [[https://fr.wikibooks.org/wiki/MySQL/Optimisation|MySQL/Optimisation]] sur wikibooks
   * [[http://hackmysql.com/selectandsort|MySQL Select and Sort Status Variables]]
   * [[http://phpinfo.net/articles/article_optimisation-mysql.html|Optimisation MySQL]] Par Laurent DECORPS sur phpinfo.net