…MySQL Master-Master replication I can add and index…MySQL Replication, such as filtered replication or cross storage engine replication, though which are not typically used for HA purposes. Time Delayed replication…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…replicate_do_dbblogpercona.commanual replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… than the ones based on replication that handles GIS indexes. HA solutions Need MyISAM Full text or GIS indexes “MySQL replication” and “Master-Master with… is for a project to create a replication slave for HA purposes, not for “setting up replication.” There is a big difference between…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…easy for MySQL replication to become bottleneck when Master server is not …your system when your replication runs normally – if you need to add/remove indexes and do other schema…estimate replication capacity, so we can deal with replication load before slave is unable to catch up. Need to replication…
Post: Missleading Innodb message on recovery
February 15, 2010 By 2 Comments
…: In a MySQL replication slave the last master binlog file InnoDB: position 0 10000000, file name mysql-bin.005000 InnoDB: Last MySQL binlog file position… restart replication from mysql-bin.005000 position 10000000 which failed with “Could not find first log file name in binary log index file…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
…Text Search solutions with MySQL and Sphinx. This presentation will talk about architecture of BoardReader.com which indexes over billion of …last summer. Using Slave Server Without Breaking User Experience MySQL Replication is asynchronous this means you should be using slaves only for reads and…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 …MySQL Cluster would ever be that thing as it provides too strong guarantees. It is same as with MySQL Replication…They anyway read stale data from the slave or memcached manually relaxing data consistence requirements…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…Replication Master Server (default) # binary logging is required for replication log-bin=db1-bin log-bin-index=db1-bin.index…Replication Slave (comment out master section to use this) # # To configure this host as a replication slave…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…) ); What can we improve here? Especially assuming that there are indexes other than the primary key, we can shrink the primary… use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work on a slave, then piping…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…- adding/dropping columns or indexes, changing data type, converting data to different character set – MySQL master-master replication especially accompanied by MMM … stop replication mysql> STOP SLAVE; we don’t want schema changes to be replicated to db1 now. 3. on db2: load the sql scripts $ mysql…
