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.

Figure 1. Active/Standby Configuration, Example 1

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

Feedback

Thanks for your feedback.

Post your comment on this topic.

Post Comment