Bug #45147 transparent application failover
Submitted: 28 May 2009 0:10 Modified: 4 Jul 10:13
Reporter: Mikiya Okuno Email Updates:
Status: Won't fix Impact on me:
None 
Category:Connector / J Severity:S4 (Feature request)
Version: OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[28 May 2009 0:10] Mikiya Okuno 
Description:
When people use Oracle RAC, they should be less careful about database failure and failover on their application, because of transparent application failover. If we can use MySQL Cluster + Connector/J like that, users will be happy ;)

How to repeat:
n/a

Suggested fix:
n/a
[28 May 2009 0:21] Mark Matthews 
Connector/J's load balancing feature (jdbc:mysql:loadbalance://host1, host2, .. host-n) gives a rough equivalent. What the feature doesn't offer the FO_SELECT semantics (preserving cursors, because they don't exist for clients under MySQL), and doesn't have callbacks, although the user can plug in at the load balancing layer to do similar things.
[4 Jul 10:13] Filipe Silva 
Posted by developer:
 
The server currently does not support transferring session state between instances, which makes this kind of feature impossible to implement. If such functionality is ever introduced at the server level, the connector will naturally evolve to leverage it in a way that aligns with its own requirements—likely making this feature request redundant.