Mysql Replication master-slave/master-master

< <

Get flash to fully experience Pearltrees

16.1.2.3 Replication Slave Options and Variables

16.1.2 Replication and Binary Logging Options and Variables

A Practical Look at the MySQL Query Cache

TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE

January 19, 2007 By Peter Zaitsev 16 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.

Modifier le innodb_log_file_size | Un bout de DBA

http://www.noidea.ca/2008/05/22/modifier-le-innodb_log_file_size/

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

http://www.howtoforge.com/mysql_master_master_replication

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).

really interresting example and comments by harlequin Jan 7