[c3p0-users] c3p0 with MySQL Replication

[Nicolas P. <nic...@ya...>]

Hi there,

This seems to be a surprisingly bare topic, google really isn't helping.

What is the typical usage pattern for c3p0 with a replicated database? 
One where one would want to have all updates and inserts go to a master 
DB and all selects to go to replicated hosts.

Does c3p0 support ReplicationConnection?
<http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-replication-connection.html>

If so, how would one acquire the connection to mark it as not readOnly() 
so as to trigger use of the master db?  How does this interact with 
c3p0's internal pooling of connections?

Many thanks.. just wondering how horizontal scaling is actually done..

-Nic