I've written my own MySQL specific connection pool for load balancing connections across a single master multi-slave setup. You get a handle to a Connection object by calling 'checkout' or 'checkoutReadonly' where 'checkout' returns a read/write connection to the master and 'checkoutReadonly' read-only returns a read-only connections to one of the slaves.
Even though I'm using the code in a production environment, I've labeled it alpha code because their are tons of features that I want to add but haven't gotten around to as yet. You are welcome to inquire off-list about it if you are so inclined. Dane Foster ----- Original Message ----- From: "MaFai" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, June 12, 2003 00:00 Subject: about replication Hello, mysql, 2 Mysql 4.0.12 windows version with INNODB replciate sucessfully,both in myisam and innodb table. According to mysql manual(PDF),there is only one master database in the same time,but with many slave server. Master for query,and slave for update or insert operation. Therefore,while programming with JAVA tech,I must write 2 connection pool? one for query,other for update? That's not very proper.Coze the programe switch the connection frequently.It really slow down the web application performance. How do you slove this problem?Any idea appreciate. Best regards. MaFai [EMAIL PROTECTED] 2003-06-12 -------------------------------------------------------------------------------- -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
