It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
TAGS
Community showcase
Published in Data Center

August 2020 showcase: recent bug fixes and product improvements

G’day Atlassian Community ! In this post, I’ll share some of the most impactful bug fixes and product improvements we shipped over the last six months (and since this post ) to our self-man...

8,992 views 4 24
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you