Examples/Sample_InstallMySQLInstanceAndDatabase.ps1
|
configuration SQLInstanceAndDatabaseInstallationConfiguration { param ( [parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [String] $MySQLInstancePackagePath, [parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [String] $MySQLInstancePackageName ) Import-DscResource -Module xMySql node $AllNodes.NodeName { xPackage mySqlInstaller { Path = $MySQLInstancePackagePath ProductId = $Node.PackageProductID Name = $MySQLInstancePackageName Ensure = "Present" } xMySqlServer MySQLInstance { Ensure = "Present" RootPassword= $global:cred ServiceName = "MySQLInstanceServiceName" DependsOn = "[xPackage]mySqlInstaller" } xMySqlDatabase MySQLDatabase { Ensure = "Present" Name = "TestDB" ConnectionCredential = $global:cred DependsOn = "[xMySqlInstance]MySQLInstance" } } } <# Sample use (parameter values need to be changed according to your scenario): #> $global:pwd = ConvertTo-SecureString "pass@word1" -AsPlainText -Force $global:usrName = "administrator" $global:cred = New-Object -TypeName System.Management.Automation.PSCredential ($global:usrName,$global:pwd) SQLInstanceAndDatabaseInstallationConfiguration ` -MySQLInstancePackagePath "http://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-community-5.6.17.0.msi" ` -MySQLInstancePackageName "MySQL Installer" -ConfigurationData .\nodedata.psd1 |