Create a MySQL repository database
After you install DPA, you must create the repository database, which holds the performance data that DPA collects. Use this procedure to create a MySQL repository database.
If one or more monitored database instances is created with multi-byte support, the repository database should also be created with multi-byte support.
Before you start
Before you run the Repository wizard:
|Make sure the repository database server meets the system requirements.|
|Install a supported version of MySQL on the database server.|
|If you run the wizard from a different computer (not the server where DPA was installed), make sure the required firewall port is open. By default, port 8124 must be open.|
|The DPA server connects to the repository through a TCP/IP connection. Make sure that connection is not blocked by a firewall.|
Run the wizard
To open DPA, enter the following URL in a web browser, where
yourServeris the hostname or IP address of the DPA server:
If the repository database has not been created, the Repository wizard opens automatically.
- Click Create New Repository.
Complete the remaining wizard panels as described in the following table.
|Select Repository Database Instance Type||Select MySQL as the database type.|
|Enter Repository Connection Information||
DPA creates a new database and populates it with tables, indexes, and initial data.
If you are using MySQL 8.0 as the repository database, you must create the repository user manually, and you must include the following in the
To create a new account:
To specify and existing account:
Alternatively, you can use the script that DPA provides to create a repository user.
|Enter Repository Login||
If you provided the repository user in the previous step, the wizard skips this step.
DPA can create the repository administrator account, or you can specify an existing account. To ensure that the account has the required permissions, SolarWinds recommends creating a new account.
To create a new account:
To specify an existing account:
|Specify Database for the Repository||
To store the repository in a new database, enter a database name. DPA prefixes the name with
To store the repository in an existing database, select a database from the list.
This option is available only if the repository instance contains an empty database.
Enter your name and email. DPA sends database performance reports to this address.
Review the information and click Create Repository.
|Finished Repository Creation||
After the repository has been created, click Register Database Instance to start registering instances, or close the wizard and register instances later.