May 25, 2012

Post: Finding your MySQL High-Availability solution – Replication

master to be sure the slave has been updated before returning after a commit statement. There is a windowmaster to master topology is used. The following figure summarize the simplest HA architecture using MySQL replication. All writes are going to the master

Post: MySQL Crash Recovery

systemreplication but if you’re just planning onMySQL to fail with wierd error messages. In MySQL 4.1 sync_frm option was added which reduces this problem as time windowmaster.info corruption – If slave happens to crash you can also have relay logs corruption and master.info being corrupted. Not to

Comment: Database problems in MySQL/PHP Applications

system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf toon Windows # (via the “enable-named-pipe” option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication