Session
Build an Availability Group in ten minutes using SQL containers
If you're using availability groups with readable secondaries, you probably want readable secondaries in dev, test, system test, acceptance test and production. However, duplicating the infrastructure to make that possible may or may not be exactly what your employer or client wants to pay for.
In this 10 minute lightning talk, I will create two SQL containers, within the same docker network, and create a clusterless availability group with one container as primary and one container as readable secondary, and run a simple PowerShell test-client to run queries against the write-replica and the read-replica.
Since it's a 100% scripted solution, it will also work to create this AG in a pipeline, so that you can create it, run automated tests and throw it away after tests have been run, to be able to run unit tests and low level system tests automagically.
Magnus Ahlkvist
SQL Server specialist, Data Platform MVP, SQL Community organizer. Paid work out of Transmokopter SQL AB.
Enköping, Sweden
Links
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top