Viii. database service attached storage (MPIO)
-
CREATE DATABASE server account
1. Create a open-cloud\sqladmin domain account, Log on to the ad01.open-cloud.com server and execute it in PowerShell, such as the following command,
new-aduser-displayname: "Sqladmin"-givenname: "Sqladmin"-name: "SQLadmin"-Path: "Cn=users,dc=open-cloud,dc=com"-samaccountname: "Sqladmin"-type: "User"-userprincipalname: "[email protected ] "-accountpassword (convertto-securestring" #*c12345 "-asplaintext-force)-changepasswordatlogon: $false- Smartcardlogonrequired: $false-accountnotdelegated: $false-allowreversiblepasswordencryption: $false- Cannotchangepassword: $false -passwordneverexpires: $true -enabled $true
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6D/2B/wKioL1VdwMPCDaw1AAGbcrGwsNY002.jpg "/>
2. Add domain Admins to open-cloud\sqladmin, and execute the following command in PowerShell
Add-adprincipalgroupmembership-identity: "cn=sqladmin,cn=users,dc=open-cloud,dc=com"-MemberOf: "CN=Domain Admins, Cn=users,dc=open-cloud,dc=com "
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6D/30/wKiom1Vdv0mzA_y-AACbZF_vkdM112.jpg "/>
Connecting iSCSI shares
You need to connect iSCSI shared storage on two database servers, SQL01,SQL02, respectively.
Installing Multipath I/O
1. Log in to the SQL01 database server using Open-cloud\sqladmin,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6D/2B/wKioL1VdwMPBoKOqAAF1rVUDbZQ661.jpg "/>
2. Add Multipath I/O functionality to the SQL01 server and execute it in PowerShell
Add-windowsfeature Multipath-io,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6D/30/wKiom1Vdv0qDCnJTAABn57dQC-k756.jpg "/>
3. Multi-path I/O function was successfully installed,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6D/2B/wKioL1VdwMTyaXyEAADbH-OqrMQ771.jpg "/>
2. Add MPIO Driver
Log on to the desktop, select Mpio, open,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6D/30/wKiom1Vdv0vDNiBMAAG3NGRWEIE459.jpg "/>
2. In the Mpio Properties dialog box, select Discover Multipathing,
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6D/30/wKiom1Vdv0uTQN2QAAGRXBeUKX8716.jpg "/>
2. Select "Add support for iSCSI devices", "add",
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6D/2B/wKioL1VdwMXAVlIEAAFiqO81DbA312.jpg "/>
3. Select Yes to restart the computer.
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6D/30/wKiom1Vdv0uA9bNgAAFJ1RfhKoo163.jpg "/>
4. View iSCSI-to-mpio driver installation status
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6D/2B/wKioL1VdwMbwtVSiAAGskpJTKMA914.jpg "/>
This article is from the "Zlyux" blog, make sure to keep this source http://zlyux.blog.51cto.com/1654149/1653606
Viii. database service attached storage (MPIO)