Tekelec (MOSC)

MOSC Banner

MySQL Replication not working in E5MS

edited Sep 7, 2018 2:13AM in Tekelec (MOSC) 1 commentAnswered ✓

Hello All,

i need some help.

MySQL Replication not working in E5MS. I am following below steps:

On Primary server:

==================

GRANT ALL PRIVILEGES ON * TO root@'server1' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON * TO root@'server2' IDENTIFIED BY 'password';

CREATE USER 'replication'@'server1' IDENTIFIED BY 'replication';

GRANT REPLICATION SLAVE ON * TO 'replication'@'server2' IDENTIFIED BY 'replication';

FLUSH PRIVILEGES;

On Secondary server:

====================

GRANT ALL PRIVILEGES ON * TO root@'server1' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON * TO root@'server2' IDENTIFIED BY 'password';

CREATE USER 'replication'@'server2' IDENTIFIED BY 'replication';

GRANT REPLICATION SLAVE ON * TO 'replication'@'server1' IDENTIFIED BY 'replication';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center