June 19, 2013

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… are looking at reducing the overhead here, through steps like replacing xinetd and clustercheck with a single serving process (we are…

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

….69-14.7 on June 10, 2013. A drop in replacement for MySQL, downloads are available  here and from the Percona…

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2

On Scenario #1, replace “change master to master_port=10001;” with “change master to master_port=10002;”

Post: 10 years of MySQL User Conferences

… Management. Monty is working on the Maria storage engine to replace Innodb for a number of use cases. The first “open… his focus from Maria (storage engine) to MariaDB (complete MySQL replacement). There is a lot of “MySQL Community” focused keynotes. Good… Alternatives including keynotes for Drizzle and MariaDB. MySQL 5.5 replaced MySQL 5.4 as next planned GA release. Percona releases…

Comment: MySQL and Percona Server in LinkBench benchmark

… lock. All this is unnecessary if the block is not replaceable. We need to check that by calling buf_flush_ready_for_replace() and only call buf_LRU_free_block() if buf_flush…

Comment: Using Flexviews - part two, change data capture

Finally figure out the error in code, which can not handle “`” very well. Near 1110 line Should change the code to $this->db = preg_replace(‘/[^a-zA-Z0-9]+/’, ”, $matches[2]); $this->base_table = preg_replace(‘/[^a-zA-Z0-9]+/’, ”, $matches[3]); Otherwise, it will never call write operation. Frank

Post: Percona XtraBackup 2.1.2 for MySQL available for download

… innobackupex –slave-info option, innobackupex failed with a fatal error. Replaced the fatal error with a diagnostic message about innobackupex –slave…

Comment: Benchmarking Percona Server TokuDB vs InnoDB

… an optimization in which the point query is avoided and replaced by the injection of an upsert message into the root…

Post: Percona XtraBackup 2.0.7 for MySQL available for download

…_id from *.ibd.meta would lead to assertion. Fixed by replacing the assertion with the error message. Bug fixed #1112224. Fixed…

Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL

… nowadays i.e. if you have FULLTEXT you simply cannot replace in short term. Control Your Auto-Incrementing Columns PXC/Galera…