Questions regarding the 'Fail over' function of Virtuoso Driver for JDBC
ーーーーー-
environment
OS : CentOS 6.4
Virtuoso Version : 7.2.1
------
1. When the 'Fail over' function is enabled, under what circumstances the
JDBC driver switches connections (in Virtuoso)?
To be more precise,
Consider you have the following connection configuration:
jdbc:virtuoso://LOD1:1111,L0D2:1116/CHARSET=UTF-8
In what cases the connection is switched from LOD1 to LOD2?
For example:
- If the connection to LOD1 fails, LOD2 is connected immediately.
- If the connection to LOD1 fails, LOD2 is connected after retrying over
N-times.
... etc.
2. When using the 'Fail over' function, can you specify the number of
retries or wait-time before switching to a different connection?
Again, consider the following configuration:
jdbc:virtuoso://LOD1:1111,L0D2:1116/CHARSET=UTF-8
Is it possible to specify the wait time(*1) and number of retries(*2)
before the connection gets switched to LOD2?
(*1) For example an option like [TIMEOUT=xx] where 'xx' is the wait-time.
(*2) For example an option like [RETRY =xx] where 'xx' is the number of
retries.
In the flow below I try to describe what I would like to do.
Connect to LOD1 -> (No response) -> Wait 10sec -> Retry connection to LOD1
(1st retry) -> (No response) ->
Wait 10sec -> ... -> Retry connection to LOD1 (10th retry) -> (No response)
-> Connect to LOD2
3. How can I know if the connection has been switched (from LOD1 to LOD2)?
Is there any log that shows this information? or any other way?
Best Regards
--
YAMAZAKI Yoshihiro
------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users