90 CHAPTER 2: INSTALLATION SCRIPTS
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
-- Changing permissions of all the files in /opt/3com/components/presconf.2.5.21 to
755.
-- Trying to load fbsql.so...
-- fbsql is loaded...
-- Opening the database sql://root:NULL@master.yourcompany.com/mysql
-- Changing permissions for presconf1.yourcompany.com
-- Changing permissions for master.yourcompany.com
-- Changing permissions for presconf1.yourcompany.com
-- Changing permissions for presconf1.yourcompany.com
-- Flushing privleges
-- Opening the database sql://root:NULL@master.yourcompany.com/mysql
-- Database is successfully initialized.
3Com IP Conferencing Module applications will be automatically restarted when
system reboots
-- Changing permissions of all the files in /opt/3com/components/presconf.2.5.21.