Tag: Group Replication

Feed: Planet MySQL; Author: Severalnines; Replication in MySQL has been around for a long time, and has been steadily improving over the years. It has been more like evolution rather than revolution. This is perfectly understandable, as replication is an important feature that many depend on - it has to work. In the last MySQL versions, we’ve seen improvements in replication performance through support for applying transactions in parallel. In MySQL 5.6, parallelization was done on schema level - all transactions which have been executed in separate schemas could be executed at once. This was a nice improvement for those ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; MySQL Group Replication: read your own write across the group – lefred's blog: tribulations of a MySQL Evangelist Today is my last day in Asia (China and Taiwan), and between the sessions I had the time to code a small proof-of-concept for people that are asking how they could read their writes on all nodes and ensure the read consistency with their last write ? The usual (and easier) answer to this particular question is to read on the same host you just wrote. But currently MySQL provides you all the elements to force ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Recently I wrote a blog post on how to use ProxySQL with 8.0.2 dmr This blog post was related to the change we implemented in the Group Replication’s monitoring (performance_schema tables) and how sys schema should be changed to modify the view used by ProxySQL according. However, I used my labs machines that I was using for different purposes too and some changes I made hid a problem that avoid ProxySQL to work with the new defaults in MySQL 8.0.2. Thank you Andy for discovering this. In fact the new collation default (utf8mb4_0900_ai_ci) is ... Read More

Feed: Planet MySQL; Author: Marco; Recently Fred published a post (http://lefred.be/content/mysql-group-replication-is-sweet-but-can-be-sour-if-you-misunderstand-it) in which he was stating, I had publish my blog (http://www.tusacentral.net/joomla/index.php/mysql-blogs/191-group-replication-sweet-a-sour.html) which contains few “misunderstanding”. All the people that knows me, also know I have no problem to admit if I do a mistake, at the end doing mistake is a way of learning and be afraid of the ones who don’t do them. But at the same time, I need to have proof of it. As I provide proof of what I wrote with numbers and tests (all available on github). Let us put down the basis of ... Read More

Feed: Percona Database Performance Blog. Author: Marco Tusa. Marco Tusa  | August 1, 2017 |  Posted In: GTID, High-availability, InnoDB, MySQL, Percona XtraDB Cluster, PMM PREVIOUS POST In this blog, we’ll look at group replication and how it deals with flow control (FC) and replication lag.  In the last few months, we had two main actors in the MySQL ecosystem: ProxySQL and Group-Replication (with the evolution to InnoDB Cluster).  While I have extensively covered the first, my last serious work on Group Replication dates back to some lab version years past. Given that Oracle decided to declare it GA, and Percona’s decision ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; MySQL Group Replication: who is the primary master – updated! – lefred's blog: tribulations of a MySQL Evangelist Some time ago I wrote this article explaining how to find which node was the Primary Master in a MySQL Group Replication cluster running in Single-Primary Mode. In the latest release of Group Replication, MySQL 8.0.2 dmr, Jaideep improved the visibility of Group Replication extending the performance_schema tables (see his article). Thanks to these improvements, it’s now very easy to find which host is acting a Primary-Master. This is the query you can use: mysql-sql> SELECT ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; In initial Group Replication release,  5.7.17, we included the Single-Primary Mode with automatic membership and fail-over features. The MySQL Server 8.0.2 release has brought further enhancement to Group Replication Single-Primary Mode that will allow users to influence primary member election using integer member weight value. Introduction In the Single-Primary mode, before the current MySQL Server 8.0.2 release, the first member of the group, which is sorted in lexicographical order of server_uuid’s, was chosen as the primary member. When the user wanted to prioritise certain members for the primary member election, he had to provide the ... Read More

Feed: Planet MySQL; Author: The Pythian Group; This Log Buffer Edition covers Oracle, SQL Server and MySQL.Oracle:Protecting Financial Data with Oracle WebCenter and Adobe LiveCycleOracle Forms 12c oracle.security.jps.JpsException Error after Database changeThe Future of Content Management: Oracle Content & Experience CloudToday Oracle released a very large „monster“ Upgrade. This July 2017 Update includes the first time the new RU „Release Upgrade“ and RUR „Release Update Revision“ Patches.Cloud Ward: Who Will Win the Battle for IT’s Future?SQL Server:SQL Server Management Studio add-insResolve Network Binding Order Warning in failover clusterQueries to inventory your SQL Server Agent JobsSQL Server 2016 ColumnStore Index String ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; More than 3 months after 5.7.18 we' ve got MySQL 5.7.19 released recently. This is my quick review of the release notes with interesting fixed bug (reported in public) highlighted in the areas I am usually interested in.Let's start with InnoDB. The following bug fixes attracted my attention:Bug #85043 is still private. You know how much I hate those. At least we can see it was about the fact that "The server allocated memory unnecessarily for an operation that rebuilt the table." Let's hope this is no longer the case. Bug #84038 - "Errors when ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; In MySQL 8.0.2, users will see the additional columns in the existing Group Replication Performance Schema tables which will provide extended information about Group Replication. Now user can view role and MySQL version of each member of the group, which earlier required a complex set of query. The user can also see additional statistics of each member of the group, like remote applier queue count, remote transactions applied, number of transactions proposed by member and number of proposed transactions rolled back by the group. These have been a constant request from the users of the Group Replication plugin ... Read More