Minimizing Risk with MySQL Group Replication

By | In Blog, MySQL | September 20th, 2017

Your MySQL databases power your business, and every minute of downtime costs more than you want to think about. High availability is essential to your operations, and you can minimize risk with MySQL Group Replication. This MySQL plugin helps your databases in several ways.

  1. Automatic Conflict Detection
    You no longer need to address conflicts in your MySQL databases manually. MySQL Group Replication fixes conflicts when they’re detected, freeing up database administrator time for critical tasks.
  2. Automatic Synchronizing
    When you add a new server to this group, you don’t need to move the data to it. Instead, automatic synchronization brings it up to date. Other changes to the group, such as a server leaving it, also get handled through automation. Expanding to multiple replicated servers eliminates a single point of failure and handles failover behind the scenes. One piece of equipment going down shouldn’t disrupt your entire business operations for the day, and it doesn’t have to with MySQL Group Replication. Necessary group reconfiguration gets handled on the fly, whether something crashes or a server reconnects after coming back online.
  3.  Eliminate Read Requests on Primary Servers
    Another way to minimize the risk to your databases is reducing the number of read requests going to your primary server. MySQL Group Replication routes read requests to the replica servers in the group. You can spread these out among the group servers and add more equipment to further improve availability. This method gives you the opportunity to scale up and down as needed based on your usage. The primary server only accepts write requests.
  4. Automatic Distributed Coordination
    Are you worried about split-brain and message loss with your  MySQL cluster servers? MySQL Group Replication accounts for these issues and protects against them.
  5. Multimaster Mode
    If you’re uncomfortable with a single primary server configuration in your MySQL group, you can implement multi-master mode. Every server in the group can accept read and write requests. If something happens to one of the members, there’s no delay before the group accepts write requests again. A distributed recovery stage brings new servers up to speed before any requests get routed to that piece of hardware.

You have a lot riding on the availability of your MySQL servers. Manage your risk more effectively by adding the MySQL Group Replication plugin to your infrastructure. For more information on MySQL Group Replication please download our white paper “Features, Pros and Cons of MySQL Group Replication” or contact Datavail to learn more.

Contact Us
Charleste King
Lead MySQL DBA
Charleste has more than 15 years of experience in the IT industry in a myriad of areas from software development to data analysis, architecture, and administration. She has worked supporting organizations from the very small to enterprise level in aerospace, agriculture, medicine, education, and other industries. She has developed solutions to unique problems for clients ranging from multi-level upgrades with minimal downtime, compliance conversions, documentation, monitoring, alerting, stabilization, trending, and forecasting problem areas, as well as tuning and performance monitoring.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).

1 thought on “Minimizing Risk with MySQL Group Replication”
  1. Hi Charleste,
    If we add the additional resource of the few days. For Example, our binlog retention period is 1 day. I want to add additional slave after 2 days in Group replication. How can data be recovered? Is this automated for Group replication?