We carefully listened to the feedback we got from the last preview release and incorporated most of the suggested changes, the rest will follow in the next release.
Here are the highlights of this release!
Remote Instances support
The last preview release of InnoDB cluster only allowed to work with sandbox instances on localhost.…
The MySQL Development Team is happy to announce a new release of the MySQL InnoDB Cluster – 5.7.17 Preview, now available for download at http://labs.mysql.com/. This release contains the following packages.
Extremely exciting news! A big day today. In case you have missed it, MySQL Group Replication has made it into the MySQL 5.7.17 release. Thus, it is now GA.
The MySQL Group Replication feature is a multi-master update anywhere replication plugin for MySQL with built-in conflict detection and resolution, automatic distributed recovery, and group membership.…
In this blog post, I’d like to take a look at a few different things such as MySQL Group Replication, multi-instance MySQL setups on systemd and shell scripting the whole mess to make it easy to build, and easy to rebuild. To be honest, it took a little help from Shinguz’s blog to get the… Read More »
In this blog I will provide answers to the questions and queries that some of you have raised during the webinar on Nov 17th.
I would like to say thank you to all of the audience who attended the talk on November 17, 2016. You can also check the recording and slides here.
Q. How is storage distribution done across the node?
A. Each node has independent storage and other resources. There is no sharing of resource. Only the write-sets are replicated.
Q. If write-set propagation fails in some manner is there any retry mechanism?
A. write-set are written to …
[Read more]Join Percona’s Percona XtraDB Cluster Lead Software Engineer Krunal Bauskar for a webinar on Thursday, November 17, 2016, at 7:30 am PST on MySQL High Availability with Percona XtraDB Cluster 5.7.
Percona XtraDB Cluster 5.7 is our brand new MySQL 5.7 compatible Galera-based high availability (HA) solution. Whether you’re new to MySQL clustering technology, or experienced with Galera-based replication, this tutorial provides great insights into working with the software, …
[Read more]In this blog post, I am going to show you how can you use Orchestrator and ProxySQL together.
In my previous blog post, I showed how to use bash scripts and move virtual IPs with Orchestrator. As in that post, I assume you already have Orchestrator working. If not, you can find the installation steps here.
In the case of a failover, Orchestrator changes the MySQL topology and promotes a new master. But who lets the application know about this change? This is where ProxySQL helps us.
ProxySQL
You can find the ProxySQL install steps …
[Read more]This is a description of the simplest case of 2-phase commit (2PC) in NDBCluster: one transaction, containing a single insert, update or delete operation on a single row. The PREPARE phase of the 2PC is initiated by the API node (which is a mysqld or a NoSQL client) sending a TCKEYREQ to the Transaction Coordinator of a data node.…
In this post, I’ll discuss how to moving VIPs during a failover using Orchestrator.
In our previous post, we showed you how Orchestrator works. In this post, I am going to give you a proof-of-concept on how Orchestrator can move VIPs in case of failover. For this post, I’m assuming the Orchestrator is already installed and able to manage the topology.
Hooks
Orchestrator is a topology manager. Nothing less nothing more. In the case of failover, it will reorganize the topology, promote a new master and connect the slaves to it. But it won’t do any DNS changes, and it won’t move VIPs (or anything else).
However, Orchestrator supports hooks. Hooks are external scripts …
[Read more]How does an application configure its database connection? I find this to be a pretty interesting question. As the application moves from a developer’s workstation to a test harness, then to staging, and on to production, the database connection properties can change each time. …
