May 23, 2012

Comment: Announcement of Percona XtraDB Cluster 5.5.23

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.

Post: Announcement of Percona XtraDB Cluster 5.5.23

… when you start all nodes from the same sources (i.e. backup) Ability to pass list of IP addresses for a…

Comment: How to load large files safely into InnoDB with LOAD DATA INFILE

… sure to delete the INFILE from the slave’s filesystem). e.g. To reiterate this, make sure ‘/tmp/data.out’ does…

Post: Testing Fusion-io ioDrive

… 1-64 threads. Throughput: Response time: For same cases (i.e. 4 threads) we see some interesting patterns. As for response…

Post: Zero-Downtime Schema Changes In MySQL

…, what does that mean? Does the tool clean up (i.e., remove table / triggers?) About cleanup.. What about manual aborting a…

Comment: How to change innodb_log_file_size safely

… you are not going to choose 64M or more (but e.g instead of 32M x 4 = 128M innodb_buffer_pool…

Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release

… configuration go for example default_storage_engine, query_cache_size, e.t.c…. Is it something built in or we just…

Comment: Version 1.0 of Percona Monitoring Plugins Released

Hi Baron, I see that the pmp-check-mysql-innodb plugin for Nagios leaves a lot of files (e.g. pmp-check-mysql-innodb.1196) in /tmp. Is that a desired feature? Thanks Daysen

Comment: Review of Virident FlashMAX MLC cards

… has nothing to do with the actual drive integrity.- i.e. power failure, controller error, disk timeout, etc.That is true…

Comment: Moving Subtrees in Closure Table Hierarchies

… cannot delete the connections to all the other ancestors of E because those connections would still be valid for the node… I implement a check to make sure we delete A-E, B-E, E-E if and only if they’re the last remaining links to E? Have you already worked on this problem?. Thanks, Ricardo Correa