…Corosync plugin that monitors the names and number of active cluster nodes in order to deliver membership and quorum …MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… NIC.] The other two NIC ports should be bonded with active-backup or LACP (depending on your switching infrastructure). In essence… MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are…
Post: Minimizing Downtime from Lengthy AWS Outages
October 24, 2012 By 7 Comments
… EBS data directory on another instance and simply fire up MySQL. This works wonderfully unless EBS is the component experiencing the… cluster. Overall, issues like this are inevitable and will likely cause at least some downtime or degraded service (unless you run active/active…
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… with more details available Oli is saying you can use MySQL with Active Active Clustering and MyISAM tables if you follow certain rules like… takes long time for large tables. Furthermore as I remember MySQL simply was not repairing corrupted tables in this configuration even… sometimes your Boss simply heard Active Active clustering is cool and you should just set up that one with MySQL is yet another argument…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… already guessed, but Galera does not use pessimistic locking cluster-wide, it uses optimistic locking. Initially a transaction on … 1 Changed: 1 Warnings: 0 node1 mysql> SHOW ENGINE INNODB STATUS\G … ———— TRANSACTIONS ———— … —TRANSACTION 83B, ACTIVE 50 sec 2 lock struct(s), …
Page: Consulting for MySQL
July 31, 2006 By
… matches your application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL Replication consulting including chained and circular replication, bi-directional replication, troubleshooting MySQL…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is an OCF… cluster using any number of fault-tolerant configurations (active/passive, active/active, N+1, etc.) It also provides messaging between servers within the same cluster…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… be in an acceptable range. It opens the possibility for active master – active master setups. You can write on both masters and… observation, the task to setup three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty… now a node gets disconnected from the cluster, in order to join to the cluster again, it has to copy the whole…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the best… (with some new features) to watch the traffic on the active master and replay SELECT queries against the passive one. I…-digest to watch the traffic on the active master: mk-query-digest –processlist h=active \ –filter ‘$event->{arg} =~ m/^SELECT/i’ –execute…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
…. This is the state of this partition of the cluster. If a cluster gets split brained, then only a quorum (>=51%) of…’. Our cluster is Primary and there are 3 nodes total belonging to it. There isn’t any replication queue activity, and I find this is common except during cluster stalls. There are clearly a fair…
