Tobias and Slava are back in the studio in this awesome video to show high-availability with SQL Server 2017 between Windows and Linux. After spending a few minutes discussing the background, thought process, discussions that went on trying to determine if this was even possible, and the applicable scenarios, Tobias jumps right into the demo [06:20] to show that yes, Virginia, it is possible, and that it is quite easy to create and configure Availability Groups on both Windows and Linux.
As always, we have a lot of fun, and this is definitely an episode you don’t want to miss!
Be sure to follow the Data Exposed show on Twitter at @DataExposed!
Leave a Reply
6 Comments on "Setting up SQL Server High-Availability between Windows and Linux with SQL Server 2017"
Hi @TobiasTI am getting an error: Apparently AUTOMATIC SEEDING is not working for me…I am not sure what I missed, but getting a typical restore error in Error Log.Automatic seeding of availability database 'test' in availability group 'MyAGDistr' failed with a transient error. The operation will be retried.The operating system returned the error '3(The system cannot find the path specified.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'varoptmssqldatatest.ldf'.File 'test_log' cannot be restored to 'varoptmssqldatatest.ldf'. Use WITH MOVE to identify a valid location for the file
I understand building AlwaysOn, but do you have a video on Failover settings using Pacemaker?This is three Linux environments.
@TobiasT: Great walk through Tobias and Slava. Tobias, could you also place your sudo scripts in github and any highlight any prerequisite steps required e.g. hosts file, firewall config etc.
Uploaded demo scripts here: github.com/TobiasSQL/samples/tree/master/linux_windows_ags
Is it possible to have not only the video, but also all the T-SQL scripts used? Is there perhaps a Power Point file or some othe source, people can use and save time for copying the commands from the screen ?
Tremendous….