Dual Server Initial Installation 63
REMOTE is at master.yourcompany.com
Enter the password for root@master.yourcompany.com: pvadmin
Enter the password for the master (primary) server.
# master.yourcompany.com SSH-1.99-OpenSSH_3.6.1p2
# master.yourcompany.com SSH-1.99-OpenSSH_3.6.1p2
Warning: Permanently added the RSA host key for IP address '10.1.0.249' to the list
of known hosts.
root@master.yourcompany.com's password:
OK
now testing if we can connect to master.yourcompany.com
SUCCESS
Continuing slave database installation...
Master server hostname is <master.yourcompany.com>
Enter the fully qualified host name or IP address for the slave server. Default
[presconf1.yourcompany.com]:
Assuming default value as presconf1.yourcompany.com
Creating cinema_db2.conf on master database server
On master database server copy cinema_db.conf to cinema_db1.conf
In my.cnf on master, ensure server-id exists and binary logging is enabled.
MySQL my.cnf files updated. Copying modified my.cnf file back to master database
server
Grant access to master database from this server
Opening slave database.
On slave run mysql CHANGE MASTER and have it point to the master db.
Enter the mysql replication password for this installation (both master and slave)
On slave GRANT ACCESS to the master database using the replication password
Create the SIP database now to avoid errors with mysqldump later on
Allow access to the mysql port through the firewall for both master and slave
Opening master database.
Run mysql CHANGE MASTER and have it point to the slave db.
On master GRANT ACCESS to the slave database using the replication password
Insert a record for the new database into dbservers table on master database.
Restart the slave database.
060112 10:56:27 mysqld ended
Slave database successfully installed.
Call make_slave.sh to dump the master database and start replication.
Check if watchdog is already running
Watchdog is not running - starting it
Watchdog is running
Ensure watchdog is running on master database server.
db_watchdog is probably not running on master.yourcompany.com. Try starting it.
db_watchdog successfully started on master.yourcompany.com
Slave successfully installed
-- Creating cinema_db.conf