title: Multi Source Replication MySQL 5.6 to 5.7 GTID Auto Position Issues
body: <p>I have 3 master servers, different DBs, I am trying to replicate into a single server. I am having a hard time getting them setup and current. I have Duplicate Entry errors on all 3 Channels. Skipping them manually is painful to say the least. Is there a way to auto sync to the correct position? I was under the impression that this was easy as pie with GTID.</p>
  
  <p>I used:</p>
  
  <p>Dump:</p>
  
  <pre><code>mysqldump --databases profiles --single-transaction --triggers --routines --host=10.10.10.10 --port=3306 --user=user --password=pass &gt; ~/dump.sql
  </code></pre>
  
  <p>Initialize:</p>
  
  <pre><code>CHANGE MASTER TO MASTER_HOST="10.10.10.10", MASTER_PORT=3306, MASTER_USER="user", MASTER_PASSWORD="pass", MASTER_AUTO_POSITION=1 FOR CHANNEL "channel1";
  </code></pre>
  
  <p>Master My.cnf:</p>
  
  <pre><code>gtid_mode       = ON
  enforce_gtid_consistency        = true
  log_bin = /var/log/mysql/bin_log.index
  log_slave_updates       = true
  server-id       = 2061
  </code></pre>
  
  <p>Slave My.cnf:</p>
  
  <pre><code>  [client]
  port            = 3306
  socket          = /var/run/mysqld/mysqld.sock
  
  [mysqld_safe]
  pid-file        = /var/run/mysqld/mysqld.pid
  socket          = /var/run/mysqld/mysqld.sock
  nice            = 0
  
  [mysqld]
  user            = mysql
  pid-file        = /var/run/mysqld/mysqld.pid
  socket          = /var/run/mysqld/mysqld.sock
  port            = 3306
  basedir         = /usr
  datadir         = /var/lib/mysql
  tmpdir          = /tmp
  lc-messages-dir = /usr/share/mysql
  server-id       = 10001
  explicit_defaults_for_timestamp
  
  gtid_mode=ON
  enforce_gtid_consistency=true
  log_bin=/var/log/mysql/bin_log.index
  log_slave_updates=true
  master_info_repository=TABLE
  relay_log_info_repository=TABLE
  
  
  # Instead of skip-networking the default is now to listen only on
  # localhost which is more compatible and is not less secure.
  #bind-address   = 127.0.0.1
  
  log-error       = /var/log/mysql/error.log
  
  # Disabling symbolic-links is recommended to prevent assorted security risks
  symbolic-links=0
  </code></pre>
  
  <p>Am I missing something? Any help is appreciated.</p>