Buy Percona ServicesBuy Now!

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

 | May 19, 2010 |  Posted In: Insight for DBAs, MySQL

Customers have always asked me to make NDB Cluster starts automatically upon startup of the servers. For the ones who know NDB Cluster, it is tricky to make it starts automatically. I know at least 2 sets of scripts to manage NDB startup, ndb-initializer and from Johan configurator www.severalnines.com. If all the nodes come up […]

Read More

Debugging problems with row based replication

 | May 6, 2010 |  Posted In: Insight for DBAs, MySQL

MySQL 5.1 introduces row based binary logging. In fact, the default binary logging format in GA versions of MySQL 5.1 is ‘MIXED’ STATEMENT*;   The binlog_format  variable can still be changed per sessions which means it is possible that some of your binary log entries will be written in a row-based fashion instead of the […]

Read More

Is DRBD the right choice for me?

 | July 7, 2009 |  Posted In: Insight for DBAs

It seems pretty common to find customers install DRBD for the wrong reasons. There are many pros/cons to compare DRBD to replication, but I’ve managed to cut down my spiel I give to customers to these two points: DRBD’s aim (assuming replication mode C) is to provide 100% consistency, and then as much uptime as […]

Read More