…is a Corosync plugin that monitors the names and number of active cluster… look at what happens if we have a cluster with 3…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
…What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based on what…MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster…
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… catches my attention. There is also PDF with more details available Oli is saying you can use MySQL with Active Active Clustering and MyISAM tables if… go, and in theory this is what should work. In practice however you should think about what exactly are you looking for with… sometimes your Boss simply heard Active Active clustering is cool and you should just set up that one with MySQL is yet another argument to use…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… is done in parallel to all nodes at once). This sounds all well and good, but what is the tradeoff? Not locking resources cluster… 1 Changed: 1 Warnings: 0 node1 mysql> SHOW ENGINE INNODB STATUS\G … ———— TRANSACTIONS ———— … —TRANSACTION 83B, ACTIVE 50 sec 2 lock struct(s), heap…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… 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… queue is > 0. Instead brute force aborts are applying writesets rolling back locally open transactions. In fact, this is a sysbench test what is…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…(not a transaction). Transaction is not guaranteed to be applied – what is guaranteed is that every node … range. It opens the possibility for active master – active master setups. You can write … to setup three node cluster is much more complex than an average MySQL master-slave setup. Potential…
Post: Percona Server 5.5.15 + Galera 21.1-beta2
October 3, 2011 By 18 Comments
… play it to gain some play-and-touch experience. So What is Percona Server+Galera at the end ? I wrote about this… is radically different from regular MySQL replication. You can actually think about N-nodes Percona Server+Galera setup as Cluster. where each node is active (accepts both reads and writes). You can perform writes to ANY node. Setup of 3-master active MySQL Replication is…
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 45 Comments
…write about using MySQL Partitioning for Performance Optimization …clustered around most recent id values. The table (and index) is … of partitions which were actively used could fit in …What is a take away ? When you’re creating partitions think clearly what you’re trying to archive. Partitioning is…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… critical. Now what is about MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable transactions the log write latency is triple important… active-passive clusters for availability purposes and they look to do the same with MySQL. This works though I do not think it is…
Post: Percona Live MySQL Conference and Expo 2013 - News from the Committee - Part 1
November 8, 2012 By Leave a Comment
… However, my observation so far is that it is the individual biases and … the proposals that we’ve actively invited people to submit on. … time have good details on what will be covered clearly delineate …Percona XtraDB Cluster Lots and lots of practical MySQL experience Great products in the MySQL …
