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

Phoenix Query Server Connection with multiple servers and load balancing

New Contributor

 

jdbc:phoenix:thin:url=http://<PQS Server ip>:8765;serialization=PROTOBUF

 

Im connecting to my Phoenix query server using above JDBC thin url
While this works for lower level envs, when moving up i have 3 or more PQS installed in Hbase region servers
How can i connect to all of them using the url. The thin URL only allows one ip and how can i use the other servers
Im planning to use zookeeper based load balancer in PQS and i have enable the config properties in hbase-site.xml
But without connecting to all 3 of my PQS nodes how can i load balance

your expert help will be appreciated

@elserj  @sunile_manjee @ssoldatov 

2 REPLIES 2

Re: Phoenix Query Server Connection with multiple servers and load balancing

New Contributor

reason for my above question on having multiple PQS in the url is how i can do HA
since i have 3 PQS installed and connecting to just one server will not give me HA

Appreciate if anyone can help me on this


@rchintaguntla 

Re: Phoenix Query Server Connection with multiple servers and load balancing

Expert Contributor

Hello @rameshlk 

 

Maybe this Post by Josh Elser would help, wherein he discussed using PQS behind Load Balancer to achieve High Availability: https://community.cloudera.com/t5/Community-Articles/Deploying-the-Phoenix-Query-Server-in-productio...

 

- Smarak