Command Line Interface - Configuration

Log On to the CommServe

To run command line operations, you must first login to the CommServe.

From Command prompt, navigate to <Software_Installation_Directory>/Base and run the following command:

qlogin -cs <commserve name> -u <user name>

For example, to log on to CommServe 'server1' with username 'user1':

qlogin -cs server1 -u user1

Instance Configuration

Creating an Instance
  1. Download the create_instance_template.xml file and save it on the computer from where the command will be executed.

  2. Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters values.

On a UNIX client:

qoperation execute -af create_instance_template.xml -appName 'MySQL' -clientName xxxxx -instanceName xxxxx -userGroupName xxxxx -BinaryDirectory xxxxx -LogDataDirectory xxxxx -configFile xxxxx -port xxxxx -SAUser/userName xxxxx -SAUser/password xxxxx -unixUser/userName xxxxx -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName xxxxx -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName xxxxx

Example:

qoperation execute -af create_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -BinaryDirectory /usr/bin -LogDataDirectory var/log/mysql -configFile etc/mysql/my.cnf -port /var/run/mysqld/mysqld.sock -SAUser/userName 'root' -SAUser/password 'mysql' -unixUser/userName 'root' -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1

Example to create an instance with XtraBackup option enabled:

qoperation execute -af create_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -BinaryDirectory /usr/bin -LogDataDirectory var/log/mysql -configFile etc/mysql/my.cnf -port /var/run/mysqld/mysqld.sock -SAUser/userName 'root' -SAUser/password 'mysql' -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1 -xtraBackupSettings/enableXtraBackup 'true' -xtraBackupSettings/xtraBackupBinPath '/usr/bin'

On a Windows client:

qoperation execute -af create_instance_template.xml -appName 'MySQL' -clientName xxxxx -instanceName xxxxx -userGroupName xxxxx -BinaryDirectory xxxxx -LogDataDirectory xxxxx -configFile xxxxx -port xxxxx -SAUser/userName xxxxx -SAUser/password xxxxx -NTUser/userName xxxxx -NTUser/password xxxxx -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName xxxxx -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName xxxxx

Example:

qoperation execute -af create_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -BinaryDirectory 'C:\Program Files\MySQL\MySQL Server 5.1\bin' -LogDataDirectory 'C:\Program Files\MySQL\MySQL Server 5.1' -configFile 'C:\Program Files\MySQL\MySQL Server 5.1\my.ini' -port 3306 -SAUser/userName root -SAUser/password mysql -NTUser/userName 'testwin\administrator' -NTUser/password 'password' -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1

Modifying an Instance
  1. Download the modify_instance_template.xml file and save it on the computer from where the command will be executed.

  2. Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters values.

    qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName xxxxx -instanceName xxxxx -userGroupName xxxxx -associatedUserGroupsOperationType xxxxx -BinaryDirectory xxxxx -LogDataDirectory xxxxx -ConfigFile xxxxx -port xxxxx -SAUser/userName xxxxx -SAUser/password xxxxx -enableAutoDiscovery xxxxx -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName xxxxx -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName xxxxx

The following examples show some common modification operations.

Specifying the Configuration File

qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -ConfigFile 'C:\Program Files\MySQL\MySQL Server 5.5\my.ini' -SAUser/userName 'user1' -SAUser/password 'pwd1'

Specifying the Binary and Log Data Directory

qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -BinaryDirectory 'C:\Program Files\MySQL\MySQL Server 5.5\bin' -LogDataDirectory 'C:\Program Files\MySQL\MySQL Server 5.5\data' -SAUser/userName 'user1' -SAUser/password 'pwd1'

Modifying Xtrabackup Bin Path

qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -BinaryDirectory /usr/bin -LogDataDirectory var/log/mysql -configFile etc/mysql/my.cnf -port /var/run/mysqld/mysqld.sock -SAUser/userName 'root' -SAUser/password 'mysql' -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1 -xtraBackupSettings/enableXtraBackup 'true' -xtraBackupSettings/xtraBackupBinPath '/xtrabackupbin/'

Changing the Instance Name

qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -newName instance2 -BinaryDirectory /usr/bin -LogDataDirectory var/log/mysql -configFile etc/mysql/my.cnf -port /var/run/mysqld/mysqld.sock -SAUser/userName 'root' -SAUser/password 'mysql' -enableAutoDiscovery Yes -mysqlStorageDevice/logBackupStoragePolicy/storagePolicyName SP1 -mysqlStorageDevice/commandLineStoragePolicy/storagePolicyName SP1

Enabling Proxy Backup Operation
  1. Download the enable_proxy_instance_template.xml file and save it on the computer from where the command will be executed.

  2. Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters values.

    qoperation execute -af enable_proxy_instance_template.xml -appName 'MySQL' -clientName xxxxx -instanceName xxxxx -isProxyEnabled true -proxyInstance/clientName xxxxx -proxyInstance/instanceName xxxxx -runBackupOnProxy true -isUseSSL true

Example:

qoperation execute -af enable_proxy_instance_template.xml -appName 'MySQL' -clientName 'client1' -instanceName 'instance1' -isProxyEnabled true -proxyInstance/clientName 'client2' -proxyInstance/instanceName 'instance2' -runBackupOnProxy true -isUseSSL true

Getting Instance Properties
  1. Download the get_instance_properties_template.xml file and save it on the computer from where the command will be executed.

  2. Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters values.

    qoperation execute -af get_instance_properties_template.xml -appName 'MySQL' -clientName xxxxx -instanceName xxxxx

Deleting an Instance
  1. Download the delete_instance_template.xml file and save it on the computer from where the command will be executed.

  2. Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters values.

    qoperation execute -af delete_instance_template.xml -appName 'MySQL' -clientName xxxxx -instanceName xxxxx

Available Parameters for Instance Configuration

The following table displays all the parameters you can use with the commands mentioned in the above sections. To add a parameter to your command, use the following syntax: (A example is provided at the end of the table.)

qoperation execute -af <template XML file> -<parameter name> <value>

Parameter

Description of Parameter Values

clientName

Name of the client computer.

appName

Name of the application. In this case it would be 'MySQL'.

instanceName

Name of the MySQL instance. If you are specifying an instance other than the default instance, the name must be entered along with the client name, e.g. client1\instance1.

userGroupName

Name of the user group to be associated to the instance. This is the user group that you associate from the Security tab of the instance properties dialog box in the CommCell Console.

associatedUserGroupsOperationType

Specifies the operation that you want to perform on the user groups. Valid values are:

  • ADD, to add a new user group.

  • OVERWRITE, to change the existing user groups with others.

  • DELETE, to delete a user group.

BinaryDirectory

Path of the binary directory for the database instance.

LogDataDirectory

Path of the directory where the logs are stored for the database instance.

ConfigFile

Path of the configuration file for the database instance.

port

The port (on Windows) or socket file (on Unix) to open the communication between the MySQL server and its clients.

enableAutoDiscovery

Option to search in the MySQL instance for databases that are not configured in order to add them to the system. This discovery process runs on the entire instance prior a backup operation.

Valid values are True/False.

logStoragePolicy/storagePolicyName

Name of the storage policy used to back up this instance.

SAUser/userName

Name of the MySQL database administrator who has permissions to perform jobs.

SAUser/password

Password for the MySQL database administrator.

newName

New name of the MySQL instance.

The following example show how to add a parameter for a command:

Specifying the Configuration File

qoperation execute -af modify_instance_template.xml -appName 'MySQL' -clientName client1 -instanceName instance1 -ConfigFile 'C:\Program Files\MySQL\MySQL Server 5.5\my.ini' -SAUser/userName 'user1' -SAUser/password 'pwd1'

Loading...