…how Percona XtraDB Cluster can be used for High Availability. Basic setup: you run 3-nodes setup. The Percona XtraDB Cluster will continue to…to perform maintenance or make configuration changes. Or Node may crash or become network unavailable. The Cluster will continue to work, you can continue to…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…to propagate nodes. Why MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve following problems: A Real High…to setup three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I am going to…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
…to the MySQL Performance Blog, I joined Percona at the beginning September, I chose to cover the various high-availability (HA) options available for MySQL… process by how a HA setup recovers …Cluster A bunch of servers used for the same task. In our case, dedicated to high availability of the MySQL…
Page: Consulting for MySQL
July 31, 2006 By
…perform schema maintainance setup backup procedures, pro actively monitor server to avoid downtime. Customized Training for MySQL Want your developers to learn MySQL best practices ? How to…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 13 Comments
…mysql-galera-0.6, which had serious flow, to setup a new node you had to take down whole cluster…performs much better than standard InnoDB ®. So what is so interesting about Galera. Couple things: – High…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…setups…MySQL to using MySQL + Memcached, and then to…to always grow and very rarely shrink. Which leads to a challenge faced by almost everyone how do you maintain your performance…cluster, more memcached. We need to cover up the databases inefficiencies to…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…Performance Audit we tend to…cluster…to the MySQL redundancy for very high quality/high scale applications. I’ve seen applications having no downtime running for years on single MySQL…
