Database Management

This guide explains how to create, list, and manage databases within the CCX platform for both PostgreSQL and MySQL systems. Databases is not a concept in Redis, and in Microsoft SQLServer creating databases is not supported.

Listing Existing Databases

Once databases are created, you can view the list of databases in the Databases tab.

• The Database Name column shows the names of the databases.
• The Size column displays the size of the database.
• The Tables column indicates the number of tables within each database.

• For MySQL, the database list will appear similar, with columns for database name, size, and tables.

Creating a New Database

To create a new database in the CCX platform:

Note

• PostgreSQL Database Owner: When creating a database in PostgreSQL, ensure that a valid user is selected as the owner of the database.
• MySQL Database Management: MySQL database creation does not require specifying an owner, but all other functions (listing, deleting) remain similar.

1. Navigate to the Databases Tab:

2. Click on the Databases section from the main dashboard.

3. Click on Create New Database:

4. A form will appear asking for the following details:
   • Database Name: The name of the new database.
   • DB Owner: The user who will own the database (applicable to PostgreSQL).

1. Submit the Form:

2. After filling in the necessary information, click Create to create the new database.

3. MySQL Database Creation:

4. For MySQL, the owner field is not required. You only need to specify the database name.

Dropping a Database

Note

• MySQL/MariaDb Database locks / metadata locks: The DROP DATABASE will hang if there is a metadata lock on the database or a table/resource in the database. Use SHOW PROCESSLISTin the mysql client to identify the lock. Either release the lock, KILL the connection, or wait for the lock to be released.

To delete or drop a database:

1. Locate the Database:

2. In the Databases tab, find the database you want to delete.

3. Click the Delete Icon:

4. Click on the red delete icon next to the database entry.
5. A confirmation dialog will appear asking if you are sure about dropping the database.

1. Confirm Deletion:
2. Click OK to proceed. WARNING: All data in the database will be lost.

Troubleshooting

Drop database hangs, the icon is spinning in the frontend.

Check if there are locks preventing the database from being deleted. - In MySQL, the DROP DATABASE will hang if there is a metadata lock on the database or a table/resource in the database. Use SHOW PROCESSLIST in the mysql/mariadb client to identify the lock. Either release the lock, KILL the connection, or wait for the lock to be released.