… 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: 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…
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: 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: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… 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…
Page: Consulting for MySQL
July 31, 2006 By
… architecture which matches your application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced…, install security updates, perform schema maintainance setup backup procedures, pro actively monitor server to avoid downtime. Customized Training for MySQL Want…
Comment: Why you don't want to shard.
August 18, 2010 By 33 Comments
… having active/active nodes… oops shards (;-)). Well you got my point 
It competes seriously peer-to-peer replication, mirroring, log shipping and clustering!
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… Availability Some people are got used to using SAN based active-passive clusters for availability purposes and they look to do the… really had it) Even if you do not run any “Cluster” having SAN you can always “connect” the storage to another…
