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 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 ? Wrong.
13.2.3 InnoDB Startup Options and System Variables
Je me suis déjà fait avoir 2 fois par cette option. 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. Modifier le innodb_log_file_size | Un bout de DBA Modifier le innodb_log_file_size | Un bout de DBA
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 Master Master Howto This tutorial describes how to set up MySQL master-master replication. 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.