sweet - I am able to cluster 3 nodes, where "cluster" is defined as "writes to the first server in a serverlist are replicated on the other (two) nodes. What I had reported in (2) was due to a misconfiguration - I still had only two nodes in a local configuration file read (and repeatedly applied) by mybatis SessionFactory.
Re (1): I found that on occasion I *am* able to connect to a cluster using a JDBC URL naming a single server. Looking into this I found that the H2 value of CLUSTER is set prior to every write - and reset following a successful connect. I can connect to a cluster naming a single server (the first one) prior to a write to the DB. Following a write I can connect using a URL naming any 2 of the 3 servers. Connecting resets the state so that I can again connect using a single server until the next write: 10-02 16:15:02 jdbc[14]: /*SQL */SET AUTO_RECONNECT TRUE; 10-02 16:15:02 jdbc[14]: /*SQL */SET CLUSTER TRUE; 10-02 16:15:02 jdbc[14]: /*SQL */SET TRACE_LEVEL_SYSTEM_OUT 3; 10-02 16:15:02 jdbc[14]: /*SQL */SET DB_CLOSE_DELAY -1; 10-02 16:15:04 index: SYS_DATA remove ( /* key:119 */ 58, 0, 6, 'SET CLUSTER ''172.16.35.55:9101,172.16.35.53:9101,172.16.35.51:9101''') 10-02 16:15:04 pageStore: log - s: 1 table: 0 row: ( /* key:119 */ 58, 0, 6, 'SET CLUSTER ''172.16.35.55:9101,172.16.35.53:9101,172.16.35.51:9101''') 10-02 16:15:04 index: SYS_DATA add ( /* key:120 */ 58, 0, 6, 'SET CLUSTER ''''') 10-02 16:15:04 pageStore: log + s: 1 table: 0 row: ( /* key:120 */ 58, 0, 6, 'SET CLUSTER ''''') Though this is a cluster, SELECT VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME='CLUSTER'; returns '' from successful connect til first write. Following a write it returns the expected list of servers. I suspect this is not as intended - though it may prove useful in my efforts :) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
