I see that AOSS offers high availability for ODBC apps. I have started Spark Thrift server on single node and if multiple clients try to connect via ODBC driver while a client's query is being executed, the error occurs as it only allows single client. So if I set up AOSS on all nodes, does it solve my problem of multiple users interacting with SQL queries from multiple servers to AOSS?
Bringing together the Apache Cassandra experts from the community and DataStax.
Want to learn? Have a question? Want to share your expertise? You are in the right place!
Not sure where to begin? Getting Started
This question was
closed
by
Erick Ramirez for the following reason: The question is answered, right answer was accepted
Does AlwaysOn SQL Service offer multiple ODBC connections?
Yes, it does. I also wanted to point out that the AlwaysOn SQL Service needs to be enabled on all Analytics nodes in the DC. This is how the service provides high availability.
You can read more about it in the blog post Introducing AlwaysOn SQL for DSE Analytics.
For what it's worth, I'm on holidays and have limited mobile access so my responses are delayed. Cheers!
Thank you for taking time to answer. Much appreciated. Happy holidays!
5 People are following this question.
