MySQL Target Management

MySQL Target Management

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

  1. On the navigation bar, click Targets.

The Target Hosts view is displayed, listing all target hosts that have been added to the system

image-20250507-144058.png

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

  1. On the navigation bar, click Targets.

    image-20250507-144510.png
  2. Select the required agent

  3. Click the (+) sign in the right panel

  4. Select a DB type.

    image-20250507-153318.png
  5. Enter a name for the DB Home and an optional description

    image-20250507-144617.png
  6. Enter the details of the DB Home

    image-20250507-144742.png

     

    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 server

  7. Click Add.

After the DB Home is added, the following message appears: DB Home has been added.

Modify a DB Home

  1. On the navigation bar, click Targets.

  2. Select the required agent

  3. Select the required DB Home

  4. Click Modify DB Home.

    image-20250507-153421.png
  5. The Modify DB Home window appears. Modify the DB Home details as required. Same parameters as in adding DB Home

    image-20250507-153502.png

     

    image-20250507-153512.png
  6. To save your changes, click Modify.

See information about a DB Home

  1. On the navigation bar, click Targets.

  2. Select the required agent

  3. Select the required DB Home

  4. Click DB Home info.

    image-20250507-153546.png

    The Info window appears.

image-20250507-153603.png

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

  1. To return to the main Target Management work area, click Close.

Delete a DB Home

  1. On the navigation bar, click Targets.

  2. Select the required agent

  3. Select the required DB Home

  4. Click Remove DB Home.

    image-20250507-153913.png
  5. 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.

 

 

Related content