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

Displaying posts with tag: 5.7 (reset)

MySQL usability issues for replication
+0 Vote Up -0Vote Down

In my latest series of advanced replication features, I came across …

  [Read more...]
MySQL replication in action - Part 4 - star and hybrid topologies
+0 Vote Up -0Vote Down

Previous episodes:

MySQL replication monitoring 101MySQL replication in action - Part 1: GTID & CoMySQL replication in action - Part 2 - Fan-in topologyMySQL replication in action - Part 3 - …  [Read more...]
MySQL replication in action - Part 3: all-masters P2P topology
+1 Vote Up -0Vote Down

Previous episodes:

MySQL replication monitoring 101MySQL replication in action - Part 1: GTID & CoMySQL replication in action - Part 2 - Fan-in topology


In the …



  [Read more...]
MySQL replication in action - Part 2 - Fan-in topology
+0 Vote Up -0Vote Down

Introduction: where we stand

Previous episodes:

MySQL replication monitoring 101MySQL replication in action - Part 1: GTID & Co

In the latest releases of MySQL and MariaDB we have seen several replication improvements. One of the most exciting additions is the ability to enhance basic replication with multiple sources. Those who have used replication for a while should remember that one of the …

  [Read more...]
MySQL replication in action - Part 1: GTID & Co
+1 Vote Up -0Vote Down

In the theoretical part of this series, we have seen the basics of monitoring. In that article, though, we have barely mentioned the new tools available in MySQL 5.7 and MariaDB 10. Let’s start from something that has the potential of dramatically changing replication as we know it.

Crash-safe tables and Global transaction identifiers in MySQL 5.6 and 5.7

Global transaction identifiers (GTID) is a feature that has been in my wish list for long time, since the times I was working with the MySQL team. By the time I left …

  [Read more...]
MySQL::Sandbox 3.0.66 - improved usability and support for newest releases
+0 Vote Up -0Vote Down

The latest MySQL Sandbox, version 3.0.66 is out. It has a few new features (as always, when I find myself doing the same thing many times, I script it) and improved support for latest releases of MySQL. You can now install, among other versions, MySQL 5.7.8 and MariaDB 10.1.x


Some notable additions in this release are in the scripts that are created and customized for each sandbox. There are many of them and when one more arrives, it's easy …


  [Read more...]
Changed defaults between MySQL 5.6 and 5.7
+0 Vote Up -0Vote Down

MySQL 5.7 comes with many changes. Some of them are better explained than others.

I wanted to see how many changes I could get by comparing SHOW VARIABLES in MySQL 5.6 and 5.7.

The most notable ones are:


  • binlog_format: the default is now ROW. This variable affects the format of the binary log, whether you use it as a backup complement or for replication, …


  [Read more...]
In search of cleanliness : the elusive quiet installation
+0 Vote Up -0Vote Down

UPDATE: Almost solved! See at the end.

A clean installation of a database server is one where everything goes according to the expectations. It used to be easy: you only had to do what the manual says, and, presto! you would see your database server installed and ready to use. If something went wrong, you got one or more error messages that informed you of what needs to be fixed.

Sometimes, rarely, it happened that you got also a warning message, telling you that while the installation was successful, you could improve it by fine tuning this and that. No big deal.

Gone are those times. A clean …





  [Read more...]
Yet another MySQL 5.7 silent change
+0 Vote Up -0Vote Down

When a new version of MySQL appears, the first source of information for the brave experimenter is a page in the manual named What is new in MySQL X.X, also known as MySQL in a nutshell. For MySQL 5.7, the in-a-nutshell page lists quite a lot of changes. In that page, the list of removed features is enough to send a chill down the spine of most any DBA. Some of the items in the …

  [Read more...]
MySQL 5.7.8 : features, bugs and rumors
+0 Vote Up -0Vote Down

I’ve had a look at a preview release of MySQL 5.7.8, some time before it became available to the general public (perks and duties of an Oracle ACE) and I found a few interesting things among the release notes and the tarball itself:


  • There is a new tool named mysqlpump, which is intended as a replacement for mysqldump, with parallel processing, …

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

Planet MySQL © 1995, 2015, 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.