Tag: Group Replication

Feed: Planet MySQL; Author: Valeriy Kravchuk; More than 2 months passed since my previous review of active MySQL bug reports I am subscribed to, so it's time to describe what I was interested in this summer.Let's start with few bug reports that really surprised me:Bug #91893 - "LOAD DATA INFILE throws error with NOT NULL column defined via SET". The bug was reported yesterday and seem to be about a regression in MySQL 8.0.12 vs older versions. At least I have no problem to use such a way to generate columns for LOAD DATA with MariaDB 10.3.7. Bug #91847 - "Assertion `thread_ids.empty()' ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; Several MySQL releases happened yesterday, but of them all I am mostly interested in MySQL 5.7.23, as MySQL 5.7 (either directly or indirectly, via forks and upstream fixes they merge) is probably the most widely used MySQL GA release at the moment.In this post (in a typical manner for this "Fun with Bugs" series)  I'd like to describe several bugs reported by MySQL Community users and fixed in MySQL 5.7.23. As usual, I'll try to concentrate mostly on InnoDB, replication, partitioning and optimizer-related bugs (if any).Checking MySQL release notes is like swimming with dolphins ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Shell 8.0.12 is a maintenance release of MySQL Shell 8.0 Series(a component 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 and 5.7.Please upgrade to MySQL Shell 8.0.12. 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, ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; The MySQL Development team is very happy to announce that MySQL 8.0.12, the first 8.0 Maintenance Release, is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release, most notably the InnoDB instant add column feature.  Please download 8.0.12 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.12 Release Notes. Here are the highlights. Enjoy! Instant Add Column Support Instant ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Francisco Bordenave | July 20, 2018 |  Posted In: High-availability, InnoDB, Insight for DBAs, Insight for Developers, JSON, MySQL PREVIOUS POST Welcome to the third part of this series. I’m glad you’re still reading, as hopefully this means you find this subject interesting at least. Previously we presented the first two components of MySQL InnoDB Cluster: Group Replication and MySQL Router and now we will discuss the last component, MySQL Shell. MySQL Shell This is the last component in the cluster and I love it. Oracle have created this tool to centralize cluster management, providing a friendly, ... Read More

Feed: Planet MySQL; Author: Tony Darnell; MySQL 8.0 Group Replication – Three-server installation July 13, 2018 Leave a comment MySQL InnoDB Cluster was introduced in MySQL version 5.7. MySQL InnoDB Cluster consists of three parts – Group Replication, MySQL Shell and MySQL Router. MySQL InnoDB Cluster provides a complete high availability solution for MySQL. I am not going to go into the details of InnoDB Cluster and how it works, as there are enough manual pages and blogs to cover these topics. MySQL InnoDB Cluster manual Blog sites: mysqlhighavailability.com and mysqlserverteam.com. Instead, I will be showing you how to install Group ... Read More

Feed: Planet MySQL; Author: Shree Nair; MySQL 8 introduced a number of enhancements to improve both replication performance and the monitoring thereof. Improvements included more efficient replication of small updates on big JSON documents, the addition of Performance Schema tables for slave performance metrics, tracing and debug logging improvements, among others. With regards to monitoring, Group Replication has been improved by introducing new replication timestamps, additional columns to the performance schema, as well as by making the relationship between replication threads more efficient. We covered the various improvements to replication performance in the Replication Performance Enhancements in MySQL 8 blog ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; Further to our earlier blog post about Fail-safe enhancements to Group Replication, where we discussed enhancements against data modification in members which are not ONLINE, we now present here additional changes to protect data from being accidentally modified by asynchronous replication channels. Asynchronous replication is one of the pillars of MySQL and widely used with MySQL databases. They are also widely used across Group Replication clusters to scale out the reads by connecting asynchronous read slaves to a group and to bind groups together with circular replication for the wide area clusters. We ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Francisco Bordenave | July 16, 2018 |  Posted In: High-availability, InnoDB, Insight for DBAs, MySQL, open source databases PREVIOUS POST MySQL InnoDB Cluster is an Oracle High Availability solution that can be easily installed over MySQL to provide high availability with multi-master capabilities and automatic failover. In the previous post we presented the first component of InnoDB Cluster, group replication. Now we will go through the second component, MySQL Router.  We will address MySQL Shell in a final instalment of this three-part series. By then, you should have a good overview of the features offeed by MySQL InnoDB Cluster. MySQL ... Read More

Feed: Planet MySQL; Author: Severalnines; One of the cool features in Galera is automatic node provisioning and membership control. If a node fails or loses communication, it will be automatically evicted from the cluster and remain unoperational. As long as the majority of nodes are still communicating (Galera calls this PC - primary component), there is a very high chance the failed node would be able to automatically rejoin, resync and resume the replication once the connectivity is back. Generally, all Galera nodes are equal. They hold the same data set and same role as masters, capable of handling read ... Read More