Jboss/PostgreSQL HA

Folks,

I have a JBoss App Server with postgresql Backend DB.


What is the best approach to make it High Availability.


Regards,
Will
williamwlkAsked:
Who is Participating?
 
Eugene ZCommented:
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
 
Amitkumar PSr. ConsultantCommented:
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
 
williamwlkAuthor Commented:
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
 
williamwlkAuthor Commented:
Sorry for the late reply.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.