Skip to content

Instantly share code, notes, and snippets.

View kurtmw's full-sized avatar

Kurt Magsipoc-Wilson kurtmw

  • Toronto, Canada
  • 01:08 (UTC -04:00)
View GitHub Profile
@kurtmw
kurtmw / sqc9_switchover_20260220_green_to_green_subsetting
Created February 20, 2026 16:33
sqc9_switchover_20260220_green_to_green_subsetting
#### SWITCHOVER FOR square9 ####
# Check the current orchestrator topology
./orchestrator-client -c topology -i sqc9-prod
# Promote the target replica as the primary
./orchestrator-client -c graceful-master-takeover -i sqc9-prod -d square9-use1-green-db02.prod.us-east-1.aws.marqeta.io:3306
# Validate the new orchestrator topology shows read_only 1 for the old square9-use1-green-db01.prod.us-east-1.aws.marqeta.io, replication lag = 0, and cluster is replicating from square9-use1-green-db02.prod.us-east-1.aws.marqeta.io
./orchestrator-client -c topology -i sqc9-prod
@kurtmw
kurtmw / sqc5_switchover_20260220_green_to_green_subsetting
Created February 20, 2026 16:33
sqc5_switchover_20260220_green_to_green_subsetting
#### SWITCHOVER FOR square5 ####
# Check the current orchestrator topology
./orchestrator-client -c topology -i sqc5-prod
# Promote the target replica as the primary
./orchestrator-client -c graceful-master-takeover -i sqc5-prod -d square5-use1-green-db02.prod.us-east-1.aws.marqeta.io:3306
# Validate the new orchestrator topology shows read_only 1 for the old square5-use1-green-db01.prod.us-east-1.aws.marqeta.io, replication lag = 0, and cluster is replicating from square5-use1-green-db02.prod.us-east-1.aws.marqeta.io
./orchestrator-client -c topology -i sqc5-prod
@kurtmw
kurtmw / sqc2_switchover_20260220_green_to_green_subsetting
Created February 20, 2026 16:33
sqc2_switchover_20260220_green_to_green_subsetting
#### SWITCHOVER FOR square2 ####
# Check the current orchestrator topology
./orchestrator-client -c topology -i sqc2-prod
# Promote the target replica as the primary
./orchestrator-client -c graceful-master-takeover -i sqc2-prod -d square2-use1-green-db02.prod.us-east-1.aws.marqeta.io:3306
# Validate the new orchestrator topology shows read_only 1 for the old square2-use1-green-db01.prod.us-east-1.aws.marqeta.io, replication lag = 0, and cluster is replicating from square2-use1-green-db02.prod.us-east-1.aws.marqeta.io
./orchestrator-client -c topology -i sqc2-prod
@kurtmw
kurtmw / sqr_switchover_20260220_blue_to_blue_subsetting
Created February 20, 2026 16:33
sqr_switchover_20260220_blue_to_blue_subsetting
#### SWITCHOVER FOR square ####
# Check the current orchestrator topology
./orchestrator-client -c topology -i sqr-prod
# Promote the target replica as the primary
./orchestrator-client -c graceful-master-takeover -i sqr-prod -d square-use1-blue-db01.prod.us-east-1.aws.marqeta.io:3306
# Validate the new orchestrator topology shows read_only 1 for the old square-use1-blue-db02.prod.us-east-1.aws.marqeta.io, replication lag = 0, and cluster is replicating from square-use1-blue-db01.prod.us-east-1.aws.marqeta.io
./orchestrator-client -c topology -i sqr-prod