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

1. Preparatory work

1.1. Noun interpretation

Witness: the role of the witness is to coordinate the failure between nodes, that is, when a node fails, it is up to the witness to decide who will continue to take over the service. The witness is used only when there is an even number of DAG member servers and the quorum is needed, and if the primary witness is not available, DAG switches to an alternate witness to implement the arbitration.

The AD service is usually responsible for witnessing the service.

DAG: database highly available group Database Availability Group, which usually consists of two or more mailbox role servers.

1.2, drive letter and size

Before DAG configuration, the drive letter name and size of the member server are required to be the same.

1.3. Network card configuration

EX01

EX02

1.4. Permission configuration

Add member server computers to the witness server administrators group

1.5.The DAG DNS configuration

DNS creates an A record

2. DAG configuration

Create a new database availability group

The database availability group name is DAG, the witness server is AD01, and the witness directory is C:\\ DAG. If you do not define this directory, the system will create a folder named "DAGFileShareWitnesses" as the witness directory by default.

The witness server IP is 192.168.20.236

Add a member server of an availability group

Preservation process

Verify EX02

Add EX02

Save complete

Add DAG High availability Network

DAG1 copies the details of the Nic.

Nic details

3. Database configuration

Add a copy of the database and add EX02 as a copy of EX01

Add completed

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.