Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 804 10 Older Entries

Displaying posts with tag: Replication (reset)

A discussion about sync-master-info and other replication parameters
+0 Vote Up -0Vote Down

Some time ago, feedback was requested on new replication default after MySQL 5.7.  Some of the suggested default are:

relay-log-info-repository = TABLE (previous default FILE) relay-log-recovery = ON (previous default OFF) master-info-repository = TABLE (previous default FILE) sync-master-info = 1,000 (previous default 10,000) sync-relay-log = 1,000 (previous default 10,000)

I agree on the

MySQL Group Replication: securing the perimeter!
Employee_Team +1 Vote Up -0Vote Down

Hi all, here is a new post following the blog series on the last MySQLvGroup Replication labs release which already presented: 1) the new features; 2) most asked questions; 3) summary of behaviour and configuration changes; and 4) the performance improvements.…

Tuning MySQL Group Replication for fun… and profit!
Employee_Team +1 Vote Up -0Vote Down

Group Replication introduces a new way to do replication in MySQL. With great features such as multi-master replication it brings a range of exciting deployment scenarios where some difficult problems become much easier to solve. Group Replication also brings a new set of options that may need to be configured to extract the highest performance from the underlying computing resources.…

Announcing: MySQL Utilities release-1.6.4 GA
Employee +1 Vote Up -0Vote Down

The MySQL Utilities Team is pleased to announce a new GA release of MySQL Utilities. This release includes a number of improvements for usability, stability, and a few enhancements for better compatibility with MySQL 5.7. A complete list of all improvements can be found in our release notes.

Many Improvements!
This release represents a stable release of the product and is a significant improvement from the 1.5 release. Along with defect patches, we also include the following enhancements.

  • Support for …

  [Read more...]
MySQL Group Replication for 5.7.14
Employee_Team +0 Vote Up -0Vote Down

Hi everyone! It has been some time since the last MySQL Group Replication labs release was out. But the team has not been sitting on its hands. As such, it is time for a new labs release with new features, bug fixes and improvements across the board.…

Fun with Bugs #44 - Community Bugs Fixed in MySQL 5.7.14
+3 Vote Up -0Vote Down

MySQL 5.7.14 was officially released yesterday. So, it's time to check what bugs reported by MySQL Community in public were fixed in this release. Some of these bugs are presented below.

As usual, let me start with InnoDB. The following bugs were fixed there:

  • Bug #80296 - "FTS query exceeds result cache limit". It was reported (for 5.6, but I do not see new 5.6 release notes yet) by Monty Solomon and verified by …

  [Read more...]
Rescuing a crashed pt-online-schema-change with pt-archiver
+0 Vote Up -0Vote Down

This article discusses how to salvage a crashed pt-online-schema-change by leveraging pt-archiver and executing queries to ensure that the data gets accurately migrated. I will show you how to continue the data copy process, and how to safely close out the pt-online-schema-change via manual operations such as RENAME TABLE and DROP TRIGGER commands. The normal process to recover from a crashed pt-online-schema-change is to drop the …

  [Read more...]
Fun with Bugs #43 - Bugs Fixed in MySQL 5.7.13
+1 Vote Up -0Vote Down

For some reason I do not see numerous public announcements about recent MySQL 5.7.13 release, even though it happened a couple of days ago formally. Maybe that's because we do not have any really "big" new features in this release (new ->> operator for introduced though for those who, unlike me, care about JSON). Still there are many fixes for bugs previously reported by Community (or Oracle engineers, but still in …

  [Read more...]
The differences between IDEMPOTENT and AUTO-REPAIR mode
+0 Vote Up -0Vote Down

I posted recently Lossless RBR for MySQL 8.0 about a concern I have about moving to minimal RBR in MySQL 8.0.  This seems to be the direction that Oracle is considering, but I am not sure it is a good idea as a default setting. I talked about a hypothetical new replication mode lossless RBR and also about … Continue reading The differences between IDEMPOTENT and AUTO-REPAIR mode

pt-online-schema-change (if misused) can’t save the day
+0 Vote Up -0Vote Down

In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it.

Always use pt-osc?

Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER types are still not online, or sometimes just too expensive to execute on busy production master.

So in some cases, we may want to apply an


 first on slaves, taking them out of traffic pool one by one and bringing them back …

  [Read more...]
Showing entries 1 to 10 of 804 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.