question

t.ariunbat_189192 avatar image
t.ariunbat_189192 asked Erick Ramirez commented

Does AlwaysOn SQL Service offer multiple ODBC connections?

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?

alwayson-sql
1 comment
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

t.ariunbat_189192 avatar image t.ariunbat_189192 commented ·

@Erick Ramirez What is your opinion on this question?

0 Likes 0 ·

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered Erick Ramirez commented

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!

2 comments Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

t.ariunbat_189192 avatar image t.ariunbat_189192 commented ·

Thank you for taking time to answer. Much appreciated. Happy holidays!

0 Likes 0 ·
Erick Ramirez avatar image Erick Ramirez ♦♦ t.ariunbat_189192 commented ·

Happy to help. Cheers!

0 Likes 0 ·