mysql> CALL mysql.rds_stop_replication;
+---------------------------+
| Message |
+---------------------------+
| Slave is down or disabled |
+---------------------------+
1 row in set (5 min 28.69 sec)
mysql> SHOW SLAVE STATUS \G
...
Last_SQL_Error: Error 'Access denied for user ''@'' to database 'mysql'' on query. Default database: 'mysql'. Query: 'ALTER TABLE db
MODIFY Host char(60) NOT NULL default '',
MODIFY Db char(64) NOT NULL default '',
MODIFY User char(16) NOT NULL default '',
ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin'
mysql> CALL mysql.rds_skip_repl_error ;
+-------------------------------------+
| Message |
+-------------------------------------+
| Statement in error has been skipped |
+-------------------------------------+
1 row in set (0.05 sec)
+-----------------------------------------------------------------------------------+
| Message |
+-----------------------------------------------------------------------------------+
| Slave has encountered a new error. Please use SHOW SLAVE STATUS to see the error. |
+-----------------------------------------------------------------------------------+
1 row in set (2.05 sec)
Query OK, 0 rows affected (2.05 sec)
...
mysql> CALL mysql.rds_skip_repl_error ;
+---------------------------------------------------------+
| Message |
+---------------------------------------------------------+
| Slave is running normally. No errors detected to skip. |
+---------------------------------------------------------+
1 row in set (0.03 sec)
mysql> show variables like '%char%';
+--------------------------+-------------------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /rdsdbbin/mysql-5.5.33.R1/share/charsets/ |
+--------------------------+-------------------------------------------+
mysql> show variables like 'auto_inc%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| auto_increment_increment | 10 |
| auto_increment_offset | 2 |
+--------------------------+-------+
max_allowed_packet = 67108864
sync_binlog = 1
innodb_flush_log_at_trx_commit = 1
auto_increment_offset = m
auto_increment_increment = n
collation_connection = utf8_unicode_ci
character_set_results = utf8
character_set_server = utf8
character_set_connection = utf8
character_set_database = utf8
character_set_client = utf8
character_set_filesystem = binary
[mysqld]
# ...
character-set-server=utf8
collation-server=utf8_general_ci
# ...
default-time-zone = '+00:00'
server-id = x
auto-increment-increment = y
auto-increment-offset = z
log_bin = /var/log/mysql/mysql-bin.log
binlog-ignore-db = mysql
binlog-ignore-db = performance_schema
binlog-ignore-db = information_schema
binlog-ignore-db = test
innodb_flush_log_at_trx_commit = 1
sync_binlog = 1
mysql> CHANGE MASTER TO
MASTER_HOST='YourDBServerIP',
MASTER_USER='repl_account',
MASTER_PASSWORD='repl_password',
MASTER_LOG_FILE='mysql-bin.######',
MASTER_LOG_POS=#######;
mysql> START SLAVE;
mysql> STOP SLAVE;
mysql> RESET SLAVE;
mysql> CALL mysql.rds_set_external_master (
'YourDBServerIP'
, 3306
, 'repl_account'
, 'repl_password'
, 'mysql-bin.######'
, #######
, 0
);
mysql> CALL mysql.rds_start_replication;
mysql> CALL mysql.rds_stop_replication;
mysql> CALL mysql.rds_reset_external_master;
When you upgrade servers that participate in a replication setup, the procedure for upgrading depends on the current server versions and the version to which you are upgrading.
This section applies to upgrading replication from older versions of MySQL to MySQL 5.6. A 4.0 server should be 4.0.3 or newer.
When you upgrade a master to 5.6 from an earlier MySQL release series, you should first ensure that all the slaves of this master are using the same 5.6.x release. If this is not the case, you should first upgrade the slaves. To upgrade each slave, shut it down, upgrade it to the appropriate 5.6.x version, restart it, and restart replication. Relay logs created by the slave after the upgrade are in 5.6 format.
...
$ sudo service mysql stop
$ sudo mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
$ mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('NewPassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit;
$ sudo killall mysqld_safe
$ sudo service mysql start
$ sudo dpkg-reconfigure tzdata
$ sudo service cron stop
$ sudo service cron start