Support Questions
Find answers, ask questions, and share your expertise

How to configurate available MySQL HA (Master-Master) for Hive : Database URL ( javax.jdo.option.ConnectionURL )

Hi ,

We have MYSQL Galera, which is Master Master HA, configured on 3 nodes.

While configuring for hive: Database URL ( javax.jdo.option.ConnectionURL ) , what should the configuration look like?

Case 1) can we setup the one VIP (for all these 3 nodes ) and use MariaDB JDBC Drive?

or

Case 2) Do we need to mention all these 3 nodes like jdbc:mysql://node1,node,node3/hive

What should be the similar configuration for Ranger and Ambari?

3 REPLIES 3

Re: How to configurate available MySQL HA (Master-Master) for Hive : Database URL ( javax.jdo.option.ConnectionURL )

Super Collaborator

Hi @naveen sangam,

mysql fabric is one of the option, so that that manages the replication and you have one common JDBC string.

Re: How to configurate available MySQL HA (Master-Master) for Hive : Database URL ( javax.jdo.option.ConnectionURL )

Hi Raju,

We have mysql HA setup with Master-Master , using galera . And it is 3 node replication among the. I have no question on it

If we want to use above setup ,

1) do we have to setup a vip that resloved to all the 3 nodes. And use the vip in HDP -- Hive configuration ( hive: Database URL ( javax.jdo.option.ConnectionURL ), like

jdbc:mysql://mysql-vip/hive

or

2) without vip , can we mentin all the mysql host names like : jdbc:mysql://node1,node,node3/hive , while configuring hive: Database URL ( javax.jdo.option.ConnectionURL


Also do we need to use mysql jdbc driver or MariaDB jdbc Driver? , with above choice?


Thanks

Naveen.


Re: How to configurate available MySQL HA (Master-Master) for Hive : Database URL ( javax.jdo.option.ConnectionURL )

Explorer

@naveen sangam I have the same question. How did you do it finally?