June 20, 2013

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

… recommend Xtrabackup SST for its reduced locking period from its use (which means the donor is blocked for a shorter while… like compression, parallel streaming, encryption, compact backups which can be used for SST (Note, the wsrep_sst_xtrabackup in 5.5… optimizations with HAProxy to account for high connection rates, and using pacemaker with PXC. The goal is to reduce the overhead of…

Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4

…. As notified in RHBA-2013-0375, RedHat encourages people to use Pacemaker in combination with the CMAN manager (It may become mandatory… (such as the Pacemaker daemons) and it’s part of the RedHat cluster stack. If you were using some puppet recipes published… nodes to Pacemaker 1.1.8 but to avoid again issues with the next distribution update, I prefer to use CMAN as…

Comment: ZFS on Linux and MySQL

… OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys can…

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

… situation. Typically DRBD is run in combination with heartbeat or pacemaker or something similar, and if one of the servers in… of having binary logs which are no longer complete or useful for point-in-time recovery. Generally if you’re considering… – I have personally only worked with one customer that’s using 5.6), is that I question its readiness. There have…

Post: The write cache: Swap insanity tome III

… to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and pre-allocate… a few minutes, enough to cause serious issues to the pacemaker setup the server is one of the nodes. That caused….dirty_bytes”, but keep in mind that only one is used; setting one to a non-zero value sets the other…

Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… solution using Pacemaker, a well known and established cluster manager with a bullet proof communication layer. One of the great thing about Pacemaker…. To use this agent, you’ll need a Pacemaker configuration. As a starting point, I’ll discuss the configuration I use during my…. Remember that Pacemaker will start MySQL, not the regular init.d script pid: The pid file. This is use by Pacemaker to know…

Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster

… interest me, I was recently reading the Pacemaker documentation and I realized that Pacemaker has all the logic required to manage NDB… to Pacemaker recently, a Clone resources set, that allows an optional startup if only one of 2 similar resources starts. I use… nodes with /etc/init.d/heartbeat start. Next, since Pacemaker is used to start resources and not to manage them, we don…

Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… with pacemaker going to clusterlabs.org to learn how to set it up, I’m afraid results would be poor – using myself… usability test you should ask people to first search for “Pacemaker documentation” and then learn to set it up. When “clusterlabs… there Pacemaker Explained is what seems to define the essence of Pacemaker. The Pacemaker project should think about this: how should people use Pacemaker easily…

Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… to use VIPs then you need something that will move them around. If you you use Galera and don’t use VIPs, then using Pacemaker… experience there, but I would consider Florian’s advice. If Pacemaker sees that MySQL is not responding, it will try to… to move the functionality provided by mysqld_safe into the pacemaker agent and let pacemaker control everything.

Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… operational tasks depending on how you are used to doing things) you could still use Pacemaker to move VIPs around, even if not Galera. You would then have to write some Pacemaker functionality that is… crashed. Given that mysqld_safe already does that, I consider using Pacemaker for that purpose completely overkill.