… a Corosync plugin that monitors the names and number of active cluster nodes in order to deliver membership and quorum information to… nodes: [root@percona1 ~]# scp /etc/cluster/cluster.conf percona2:/etc/cluster/ [root@percona1 ~]# scp /etc/cluster/cluster.conf percona3:/etc/cluster/ Enable CMAN at startup on…
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… 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: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… details available Oli is saying you can use MySQL with Active Active Clustering and MyISAM tables if you follow certain rules like enabling… prevent race condition. Of course sometimes your Boss simply heard Active Active clustering is cool and you should just set up that one…
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…, and from my observation, the task to setup three node cluster is much more complex than an average MySQL master-slave… now a node gets disconnected from the cluster, in order to join to the cluster again, it has to copy the whole…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… have already guessed, but Galera does not use pessimistic locking cluster-wide, it uses optimistic locking. Initially a transaction on PXC…: 0 node1 mysql> SHOW ENGINE INNODB STATUS\G … ———— TRANSACTIONS ———— … —TRANSACTION 83B, ACTIVE 50 sec 2 lock struct(s), heap size 376, 1…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… to be applied on the other nodes, so in an active-active cluster you can scale these read-write transactions about 4-5x…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… 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. Pacemaker manages the resources and applications on a node within the cluster. I have created a…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
…-node cluster. In case you don’t know what to think of that, I’ll tell you: scaling a synchronously replicated, active-active master, fully ACID, always-consistent database to a 40-server cluster is impressive. Yes, it comes… at all in a one-node cluster, and not the same way in a two-node cluster as it does at higher…
Comment: MySQL Sizing questions
February 9, 2012 By 4 Comments
… a NewsPaper and we have 6K of visits daily. This cluster include: 2 Web Servers with Port:100Mbps, i7 QuadCore- 2… servers active-active controlled by loadbalancing HA proxy. PHP installed. Apache Server. 2 Database server with the same configuration, but active-pasive controlled… 2.4 Ghz with 1GB of RAM. (each one) Our cluster solution include a 20 TB of Bandwith and 100Mbps of…
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…
