?
Solved

Jboss/PostgreSQL HA

Posted on 2013-02-07
7
Medium Priority
?
656 Views
Last Modified: 2014-03-09
Folks,

I have a JBoss App Server with postgresql Backend DB.


What is the best approach to make it High Availability.


Regards,
Will
0
Comment
Question by:williamwlk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
7 Comments
 
LVL 21

Expert Comment

by:Amitkumar Panchal
ID: 38870483
Well, it depends on available hardware and network infrastructure.

for eg. if you have multiple servers with you, you can configure jboss on each machine. And apache webserver which pass the request to available jboss instance. so that one jboss machine is down, others can serve the request.
0
 

Author Comment

by:williamwlk
ID: 38870908
Thanks. Let's assume that hardware and infra is non-issue!

Apache -> multiple Jboss Machines

OK. This is fine.

How about the PostgreSQL?

- How can I make it HA?
- How to best backup PostgreSQL?

Regards,
Will
0
 
LVL 43

Accepted Solution

by:
Eugene Z earned 1500 total points
ID: 38887344
please check the forum solution at:

HA architecture question
https://community.jboss.org/thread/163138?_sscc=t

JBoss traditionally deals strictly in middle-ware, and so does not offer any true HA services for the database layer.  To answer your specific questions:

 
1) The <ha-tx-local-datasource> & <ha-xa-datasource> perform very rudamentary failover - they only offer failover over new connections.  Also, there's no guarantee that the servers in your cluster will all point to the same url at the same time. Additionally, you probably don't want to try to initiate master promotion automatically, since you don't want this to be initiated by multiple servers.

¿

2) When chosing an HA data storage solution, you're going to have to consider the trade-offs between availability (i.e. down time) vs data integrity (i.e. data loss) vs performance.  Make sure you familiarize yourself with your options:

¿http://www.postgresql.org/docs/9.0/static/different-replication-solutions.html

Of the options you listed, pgpool-II is probably the best option, since, though it still maintains a single point-of-failure, its point-of-failure does not also house your data.  In general, statement-based replication middleware offers a higher level of availability than master-standby replication, and without the potential for data loss.  I've not used the Tungsten suite of products, so I can't offer any recommendations either way.

 
Another option you may want to consider is HA-JDBC (http://ha-jdbc.sourceforge.net).  Like PGPool
0
 

Author Closing Comment

by:williamwlk
ID: 39916726
Sorry for the late reply.
0

Featured Post

WordPress Tutorial 3: Plugins, Themes, and Widgets

The three most common changes you will make to your website involve the look (themes), the functionality (plugins), and modular elements (widgets).

In this article we will briefly define each again, and give you directions on how to install them.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
This article explains the fundamentals of industrial networking which ultimately is the backbone network which is providing communications for process devices like robots and other not so interesting stuff.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Course of the Month12 days, 12 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question