RE: How to modify the application to implement the separation of write/read

2010-03-11 Thread Daevid Vincent
"c3pO" really? as in Starwars?? ;-) /me rolls eyes. > -Original Message- > From: Peter Chen [mailto:peter.c...@aicent.com] > Sent: Thursday, March 11, 2010 3:25 AM > To: Mattia Merzi > Cc: mysql@lists.mysql.com > > I use Hibernate to access Mysql, the connection poll is > c3p0-0.9.0, can

Re: How to modify the application to implement the separation of write/read

2010-03-11 Thread Mattia Merzi
2010/3/11 Peter Chen : [...] > I am not sure whether do I need to modify something else? Like my application > code. as stated on the webpage you just posted here: --- An application signals that it wants a transaction to be read-only by calling Connection.setReadOnly(true), this replication-

RE: How to modify the application to implement the separation of write/read

2010-03-11 Thread Peter Chen
- From: Mattia Merzi [mailto:mattia.me...@gmail.com] Sent: 2010年3月11日 19:01 To: Peter Chen Cc: mysql@lists.mysql.com Subject: Re: How to modify the application to implement the separation of write/read 2010/3/11 Peter Chen : [...] > Does someone have met this problem? How to implement the s

Re: How to modify the application to implement the separation of write/read

2010-03-11 Thread Mattia Merzi
2010/3/11 Peter Chen : [...] > Does someone have met this problem? How to implement the separation of > read and write? please, write us some more details about your application! For example, if you use java with the Connector/j jdbc driver, you can enjoy a really nice feature already implemented

How to modify the application to implement the separation of write/read

2010-03-11 Thread Peter Chen
Hi all, I want to test the mode of Master/Slave for mysql. Also I want to separate the write and read of sql requests, that is, I want to make Slave server of mysql to handle read requests and make Master server to handle write requests. I want to know how to modify the code of my applica