Tag: Group Replication

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.23! In addition to several bug fixes and minor changes, some significant enhancements regarding monitoring/troubleshooting and performance were included. MySQL Shell AdminAPI Cluster diagnostics Checking how a Cluster is running and, whenever the cluster is not 100% healthy, perform troubleshooting tasks is certainly one of the main tasks of a DBA. The AdminAPI makes this operation very easy by centralizing the monitoring information in: <Cluster>.status([options]) In this release, we’ve extended the status() command to provide more ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; The MySQL Development team is very happy to announce that MySQL 8.0.23 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release.  Please download 8.0.23 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories. The source code is available at GitHub. You can find the full list of changes and bug fixes in the 8.0.23 Release Notes. Here are the highlights. Enjoy! Invisible Columns Support for INVISIBLE columns  (WL#10905) This work by Praveenkumar Hulakund adds support for INVISIBLE columns. A ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users,MySQL Shell 8.0.23 is a maintenance release of MySQL Shell 8.0 Series (acomponent of the MySQL Server). The MySQL Shell is provided underOracle’s dual-license.MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and5.7. Please upgrade to MySQL Shell 8.0.23.MySQL Shell is an interactive JavaScript, Python and SQL consoleinterface, supporting development and administration for the MySQLServer. It provides APIs implemented in JavaScript and Python thatenable you to work with MySQL InnoDB cluster and use MySQL as a documentstore.The AdminAPI enables you to work with MySQL InnoDB cluster and InnoDBReplicaSet, providing integrated ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; 2020 was a very eventful year at MySQL. Now that we just started 2021, this is a great time to look back at everything we accomplished in 2020, from the anniversary celebrations to the year's best webinars, the best events, the best customer quotes, the best new product addition, the best animated videos, the best social media contribution, the best social media posts and of course, Larry’s best quote and many more.  Here is our "Best of 2020," enjoy!  (We'd love to see your favorites too.  Feel free to share your favorites with us in the comment ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; In this blog, I am going to explain the different ways of electing the PRIMARY node in MySQL group replication. Before MySQL 8.0.2, primary election was based on the member’s UUID, with the lowest UUID elected as the new primary in the event of a failover.From MySQL 8.0.2: We can select the node to be promoted as a PRIMARY using the server weight ( group_replication_member_weight ). This can be achieved during the failure of the current primary node.From MySQL 8.0.12: We can promote any node as a PRIMARY using the function “group_replication_set_as_primary”. This ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; MySQL 8.0.22 introduces Automatic Asynchronous Replication connection failover. This feature makes MySQL asynchronous replication fault-tolerant to source connection failure, by automating the process of re-establishment of a replication connection to another available source. If there are source servers in multiple data centers, the user can also configure the replica to fail over between them, to provide Disaster Recovery from failures of an entire data center. The availability of a database can be maintained by keeping an extra copy of the data in a standby replica that receives it continuously from the source using ... Read More

Feed: Planet MySQL; Author: Marco Tusa; How native ProxySQL stands in failover support (both v2.0.15 and v2.1.0)In recent times I have been designing several solutions focused on High Availability and Disaster Recovery. Some of them using Percona Server for MySQL with group replication, some using Percona XtraDB Cluster (PXC). What many of them had in common was the use of ProxySQL for the connection layer. This is because I consider the use of a layer 7 Proxy preferable, given the possible advantages provided in ReadWrite split and SQL filtering. The other positive aspect provided by ProxySQL, at least for Group Replication, ... Read More

Feed: Planet MySQL; Author: Mirko Ortensi; MySQL highly available solutions, InnoDB Cluster (it uses InnoDB storage engine and is based on Group Replication plugin) and NDB Cluster (NDB storage engine), offer high scalability and redundant topologies. InnoDB Cluster can be configured with up to 9 replicas, in single primary configuration or multi-primary. NDB Cluster instead, while being a much different solution, offers the chance to have up to 4 data nodes replicated for a single shard of data (or node group) and up to a total number of 144 nodes. Redundancy ensures that multiple copies of data exist and are ... Read More

Feed: Planet MySQL; Author: Severalnines; Percona Server for MySQL 8.0 offers a number of clustering solutions for high availability out-of-the-box: Single-master: Asynchronous replication Semi synchronous replication Multi-master: Group replication InnoDB Cluster (a combination of MySQL Router, MySQL Shell and Percona Server with Group Replication) The most popular, battle-tested, and highly scalable solution is, of course, asynchronous replication. In this blog post, we are going to deploy a Percona Server replication setup specifically for high availability. The instructions described here are based on CentOS 7. Installing Percona Server For high availability, we need at least two nodes in a simple master-slave ... Read More

Feed: Planet MySQL; Author: Daniel Nichter; Nov 1, 2020 Let’s answer a question which, to my knowledge, has never been systematically addressed: What are the requirements for a production-ready query metrics app at scale? I am uniquely qualified to answer that because I have written four query metrics apps, two of which are the open-source standard for MySQL: pt-query-digest and the original (v1) code behind the query metrics/analysis part of Percona Monitoring and Management. I’ve also published a couple of packages related to query metrics: go-mysql/slowlog and go-mysql/query. Query Metrics vs. System Metrics Let’s make sure we’re talking about the ... Read More