Client Configuration Considerations for MySQL

Following are some configuration considerations for MySQL database clients:

• If clients will connect from remote hosts, create an IP address under LifeKeeper to be used for client connections.

• Clients must be configured to connect to the database server through a LifeKeeper-protected IP address.

• If the clients will connect through a domain name instead, create an entry in each client’s hosts file for the protected IP address, or configure the name in DNS. Test the protected IP address by pinging it from all clients and all LifeKeeper servers in the cluster.

• Although each user can have a my.cnf file in the home directory of their machine, LifeKeeper only uses the my.cnf file located in the /etc directory or the data directory. The my.cnf file stores the client connection information (i.e. the port, socket identification, user and password).