1 Reply Latest reply on Mar 31, 2005 11:13 AM by adrian.brock

    Connection pooling in master/slave database environment

    techdreamer

      Does JBoss offer any support for configuring a single datasource or connection pool for multiple database servers?

      Wish to use master/slave database replication (in MySQL 4.1) and will have multiple slaves, but wish to encapsulate them as a single datasource (at least as far as the application is concerned).

      Seems from the documentation that each datasource configuration consists of a single database url (other than allowing for failover which isn't quite the same as being able to intelligently pool mulitple slaves for application read queries).