… the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online… rows affected (0.22 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows affected…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… wrote pretty good tutorial on creation for setting up BLACKHOLE Based Replication Filtering so I will not go into much of details… add more tables to be replicated to the slaves. Another issue is of course creating and altering tables. If you have Innodb… Replication can work pretty well for you. P.S It is in my todo to see how well MySQL 5.1 row based replication…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
…Copy_data AFTER INSERT on t FOR EACH ROW INSERT INTO t_copy VALUE(NEW.i); mysql… in this case we alter every event adding DISABLE ON SLAVE. ALTER EVENT even_name DISABLE ON… statement based replication. Knowing in advances how MySQL works internally can help us to improve our replication availability …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…, it doesn’t save you from the downtime caused by ALTER TABLE — a typical reason to think about master-master with…, assuming you use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5… the master with LOAD DATA INFILE, which kind of emulates row-based replication in a way. When you’re updating big aggregate tables…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
…) adding new ndbd nodes and of course doing alter tables. For alter tables, only replication can reduce the downtime. I agree that for… replication. I must admit that those issues were nearly all caused by stored procs and triggers and most likely switching to row based replication… NDB Cluster. @Todd: Replication are two different ways of replicating data, from my experience, DRBD is more reliable than replication. It is also…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…faster to run the alter table command directly (specially so when dropping an index, based on my experience…between two (or more) servers, if using statement based replication, it is possible that new differences are …(i.e. one or a few tables, in rows that probably won’t be updated short term…
Post: Sharding and Time Base Partitioning
March 14, 2008 By 12 Comments
…from “hot” it often makes sense to separate data based on its importance for system operation – for example… data is usually cached by pages rather than by rows and index entries having all hot data in… and restore it is easier to do ALTER TABLE and replication would not fall behind as easily. You…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…replication_delayblogpercona.commanual innodb_rollback_on_timeoutblogpercona.commanual Innodb_row_lock_current_waitsblogpercona.commanual Innodb_row_lock_timeblogpercona.commanual Innodb_row…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… InnoDB uses a clustered index based on (in order) the primary key…MySQL. If nothing else, it makes replicating a subset of the data much easier… – your data > becomes managable, your ALTER TABLE or OPTIMIZE TABLE > now … use the indexes to join rows together, potentially preventing a table scan…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… and from the Percona Software Repositories). Based on MySQL 5.1.59, …restarting a slave server in a replication environment, the process can be speed…make it faster. By reading the rows for “INSERT“, “UPDATE“ and “DELETE“ … and then adding them back in ALTER TABLE doesn’t work for them. …
