How to change the (AWS) RDS instance one region to another region(1a to 1b)and how to convert the read replica to master.

Prerequestes of RDS ;

1. Take existing RDS snapshot.

Process of activity :

1. Create the replica which region we want,
2. Mentioned the identifier name and select Avilability zoon.

Finally, from the picture below you can see that both the instances are now available to us.

Once its completed,choose promote option replica will convert to the master.Delete the old master RDS.

Replica RDS also convert to master now.

Drop the existing RDS which is old master RDS

Before change the RDS name .

After changed RDS Identifier name which is old master name.

After completed the above activity to create the replicas, choose create the read replica option.

Same way we have to implement the cross region replication also.