System Services : MySQL Server¶
System Services > MySQL Server
This menu section in NodeWorx is where Server Administrators can manage system MySQL settings, remote MySQL servers, and access PHPMyAdmin.
InterWorx utilizes two different MySQL instances–there is the system MySQL instance that is used for domain-level MySQL processes and sessions, and also an internal MySQL instance specifically for the InterWorx software. This allows users to install any server-level version of MySQL that they would like, as long as it is a newer version that what is already installed on the server, without risk of affecting the InterWorx software.
The menu options under MySQL Server manage the system MySQL instance.
Manual changes to the internal InterWorx database should only be performed InterWorx Support Technicians.
Technically speaking, InterWorx Support does not directly support the server MySQL instance, though they will try to guide in the correct direction, if contacted.
While many tasks related to MySQL can be completed via the GUI, there are many others that require configuration at the CLI, such as creating non-prefixed databases assigned to a specific SiteWorx account, or changing the database server for a SiteWorx account.
Documentation on managing MySQL with InterWorx can be found here.
Logging related to the system MySQL service can generally be found in the /var/log/mysql/
or
/var/log/mariadb/
directories. If those directories do not exist on the server, logging related
to MySQL will be found in the /var/log/messages
log file.
Overview¶
System Services > MySQL Server > Overview
From the OverView page, Server Administrators can easily manage:
The status of the server MySQL service
MySQL server options
The MySQL root password
Current MySQL processes
Documentation on managing the server MySQL instance can be found here.
Manage Servers¶
System Services > MySQL Server > Manage Servers
From the Manage Servers page, Server Administrators can easily manage:
Adding and deleting remote MySQL servers
Checking the status of both remote MySQL server and the localhost MySQL instance
Unmapped MySQL databases and users
External, remote MySQL servers do not need to have InterWorx installed.
Documentation on managing MySQL servers can be found here.
PHPMyAdmin¶
System Services > MySQL Server > PHPMyAdmin
Using PHPMyAdmin, Server Administrators can easily:
Manage customer MySQL databases
Manually create new databases
Manage system MySQL user settings
Import and export database backups in various formats
Documentation on how to use PHPMyAdmin can be found here.