- Total activity 126
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 2
- Subscriptions 61
PostsVotes on activity by Severalnines Support Sort by votes
Limitations in Galera Cluster for MySQL
In MySQL-5.5.x/wsrep-23.x, Galera Replication has some limitations, these are documented in readme-wsrep. Galera replication originally only worked with InnoDB storage engine, but it now also supp...
How do I configure and deploy a recommended MySQL Replication setup?
A MySQL Replication cluster can be configured using the Severalnines Configurator: http://www.severalnines.com/replication-configurator/ The wizard collects some high level data (e.g. IP address...
Recommended topology for MySQL Replication
A recommended MySQL Replication topology would be constructed so that it takes advantage of the strengths of Replication, and minimizes the weaknesses of the protocol. Some recommendations: - ...
What is the difference between standard MySQL Replication and Galera Replication?
MySQL Replication is part of the standard MySQL database, and is mainly asynchronous in nature. Updates are always done on one master, and these are propagated to slaves. It is possible to create a...
Setting up HAProxy
Severalnines has created deployment scripts for HAProxy. These are available on GitHub.The scripts work with any Galera or MySQL Cluster setup that has been deployed using the Severalnines Configur...
What is HAProxy?
HAProxy stands for High Availability Proxy, and is a great TCP/HTTP load balancer. It distributes a workload across a set of servers to maximize performance and optimize resource usage.A front-end ...
Handling of master server failure
Updates are done on the master server only. If the master fails, replication will stop. Applications doing updates reconnect to the backup master and then continue to operate. Effectively, the bac...
Adding a new node to a Galera Replication cluster
Adding a new node is automatic with Galera. It follows the same process as recovering a failed node. When the node is introduced, ClusterControl™ will select a ‘donor’ and do a full state snapshot ...
How do I deploy a Galera Replication cluster?
A Galera Replication cluster can be configured using the Severalnines Configurator: http://www.severalnines.com/galera-configurator/ The wizard collects some high level data (e.g. IP addresses of ...
What is Certification based Replication?
Certification based replication uses group communication and transaction ordering techniques to achieve synchronous replication. Transactions execute optimistically in a single node (or replica) an...