JIRA Load Balancing for Data Center Edited

Our JDC 7.3.8 has 2 application servers along with shared drive and LB configurations to provide high availability . The app servers are connected to Exadata DB(active and standby mode) . At the moment the jdbc connection string is configured as <url>jdbc:oracle:thin:@//hostname:port/dbname</url>. This string doesn't provide HA from DB perspective. As well creating a DNS name for the primary and secondary DB is not a option we can't try.

 

So other than creating DNS name for DBs , does JIRA support below scan/HA JDBC url format so that JIRA DB connections can failover to secondary DB without application restart ? If yes, please give the correct syntax

 

jdbc:oracle:thin:(DESCRIPTION = (LOAD_BALANCE=ON) (ADDRESS = (PROTOCOL = tcp)(HOST = host1)(PORT = port1)) (ADDRESS = (PROTOCOL = tcp)(HOST = host2)(PORT = port2)) (CONNECT_DATA = (SERVER=dedicated) (SERVICE_NAME=service_name)))

 

0 answers

Suggest an answer

Log in or Sign up to answer
Community showcase
Asked Sep 17, 2018 in Data Center

Hi! I'm Cameron Deatsch, enterprise enthusiast and Head of Server at Atlassian. AMA!

Hey team! I'm Cameron Deatsch, Head of Server at Atlassian. At our European Summit just a few weeks ago, I spoke about the latest regarding our Server and Data center products and o...

48,103 views 81 16
View question

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you