This section provides an example of an active/standby configuration. In this configuration, Server 1 is considered active because it has exclusive access to the database. Server 2 does other processing. If Server 1 fails, Server 2 gains access to the database, and LifeKeeper re-establishes the database operations.
Configuration Notes:
- Both servers use the MySQL data directory (which includes the database (databaseA)) on a shared disk.
- The path to the MySQL data directory is the same on both servers.
- The my.cnf configuration file is located on a local disk in /etc.
- The MySQL executables are located on a local drive on each server in /usr/bin.
- Server 2 cannot access files and directories on the shared disk while Server 1 is active.
Creating a resource hierarchy on Server 1:
| Server: | Server 1 |
| Directory of my.cnf File Location: | /etc |
| Directory of MySQL Executables Location: | /usr/bin |
| Database Tag | mysql-on-server1 |
Extending a resource hierarchy to Server 2:
| Template Server: | Server 1 |
| Tag to Extend | mysql-on-server1 |
| Target Server | Server2 |
| Target Priority: | 10 |
| Directory of my.cnf File Location: | /etc |
| Directory of MySQL Executables Location: | /usr/bin |
| Database Tag | mysql-on-server2 |
Post your comment on this topic.