Control node failure in Synapse analytics

Question

Control node failure in Synapse analytics

Hiral Shah 141

I am trying to figure out the scenario when the control node itself fails in Synapse Analytics.
Please, someone, guide me on how the control node failure is handled in synapse analytics.

Thanks in advance.

PRADEEPCHEEKATLA 91,866 Reputation points

2021-04-16T07:07:13.543+00:00

Hello @Hiral Shah ,

Thanks for the ask and using the Microsoft Q&A platform

We are reaching out to the internal team to get more help on this, I will update you once we hear back from them.
PRADEEPCHEEKATLA 91,866 Reputation points

2021-04-19T04:05:15.813+00:00

Hello @Hiral Shah ,

We are still waiting for the response from the product team. I will update you once we hear back from them.

Stay tuned!

Answer accepted by question author

0 additional answers

Your answer

PRADEEPCHEEKATLA 91,866 Reputation points

2021-04-16T07:07:13.543+00:00

Hello @Hiral Shah ,

Thanks for the ask and using the Microsoft Q&A platform

We are reaching out to the internal team to get more help on this, I will update you once we hear back from them.
PRADEEPCHEEKATLA 91,866 Reputation points

2021-04-19T04:05:15.813+00:00

Hello @Hiral Shah ,

We are still waiting for the response from the product team. I will update you once we hear back from them.

Stay tuned!

Answer 1

PRADEEPCHEEKATLA 91,866

Hello @Hiral Shah ,

Every node in the dedicated SQL pool is designed with HA in mind – meaning, in case of node level failures, new nodes will be brought as replacements automatically. However, this is happening at the infrastructure level – users will experience this failure as something that will break user apps (and queries/workloads) as instance will be unavailable until system heals fully.

In Gen3 workload level resilience is not dependent on multi-cluster feature, it is intrinsic to life cycle of a query on any pool – we have resilience for BE node failures (DQP performs task retry), and for DQP failures (FE performs query retry through DQP-client gRPC protocol). On FE failure we lose the client connection, and we have no workload resilience to these types of failures. The user will be able to reconnect once the FE is back up, which as you said it should be a fast fail-over that our infra takes care of.

Hope this helps. Do let us know if you any further queries.

------------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

PRADEEPCHEEKATLA 91,866 Reputation points

2021-04-22T06:40:16.537+00:00

Hello @Hiral Shah ,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
PRADEEPCHEEKATLA 91,866 Reputation points

2021-04-23T11:05:06.47+00:00

Hello @Hiral Shah ,

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Take care & stay safe!
Hiral Shah 141 Reputation points

2021-04-23T11:11:29.817+00:00

Thanks for the help.

Share via

Control node failure in Synapse analytics

0 additional answers

Your answer