…MySQL Replication is single threaded, which means if you have any long running write query it clogs replication stream and small and fast…replication lagging when batch jobs are running. These can load master significantly during their run time and make it impossible for slave…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…master_yes_txblogpercona.commanual rpl_semi_sync_slave_enabledblogpercona.commanual Rpl_semi_sync_slave_statusblogpercona.commanual rpl_semi_sync_slave…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…MySQL replication to become bottleneck when Master server is …replication the most. It however works only with statement level replication. You need to set long_query_time=0 and log_slave_slow…replication capacity do you need in the healthy system ? It depends a lot on many things including how fast…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…Fast Recovery Recovery time is as fast as putting data back and standard MySQL… you can skip slow query logs and…master to master_host=”master“, master_user=”user”, master_password=”password”, master_log_file=”host-bin.000335″, master_log_pos=401934686; 12) Run SLAVE START to restart replication…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…typically make system extremely slow and also can … to be recovered fast is better solution. Innodb … This will sometimes break replication but if you’… MySQL to fail with wierd error messages. In MySQL…master.info corruption – If slave happens to crash you can also have relay logs corruption and master…
Comment: Innodb Performance Optimization Basics
April 29, 2008 By 70 Comments
… having those indexes slows down the insert/update operations. Is it advisable to set up replication such that the MASTER database does not have any indexes (except those required for updates), and the SLAVE has all… on MASTER, and fast retrievals on the SLAVE. Please advise. 2- How much of a difference does it make to have the MySQL server…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…etc. Read more in my > Why MySQL Could be slow with Large Tables article. Deciding whether…replicating from a master to a slave, there is no reason why you can’t remove the foreign key references on the slave…pass customer QA – it will work quite fast > with almost empty database. With database growth…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…) or can a bit slow it down. Plus there… full table scan would be fast. Maybe the table has …replication slave. Can you make the reorganization run in a tolerable time? PZ: Indeed using master-master setup and switching roles is a good way to get large data manageable. MySQL Master Master…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
…into the binary log. While this is generally a fast way to load data (especially if you disable …binary log and slows replication down. If the load takes 4 hours on the master, it will cause the slave to …other terminal: while [ -e /tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_…
