Mysql-master-slave-replication

mysql-master-slave-replication

1)on the master and the slave a new "replication" user has to be added

mysql> create user repuser@kurs007 identified by 'xxxxx';
Query OK, 0 rows affected (0.00 sec)

2) set some rights

mysql> create user repuser@kurs007 identified by 'xxxxx';
Query OK, 0 rows affected (0.00 sec)

now we have to edit the my.ini on the master and the slave

master:

server_id=1

(there are loads of options, it is also possible to encrypt the connection with ssl.)

slave:

server-id=2
master-host=<ip_address or fqdn>
master-port=3306
master-user=repuer #username
master-passwort=xxxxx #can be given here, or later, if mysqld is started
master-connect-retry=60 #in seconds