…the problem): [root...cluster, perform the following command on one server only: [root@percona1 ~]# ccs -f /etc/cluster/cluster…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
…volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because …MySQL and OS-level status variables that you might want to keep an eye on to prevent a problem…that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…This scenario can happen when you want to perform a planned failover. With GTIDs, all the… the cluster a monotonically incremental identifier for each event. Notice that this is the same problem …For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… to announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are… impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona XtraDB Cluster has fixed number of… Cluster 5.5.30-23.7.4 are available in our online documentation. We did our best to eliminate bugs and problems…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…client is forced to correct the problem before it can commit. It …MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…cluster nodes simultaneously. You can. It does NOT set an lower bound on performance, only a upper bound. The best performance…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…state before updating. This caused some problems for some users, especially if …binary packages remain unchanged. Percona XtraDB Cluster was also affected by this …MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster… not responsive because of swapping is pretty bad for a cluster and we often ended up is strange, unexpected states. What… writes were cached and the write cache was causing the problem. It happened that the setting vm.dirty_ratio was set…
Page: Consulting for MySQL
July 31, 2006 By
… 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 Replication performance problems. MySQL Operations and Administration Assistance with MySQL Server installation and configuration, working out Operations practices – MySQL Security, MySQL Upgrades, Backup…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
…’d expect folks interested in efficient schema design for high performance to get a lot of out of Rick’s talk… a MySQL conference. There are several MySQL HA related tutorials: Using Tungsten Replicator to solve replication problems (3 hr) Ramp-up tutorial for MySQL Cluster – Scaling with continuous availability (6 hr) Percona XtraDB Cluster / Galera in Practice…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… test to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is… without any problem and when the dead node comes back it will perform its IST or SST. In conclusion: 2 nodes cluster is possible with Percona XtraDB Cluster but it’s…
