… don’t like DRBD with virtual machines. First is the disk IO performance hit that comes with DRBD. When you run… on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar… Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are going to be talking to the same set…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… if you’re using the Percona XtraBackup with Percona XtraDB Cluster. This release is the latest stable release in the 2… quickly and reliably Uninterrupted transaction processing during backups Savings on disk space and network bandwidth Automatic backup verification Higher uptime due…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… a Galera cluster In the cluster we’re protecting the data as well, though not by ensuring it goes to disk (though you can do that). We protect the data by ensuring it gets to every node in the cluster. But… can be modified cluster-wide is once per RTT. What about WAN clusters? Callaghan’s law applies to WAN clusters as well. LANs…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… one would sync a cluster that, in theory, doesn’t become out-of-sync. As Percona XtraDB Cluster develops, Percona Toolkit will… least four major forks (Percona Server, MariaDB, Percona XtraDB Cluster, and MariaDB Galera Cluster), upgrades are fashionable, so to speak. Problem is… on a server. Granted, this can take a lot of disk space, but it allows you to “run now, compare later…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… is so important to avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup phase and hence… not responsive because of swapping is pretty bad for a cluster and we often ended up is strange, unexpected states. What… like: pt-stalk, vmstat, top, iostat, etc all saving to disk with the current time stamp in front of each line…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…need two things: media with records(ibdata1, *.ibd, disk image, etc.) and a table structure. Indeed, there… | NAME | ID | N_COLS | TYPE | MIX_ID | MIX_LEN | CLUSTER_NAME | SPACE | +————–+—–+——–+——+——–+———+————–+——-+ | sakila/actor | 741 | 4 | 1 | 0 | 0 |…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
… right now and don’t see the same kind of disk i/o on it that I have seen when running… seconds on mariadb 5.5, while the galera two-node cluster seems to get it done in 11-14 seconds. This…
Comment: Finding your MySQL High-Availability solution – The questions
October 17, 2009 By 36 Comments
Gerry, NDB cluster can do rolling restarts, so the cluster can stay available during the restart. http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-rolling-restart.html You can also use disk based tables with only the indexed…/5.1/en/mysql-cluster-disk-data.html http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-ndbd-definition.html#ndbparam…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… equivalent to a ping RTT to the furthest node Automatic cluster synchronization, both incremental and full restores The ability to read… be guaranteed to succeed (unless something weird happens like the disk fails or the server crashes) because it acquired all the… have already guessed, but Galera does not use pessimistic locking cluster-wide, it uses optimistic locking. Initially a transaction on PXC…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… of the article lets comment on IO vs Disk question. If you look at Disk Based databases all data accesses are treated… if you’re doing INSERT you will need to fetch clustered index page at least to do it. These reads are… multiple outstanding IOs case – Matt points out the issue of disk contention people constantly forgot about. If you ask most people…
