Not the answer you need?
Register and ask your own question!

Can A PErcona 5.6 SLAVE talk to a 5.6 MySQL Community Server MASTER

MR.YMR.Y ContributorCurrent User Role Beginner
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)

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    Yes, it can. Make sure to check the MySQL 5.6 release notes from 5.6.19 to 5.6.29 to see if there are any possible incompatibilities, though I doubt there is any.
  • caelumvoxcaelumvox Entrant Inactive User Role Beginner
    I'd like to ask about the converse: would it be possible for a Percona 5.6 Master to replicate to a MySQL 5.6 Slave?

    Thank you
  • jriverajrivera Percona Support Engineer Percona Staff Role
    Yes, it is possible. Do note that there are cases that point versions would matter. Meaning for example a 5.6.30 master replicating on 5.6.12 slave _might_ have a problem, I am not saying there will be but you need to test. You will need to review release notes if there are changes in how replication works between these versions.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.