I want to setup up a local Percon SLAVE
talking to a AWS MySQL Community MASTER
IS THIS POSSIBLE ?
I don’t see why not ?
or
I have to find a MySQL Communit server
My goal is to transfer MySQL AWS data to Local Percona Db
Make it a slave to AWS and let it replicate until when we are ready to cut over
then Make Percona Slave new MASTER and DELETE AWS
thx
SLAVE :
mysql> show variables like ‘%vers%’ ;
±--------------------------±-----------------------------------------------------+
| Variable_name | Value |
±--------------------------±-----------------------------------------------------+
| innodb_version | 5.6.29-76.2 |
| protocol_version | 10 |
| slave_type_conversions | |
| thread_pool_oversubscribe | 3 |
| version | 5.6.29-76.2-log |
| version_comment | Percona Server (GPL), Release 76.2, Revision ddf26fe |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
±--------------------------±-----------------------------------------------------+
8 rows in set (0.00 sec)
MASTER :
mysql> show variables like ‘%vers%’ ;
±------------------------±-----------------------------+
| Variable_name | Value |
±------------------------±-----------------------------+
| innodb_version | 5.6.19 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.19-log |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
±------------------------±-----------------------------+
7 rows in set (0.02 sec)