MySQL Replication Simplified: Easy step-by-step examples to establish, troubleshoot and monitor replication by Sribatsa Das

Author:Sribatsa Das [Das, Sribatsa]
Language: eng
Format: azw3
Published: 2014-05-19T04:00:00+00:00

Create replication user account on Node 1 allowing Node 2 to read logs from Node 1 and flush privileges.

Screen-shot 13—1: Replication user created in master server Node 1 or mobilestatisticsprofessor.us

Verify that the replication user created in Node 1 has required privileges to facilitate replication.

Screen-shot 13—2: Verifying the replication user account on master mobilestatisticsprofessor.us

Make necessary configuration changes to the configuration file my.cnf located on Node 1. At a minimum, the following are added unless already present. Auto_increment_increment and auto_increment_offset can be set up to avoid collision of auto_increment key values among the MySQL servers participating in the replication configuration. server_id needs to be unique. These are the minimum parameters, but these can be expanded to suit the particular need of the organization by the DBA.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.