blue/green deployment technique with aurora and replication failure

0

I was testing the blue/green deployment technique, which works fine with idle clusters but fails replication with some DDL when the deployment is running. For example, while the Green cluster deployment was in progress, I created the databases, and the replication in the green primary failed.

5.6.10-log AURORA_VERSION 1.22.5

mysql> create database mytest10; Query OK, 1 row affected (0.01 sec)

5.7.12 AURORA_VERSION 2.11.0

           ..._IO_Running: Yes
            ..._SQL_Running: No
 mysql.rds_replication_status,mysql.rds_monitor,mysql.rds_sysinfo,mysql.rds_configuration,mysql.rds_history
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 1007
                   Last_Error: Error 'Can't create database 'mytest10'; database exists' on query. Default database: 'mytest10'. Query: 'create database mytest10'
Arun
asked 2 years ago751 views
1 Answer
0

Testing with create table also failed the replication:

                  Last_Error: Error 'Table 'author11' already exists' on query. Default database: 'mytest10'. Query: 'CREATE TABLE `author11` (
  `id` int NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50),
  `last_name` varchar(50),
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
   PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB'
Arun
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions