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

Displaying posts with tag: Replication (reset)

MySQL replication in action - Part 4 - star and hybrid topologies
+0 Vote Up -0Vote Down

Previous episodes:

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


  [Read more...]
MySQL checksum
+0 Vote Up -0Vote Down

how to use percona-tookit to verify mysql data

Read this PDF : mysql_checksum

MySQL replication in action - Part 3: all-masters P2P topology
+1 Vote Up -0Vote Down

Previous episodes:

MySQL 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 standPrevious episodes:

MySQL 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 …



  [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.7Global 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 to …


  [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, the …





  [Read more...]
MySQL 5.7 multi-source replication revealed!
+0 Vote Up -0Vote Down

Why Multi source replication is required?

MySQL has limitation of not allowing to replicate multiple DB’s from different master host on a single slave. MySQL replication had a limitation, fixed with this new release, that said that one slave could have only one master. That is a limiting factor when we are designing our replication environment. There were some “hacks” to make it work, but now there is an official way.

What is multisource replication?
MySQL Multi-Source Replication enables a replication slave to receive transactions from multiple sources simultaneously. …

  [Read more...]
MySQL Replication has stopped
+0 Vote Up -0Vote Down

Hi,

I think most of the DBAs experience this error in their weekly, monthly todo list. Each one follows different approach, I would like to share some tips here:

  1. You should first execute “Show Slave Status;” and check the output, analyze it. Whether SQL thread has stopped or I/O thread has stopped and check respective error , It should be either SQL error or I/O error, based on that take next step.

I/O thread has stopped:

  1. Check that you can reach the master host from slave hostby using ping or traceroute/tracert to reach …
  [Read more...]
On SHOW BINLOG/RELAYLOG EVENTS
+1 Vote Up -0Vote Down

Some notes after working with SHOW BINLOG EVENTS and SHOW RELAYLOG EVENTS statements; there are a few gotchas and some interesting facts. My reflections also follow.

I'm calling these commands from orchestrator when working with Pseudo-GTID (which I do alot). I …

  [Read more...]
10 Newer Entries Showing entries 61 to 70 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.