Two hosts in jdbc url

Question

We are using jdbc url like jdbc:mysql://localhost:3306/mysql. How could I set second mysql host in this url? If this is imposible, how could I set in my java application (hibernate) connection to second MySQL server? Thanks!

PS. actually we want to parallelize operations to two different databases. Is there any solution for that in Hibernate?

Stéphane Millien · Accepted Answer · 2020-06-30 22:59:43Z

11

an example for Oracle (failover with 3 hosts):

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.200.40.5)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.200.40.6)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.200.40.7)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=OLTP.WORLD)))

Regards.

edited Jun 30, 2020 at 22:59

answered Nov 7, 2014 at 14:05

Stéphane Millien

3,49826 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Suresh Over a year ago

,what will be the order of connection in above jdbc url?

ryenus · Accepted Answer · 2016-12-21 05:27:41Z

9

This is really about failover/clustering.

jdbc:mysql://192.168.29.20:3306,192.168.29.20:6306/mysql should do it. see http://lists.mysql.com/cluster/249

Reference:

https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html

edited Dec 21, 2016 at 5:27

ryenus

17.8k5 gold badges64 silver badges69 bronze badges

answered Jul 22, 2013 at 13:04

mujib ishola

1906 bronze badges

2 Comments

Dedyshka Over a year ago

There is some delay when first server is down. When application tries to connect to second connection I have a delay few seconds. (FYI I have the same two mysql servers on the same machine on different ports 3306 & 3307). Do you know where is the problem?

mujib ishola Over a year ago

That is understandable.The url doesn't mean you have two connection established and the fail over code only kicks in when there is a problem with the first connection.The delay could also depends on what you are trying to do "Transactions comes to mind here" and all and how you have managed exceptions.

Petr Mensik · Accepted Answer · 2013-07-22 13:05:46Z

0

2 options here:

1) You can write some code which would change your hibernate properties and switch your DB url.

2) you can have multiple hibernate configurations for multiple session-factories.

edited Jul 22, 2013 at 13:05

Petr Mensik

27.7k17 gold badges94 silver badges119 bronze badges

answered Jul 22, 2013 at 13:04

Shreyash

3611 gold badge3 silver badges11 bronze badges

Collectives™ on Stack Overflow

Two hosts in jdbc url

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related