How to use single mysql databse with muptiple openfire server

If the two openfire servers are not clustered, simply create two independent databases within MySQL, and configure the servers appropriately.

If you want a cluster of servers, checkout Process for checking clustring working or not in openfire