Tag: Group Replication

Feed: Planet MySQL; Author: Oracle MySQL Group; As with any new releases, MySQL 8.0.21 introduces many new improvements and updates, many of which deserve their own blog post for a deep dive into the new features. Among the notable changes are: Account Management Notes, JSON Notes, Authentication Notes and changes related to InnoDB, Optimizer, Group Replication, and more. Here are the MySQL 8.0.21 top blog posts: Server: - The MySQL 8.0.21 Maintenance Release is Generally Available - MySQL 8.0 – Who stopped mysqld and how long did it take? - MySQL: who’s filling my error log? Shell: - MySQL Shell ... Read More

Feed: Planet MySQL; Author: Kristian Köhntopp; MySQL speaks its own proprietary protocol. It cannot be routed by a HTTP proxy, and a MySQL connection is entire unlike a HTTP connection. Specifically, a lot of state and configuration is tied to a MySQL connection, and it cannot be recovered on disconnect.What state is tied to a connection? Transactions A disconnect implies a ROLLBACK. So if you are in a transaction, all changes to the database that you attempted are lost, rolled back, as if they never happened. It is not enough to retry the last statement, you need to jump back ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; As Group Replication (GR) matures and it is deployed in a myriad of different systems, we begin to witness specific network conditions that we must be able to cope with in order to make Group Replication more tolerant and robust to those failures. This post will describe the enhancements that were made to support certain scenarios, which will guarantee that GR will continue to provide service. Gradual Group Degradation support The presence of an unstable network can cause nodes to constantly drop the network connections of XCom’s fully connected mesh. Unstable networks can ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; I wanted to be brave and I installed MySQL Group Replication manually…. it was painful ! Then I realized that managing those servers and especially deal with MySQL Routers was even more painful ! What are my options now ? Is there a solution or do I need to restart from scratch ? Asking the answer is already answering it… and once again MySQL Shell at the rescue. MySQL Group Replication I’ve configured everything manually. I also loaded group_replication and clone plugins and finally after having bootstrapped my Group here is what I have: ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; From MySQL 8.0.21 onwards, START GROUP_REPLICATION includes new options which allow a user to specify credentials to be used for distributed recovery. You can now pass credentials when invoking START GROUP_REPLICATION instead of setting them when configuring the group_replication_recovery channel. START GROUP_REPLICATION command now has the options: USER: User name. Cannot be set to an empty or null string or left unset if PASSWORD is used.PASSWORD: Password.DEFAULT_AUTH: Name of the authentication plugin; default is MySQL native authentication.When credentials are passed as parameters to START GROUP_REPLICATION command, credentials are not persisted.Therefore, when group replication ... Read More

Feed: Planet MySQL; Author: Nuno Carvalho; Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available. In order to allow DBAs to do post observation of the main events on a group lifetime, it is essential that those events are always logged. Users could already instruct the server to do that by increasing verbosity of the error log before 8.0.21. There is an easier way now. On MySQL ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; Group Replication distributed recovery is one of the key features and until now it was restricted to be executed over one mysql connection point automatically defined on mysql system variables port and host. With group_replication_recovery_endpoints we can specify through which interfaces can group replication recovery take place for a given member so that it controls where recovery traffic flows in the network infrastructure. For each server we can configure a comma separated list of local endpoints and every endpoint contains information about the host and port. An endpoint host can be specified with: ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; MySQL Group Replication allows you to create an highly-available replication group of servers with minimum effort. It provides automated mechanisms to detect and respond to failures in the members of the group. The response depends on the characteristics of each failure and it is configurable. In order to decrease the need for manual user intervention whenever there is a temporary network partition or a server slowdown in MySQL 8.0.21 we have changed the default values of two system variables: group_replication_member_expel_timeout group_replication_autorejoin_triesIn this blog post we will review MySQL Group Replication’s mechanisms to detect ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; MySQL Router is a core component of InnoDB cluster/ReplicaSet that enables the automatic routing of client traffic to the right instances of your database architecture. Router can automatically adapt to topology changes, however, there are some scenarios on which one would certainly benefit from having the possibility to tag an instance with a certain attribute that indicates a specific behavior change to Router’s default behavior. In the 8.0.21 release, we have introduced a tagging framework to the AdminAPI which ultimately allowed us to introduce a very demanded feature: Hide Cluster/ReplicaSet instances from ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.21! As always, we have listened to the growing community of users and introduced a very useful feature for any production deployment of MySQL InnoDB cluster or ReplicaSet. Also, since we’re talking about a patch release, quality has been improved with several bugs fixed! MySQL Shell AdminAPI This release focused on introducing a tagging framework for the AdminAPI, which ultimately allowed us to introduce a very demanded feature: As usual, we would like to ... Read More