Introducing the new MySQL InnoDB Cluster Feature
MySQL has had good support for replication for a long time. After all, it is one of the key features that have enabled companies like Facebook, Booking, Twitter and so many others to grow and scale to such extreme scale with MySQL as their primary database engine.…
Hi all, it is time again to do another preview release of MySQL Group Replication, the plugin that brings multi-master update everywhere support to MySQL, like we described in the Hello World post.
We are very proud to present the eighth preview release of MySQL Group Replication plugin, based on MySQL Server 5.7.15.…
When it comes to “decision time” about which type of MySQL HA (high-availability) solution to implement, and how to architect the solution, many questions come to mind. The most important questions are:
Ultimately, the best tool really depends on the needs of your application and your environment. You might already be using specific tools such as Consul or MHA, or you might be looking to implement tools that provide richer features. The dilemma of deploying a proxy instance per application host versus a standalone proxy instance is usually a trade-off between “a less effective load balancing algorithm” or “a single point of failure.” Neither are desirable, but there are ways to implement a solution that balances all …
[Read more]In this post, we’ll discuss how an integrated ProxySQL and Percona XtraDB Cluster (Galera) helps manage node states and failovers.
ProxySQL is designed to not perform any specialized operation in relation to the servers with which it communicates. Instead, it uses an event scheduler to extend functionalities and cover any special needs.
Given that specialized products like Percona XtraDB Cluster are not managed by ProxySQL, they require the design and implementation of good/efficient extensions.
In this article, I will illustrate how Percona XtraDB Cluster/Galera can be integrated with ProxySQL to get the best from both.
Brief digression
Before discussing their integration, we need to review a couple of very important concepts in ProxySQL. ProxySQL has a very important logical component: Hostgroup(s) (HG).
A hostgroup is a relation …
[Read more]I recently had the pleasure of attending the first OpenStack Days East conference in NYC. This was the first OpenStack Days event that we’ve had on the East Coast of the US, but I hope that it’s the first of many!…
Hi all, here is a new post following the blog series on the last MySQLvGroup Replication labs release which already presented: 1) the new features; 2) most asked questions; 3) summary of behaviour and configuration changes; and 4) the performance improvements.…
This blog is a 2nd part of a multi-part series on areas of failover for MySQL. The first installment looked at design considerations, giving us a “thinking” perspective on what we might want to adopt. Later I will take a look at more of a business and operational way of thinking through these details. In… Read More »
Group Replication introduces a new way to do replication in MySQL. With great features such as multi-master replication it brings a range of exciting deployment scenarios where some difficult problems become much easier to solve. Group Replication also brings a new set of options that may need to be configured to extract the highest performance from the underlying computing resources.…
This will be a multi-part series covering various areas of failover for MySQL. This first installment will primarily look at some design considerations, which you can then apply to your own environment in your own way. The concepts presented here are merely suggestions and not out-right “how-to”. Every company has specific technologies or skill-sets in… Read More »
Hi everyone, its been a while since the last release of Group
Replication. During this period we have been working hard to
improve the plugin and give you a better user experience. Focused
on solving several existing bugs, address performance issues and
improving user
experience we renamed some variables, introduced new ones and
changed some of the plugin policies.…