… I was reading the part about replication, can you help re-affirm this statement about replication? I’ve observed things differently in… in general. But if it’s left on, the replication logic only replicates that “command” across the slaves, not the actual imported… boxes, then the LOAD DATA command will fail silently, allowing replication to proceed as if nothing has happened. I’ve confirmed…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… bin-log and thus isn’t replicated, why ? without any replication filters or relevant args, the replication breaks reliably on the __tmp_x… tool. Q: Old version of PT OSC said risk in replication environment, I didn’t see that in the new version, does it mean the tool has been well tested in replication environment? Yes.
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 16, 2012 By 11 Comments
Gilles, you can filter what tables to replicate using regular replication filter i.e. replicate_*, for it does not affect a node propagation. The new node still will copy all databases and instances.
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
…, Baron, maybe you’re using different replication strategies. I can well imagine that row-based replication will indeed transfer the data, whereas…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
… why I’m witnessing the LOAD DATA INFILE command being replicated in verbatim on our master / slave pairs? To reiterate, are… the actual data would be transferred across the slaves via replication when LOAD DATA INFILE command is executed on master? (cuz…
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 15, 2012 By 11 Comments
Support for MyISAM, now changes to MyISAM tables are replicated to other nodes means is supported fulltext index and search?
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
…-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup SST methods, better error…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
Statement-based replication transfers the file too. It has worked the way I’m describing for a very long time, since at least MySQL 4.1.
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Jack, The LOAD DATA INFILE command isn’t replicated verbatim. The file that’s loaded on the master is …
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data…
