Deploy query to MSSQL in HA configuretion

[ksj]

I want to deploy a sql query only to the primary replica in my MSSQL HA Cluster.
But i cant seem to only target the primary?

[Justin_Walsh]

Hi @ksj!

I’m happy to help you with this. Are you able to provide some additional detail about how your SQL cluster is configured? Is it a Primary DB with secondary replication, or is it a failover cluster with a Listener?

[ksj]

@Justin_Walsh

failover cluster with a Listener

its a “failover cluster with a Listener”, and i know that i can target the listner with the query, but it will be sendt twice (one from each server), but that not an option when trying to update som tabels

[finnian.dempsey]

Hi @ksj,

Just stepping in for Justin while he’s offline from the Australia based team!

It sounds like there might be a misconfiguration such as multiple tentacles/workers, targeting both nodes when a deployment occurs.

I’d recommend checking out the following doc pages about DB deployments which mention:

High-availability groups or clusters have 1 to N nodes, and the nodes are kept in sync by replication. You only need to deploy to the primary node, and replication will apply the changes to all the nodes. Installing a Tentacle on each node will not work as Octopus Deploy will see multiple Tentacles and attempt to deploy to multiple nodes.

https://octopus.com/docs/deployments/databases/configuration
https://octopus.com/docs/deployments/databases/configuration/tentacle-and-worker-installation
https://octopus.com/docs/deployments/databases/configuration/permissions

Hope that helps but feel free to reach out with any questions at all!

Best Regards,

[ksj]

Thanks That solved my problem