MySQL Target Management
- 1 General
- 2 Targets management
- 2.1 Target host
- 2.2 Target DB Home
- 2.2.1 Add a DB Home
- 2.2.2 Modify a DB Home
- 2.2.3 See information about a DB Home
- 2.2.4 Delete a DB Home
General
A target host is a server that hosts the target databases - VDB’s. The target includes definitions of DB Homes - which are the installations of database software on the target hosts that are used to run VDBs.
Targets management
On the navigation bar, click Targets.
The Target Hosts view is displayed, listing all target hosts that have been added to the system
You can quickly locate a target host by typing its letters on the Search bar. The list updates promptly.
Target host
Add a target host
To add a target host, see Install target agent
The target host maybe Linux or AIX only.
Modify, see details or delete a target host
To modify, see details or delete a target host, see Manage target agent
Target DB Home
Add a DB Home
On the navigation bar, click Targets.
Select the required agent
Click the (+) sign in the right panel
Select a DB type.
Enter a name for the DB Home and an optional description
Enter the details of the DB Home
MySQL Home Dir - the location of MySQL installation on the target server
OS User - OS user that runs the MySQL on the target server
PXB binaries path - location of the XtraBackup utility on the target serverClick Add.
After the DB Home is added, the following message appears: DB Home has been added.
Modify a DB Home
On the navigation bar, click Targets.
Select the required agent
Select the required DB Home
Click Modify DB Home.
The Modify DB Home window appears. Modify the DB Home details as required. Same parameters as in adding DB Home
To save your changes, click Modify.
See information about a DB Home
On the navigation bar, click Targets.
Select the required agent
Select the required DB Home
Click DB Home info.
The Info window appears.
The info window shows the next details:
Name - name of the DB Home
Description - an optional description
IP-address - hostname or IP address of the target server where the DB Home is installed
MySQL binaries path - location of MySQL installation on the target server
OS User - OS user that runs the target database
PXB binaries path - location of the XtraBackup utility on the target server
Database Version - version of the target MySQL database
To return to the main Target Management work area, click Close.
Delete a DB Home
On the navigation bar, click Targets.
Select the required agent
Select the required DB Home
Click Remove DB Home.
Click Remove to confirm the deletion or Cancel to exit without deleting the DB Home.
After the DB Home is removed, the following message appears: DB Home has been removed.