kostya kote wrote:
> As I posted above I have application that make
> transaction in endless loop(my transaction
> restarting infinitely), and my transaction is
> SELECT * FROM mysql.user, just for testing.
> Whenever (at the begining or middle) I broke
> connection with frist sql node I havnt
> reconnection to second! In any state of
> autoCommit, i was trying with false and true..
>
> Just I want to understand is the client
> application must solve single-point-of-failure
> problem by itself or I can achieve it by setting
> some flags of MySQL driver?. Because now I/m
> hesitating about this...
Kostya,
I guess I'm confused about why you think this is a single point of failure. Please post your code, and configurations so we don't have to _guess_ if they've been configured or developed correctly.
We actually test this functionality, and it works as expected. We also have users using it in production, so we know it works. Maybe something you're doing doesn't follow the model that works?
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html