On the first Database Server - ACS - Reference Guides

ACS Installation and Administration Guide

Product
ACS
AFS_Version
7.11
Category
Reference Guides
language
English
audience
public

On the first database server

1. Connect to database server:

mysql -uroot -p'root_password'


2. Add the right on all to the database CKS user with these database instructions:

GRANT ALL ON *.* TO antisearch@'cks1-box' IDENTIFIED BY 'kangoo';

GRANT ALL ON *.* TO antisearch@'cks2-box' IDENTIFIED BY 'kangoo';

GRANT ALL ON *.* TO antisearch@'localhost' IDENTIFIED BY 'kangoo';

GRANT ALL ON *.* TO antisearch@'127.0.0.1' IDENTIFIED BY 'kangoo';

Change cks1-box and cks2-box with the cks servers fully qualified host names.


3. Add replication right to the user antirepl (a user created for replication):

GRANT REPLICATION SLAVE ON *.* TO antirepl@'%' IDENTIFIED BY 'kangoo';


4. Edit the /etc/my.cnf configuration file and add these two lines in the [mysql] part of the file:

log-bin

server-id=1


5. Restart database:

/etc/init.d/mysql restart


6. Display the master status and keep the output as File and Position information are needed for the other database instance configuration:

SHOW MASTER STATUS;

+-------------------+----------+--------------+------------------+ยต
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
| mysqld-bin.000001 | 106 | | |
+-------------------+----------+--------------+------------------+
1 row in set (0.00 sec)