Users Guide

Distributed Database Upgrades | Database Management
OMNM 6.5.3 Installation Guide 155
mysql -u root --password=dorado owmetadb < owmetadb.mysql
mysql -u root --password=dorado owbusdb < owbusdb.mysql
mysql -u root --password=dorado lportal < lportal.mysql
mysql -u root --password=dorado synergy < synergy.mysql
You can configure the embedded MySQL database with multiple instances that fail over. For a new
installation with a distributed mysql db server on the application server machine, follow these
steps:
1 To create OpenManage Network Manager’s database, run loaddb (the default user/password
is
oware/dorado ).
2 To create portal and synergy databases, run loaddb (default user password is root/
dorado
), as follows: loaddb -u root -w dorado -s
3 To seed the database, run ocpinstall -s
Distributed Database Upgrades
For an upgrade with distributed mysql database server, run dbpostinstall on the (primary)
application server.
Despite its name, the needed commands are the same for MySQL in the script
dbpostinstall . These include:
dbevolve -a -x
ocpinstall -s
licenseimporter
MySQL Replication
Install mysql database into 2 servers
master 10.35.35.170
stop OpenManage Network Manager appservers/webservers
slave 10.35.35.174
On master (10.35.35.170) edit my.cnf file ...\dorado\oware3rd\mysql\5_0_51-64 directory
add under [mysqld] section:
log-bin=mysql-bin
server-id=1
restart mysql for changes to take effect.
On slave (10.35.35.174) edit my.cnf file ...\dorado\oware3rd\mysql\5_0_51-64 directory
change server-id from 1 to 2
restart mysql for changes to take effect
log into master mysql server (10.35.35.170) and create users: "mysql -u root --password=dorado"
mysql> CREATE USER 'repluser'@'10.35.35.170' IDENTIFIED BY 'slavepass';
mysql> CREATE USER 'repluser'@'10.35.35.174' IDENTIFIED BY 'slavepass';