June 20, 2013

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

… focuses on the key aspects of synchronous replication setup with high-availability guarantees like split-brain immunity. Nobody likes to debug async… they have automated this with a HAProxy in each AZ (Availability Zone) for the API server. To add, we are looking….5.31), looking for optimizations with HAProxy to account for high connection rates, and using pacemaker with PXC. The goal is…

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

….6.11-60.3 on June 3rd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL… using InnoDB heap allocation. This may improve write performance for high levels of concurrency. Bug fixed #1185686. Under very rare circumstances… Percona Server for MySQL 5.6.11-60.3 are available in our online documentation. Bugs can be reported on the…

Post: Percona XtraBackup 2.1.3 for MySQL available for download

…, 2013. Downloads are available from our download site here and Percona Software Repositories. This release fixes a high priority bug. It’s… all the bugfixes for Percona XtraBackup 2.1.3 are available in our online documentation. Bugs can be reported on the…

Post: Percona MySQL University @Portland next Monday!

… Percona’s RemoteDBA team, will talk about MHA for MySQL High Availability in the Cloud Matt Yonkovit, our VP of Consulting, will…

Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)

… will appear like hot backups, online schema changes, replication based high availability (which has some caveats). Also, because of asynchronous replication, you…

Post: 10 years of MySQL User Conferences

… announced during this event; “High Performance MySQL” 1st edition written by Jeremy and Derek was also available. MySQL 4.0.18 was… more funky version differences for MySQL Enterprise, just certain features available only in Enterprise edition as plugins. Early preview of plans… Percona XtraDB Cluster as GA – the new approach to MySQL High Availability in and out of the Cloud. MySQL 5.5.23…

Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

… libjemalloc library. For RPM/deb packages, this library will be available for download from our repositories. Benchmark showing the impact of… and evs.user_send_window could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL port would…. Bug fixed #1111672 (Alexey Bychko). Only rpm debug build was available for Percona XtraDB Cluster, fixed by providing the deb debug…

Post: Percona XtraBackup 2.1.0 for MySQL beta now available

… is not intended for production. If you want a high quality, generally available release, the current stable version should be used (currently… master nor slave in replication) and binlog information wasn’t available. Fixed by not creating xtrabackup_binlog_info file when binlog isn’t available. Bug fixed #1168513. Fixed the typo in the innobackupex error…

Post: High-load problems? Investigate them with 'pt-query-digest'

… pt-query-digest. One customer was suffering from periods of high load on their database server, leading to degraded application performance… at the time the problem happened. As I began reviewing available captures, I was able to correlate most load peaks with… that. Granted, this means there is no run time data available, but at least you get a nice ranking of queries…

Post: Is your MySQL buffer pool warm? Make it sweat!

…’s on your mind! There are numerous solutions for MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a… catch that? What does that mean? In most of these high-availability solutions it means that mysqld is running on the standby…