Shulou(Shulou.com)06/01 Report--

SQL Server 2017 on Linux

Installation and configuration

In addition to the version running on the Windows platform, SQL Server 2017 also runs on Red Hat, SUSE, Ubuntu, Docker, and even pre-configured SQL VM on Microsoft's Azure cloud.

Simple installation

On first contact, you can install SQL Server services and client tools online through the official REPO source, which can be found in "installing SQL Server 2017 online via official Repo on Oracle Linux 7".

Advanced installation

In production environment, you can download SQL Server services, client tools, high availability and other RPM packages in advance and install them offline. You can refer to "installing SQL Server 2017 on Linux offline".

You can also use an unattended installation of SQL Server 2017 on Linux.

Upgrade, rollback, and uninstall

Refer to upgrade, rollback and uninstall SQL Server 2017 on the RHEL platform.

Parameter configuration

After the SQL Server service is started, configure parameters at the instance level. For more information, please see "configuring SQL Server 2017 with mssql-conf tools on Linux".

When you start the service, you can also initialize the configuration with environment variables, which can be found in "configuring SQL Server settings with environment variables on Linux".

Run an agent job

Enable agent jobs and run jobs, see "creating and running SQL Server 2017 Agent Jobs on Linux".

SQL Server 2017 AlwaysOn AG on Linux

Configuration and maintenance

1. Introduce. 3

two。 AlwaysOn availability groups created for high availability. 3

2.1Configuring REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT affects default resource settings. 3

2.2 several design patterns for high availability solutions. 4

2.2.1 three synchronous copies. 4

2.2.2 two synchronous copies. 5

2.2.3 two synchronous copies and configuration-only copies. 6

2.3 configuration steps. 8

2.3.1 install and configure SQL Server. eight

2.3.2 create AG.. eight

2.3.3 configure Cluster Explorer Pacemaker. thirteen

2.3.4 add AG as a cluster resource. 15

2.4 failover

2.4.1 Manual failover

2.4.2 forced failover. 17

2.5 Operation

2.5.1 availability Group upgrade

2.5.2 deleting an availability group

2.6 configure the availability of multiple subnets

2.5.1 VLAN-based solution

2.5.2 modify CIB using Pacemaker

... 17

3. Only the availability group created for reading scaling. 17

3.1 configuration steps. 17

3.2 failover. 17

4. Configure cross-platform availability groups. 18

4.1 configuration steps. 18

4.2 failover. 18

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.