Mysql Replication master-slave/master-master

Facebook Twitter

16.1.2.3 Replication Slave Options and Variables. 16.1.2 Replication and Binary Logging Options and Variables. TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE. January 19, 2007 by Peter Zaitsev19 Comments We all know disk based temporary tables are bad and you should try to have implicit temporary tables created in memory where possible, do to it you should increase tmp_table_size to appropriate value and avoid using blob/text columns which force table creation on the disk because MEMORY storage engine does not support them Right ?

TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE

Wrong. 13.2.3 InnoDB Startup Options and System Variables. Modifier le innodb_log_file_size | Un bout de DBA. Je me suis déjà fait avoir 2 fois par cette option.

Modifier le innodb_log_file_size | Un bout de DBA

Si vous avez des tables InnoDB avec un gros load d’écriture (insert, update), il est généralement recommandé d’avoir un innodb_log_file_size assez élevé. Mais soyez vigilant: plus la grosseur du log file est élévée, plus le temps de recovery est long dans le cas d’un crash. Mais peu importe. Là ou je veux en venir, c’est sur la manière de modifier cette option. 1 Reference Manual :: 16.4 Replication Notes and Tips. 6 Réplication de MySQL. 6.4 Comment mettre en place la réplication. 1 Reference Manual :: 12.5.2.1 CHANGE MASTER TO Syntax.

16.1.1.1 Setting the Replication Master Configuration. 16.1.1.2 Setting the Replication Slave Configuration. 16.1.1.3 Creating a User for Replication. 16.1.1.4 Obtaining the Replication Master Binary Log Coordinates. Master Master Howto. This tutorial describes how to set up MySQL master-master replication.

Master Master Howto

We need to replicate MySQL servers to achieve high-availability (HA). In my case I need two masters that are synchronized with each other so that if one of them drops down, other could take over and no data is lost. Similarly when the first one goes up again, it will still be used as slave for the live one. Here is a basic step by step tutorial, that will cover the mysql master and slave replication and also will describe the mysql master and master replication.

Notions: we will call system 1 as master1 and slave2 and system2 as master2 and slave 1.