Les deux révisions précédentesRévision précédenteProchaine révision | Révision précédenteProchaine révisionLes deux révisions suivantes |
informatique:sgbd:mysql [20/03/2021 18:54] – [Replication] auto_increment_offset cyrille | informatique:sgbd:mysql [21/03/2021 11:32] – [Replication] cyrille |
---|
* [[https://opensolitude.com/2016/09/12/painless-high-availability-failover-mariadb.html|Painless HA failover with MariaDB]] (2016 | * [[https://opensolitude.com/2016/09/12/painless-high-availability-failover-mariadb.html|Painless HA failover with MariaDB]] (2016 |
* avec Master<->Master | * 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://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) | * [[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. | 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 | * http://dev.mysql.com/doc/refman/5.1/en/replication-howto-mysqldump.html |
| |
| ==== Superviser la réplication ==== |
| |
| |
| * replication check ? |
| * slave-skip-errors ? |
| * [[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...'' |
| |
| |
===== Performance ===== | ===== Performance ===== |