title: Mysql manual migration between RDS machines
body: <p>I'm trying to migrate my MySQL RDS to a different machine. The reason is that I need smaller disk, and you can't make disks smaller for RDS servers, only bigger.</p>
  
  <p>I'm trying to migrate with this answer: <a href="https://stackoverflow.com/questions/20638012/backup-mysql-amazon-rds#20645291">Backup MySQL Amazon RDS</a> and this tutorial: <a href="http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html#MySQL.Procedural.Importing.Start.Repl" rel="nofollow noreferrer">http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html#MySQL.Procedural.Importing.Start.Repl</a></p>
  
  <p>Briefly :</p>
  
  <p>Created replica and stopped
  Migrated from replica to a new server
  Created user on Source DB with:</p>
  
  <pre><code>CREATE USER 'repl_user'@'%' IDENTIFIED BY 'slavepass';
  
  GRANT REPLICATION SLAVE ON . TO 'repl'@'%'
  </code></pre>
  
  <p>I've pointed to master from slave with this command:</p>
  
  <pre><code>CALL mysql.rds_set_external_master ('source.mydomain.com', 3306, 'repl_user', 'slavepass', 'mysql-bin-changelog.000001', 107, 0);
  </code></pre>
  
  <p>I've started replication with :</p>
  
  <pre><code>CALL mysql.rds_start_replication;
  </code></pre>
  
  <p>When checking status with SHOW SLAVE STATUS, it shows that slave can't connect to master All servers are in the same security group. I was trying to connect to source with repl_user with mysql command line and it worked. I have no idea where to look next. I think it might be something with security in aws, but I was comparing new server with existing replicas and all seems the same.</p>
  
  <p>I'm running MySQL 5.6 on both machines.</p>