Part I: MySQL administration via NodeWorx Up Part I: MySQL administration via NodeWorx Chapter 2: NodeWorx MySQL Overview Page 

1 An Introduction to InterWorx’s MySQL Integration

InterWorx interfaces with the MySQL server software much like you’d expect. For example, configuring options interacts with the server’s main configuration file /etc/my.cnf. Additionally, in order to determine whether the service is online, the /etc/init.d service control script is used to query the status of the service. The user-friendly web interface can be located inside NodeWorx under System Services ▷ MySQL Server.

1.1 Compatibility With InterWorx

InterWorx does not provide the RPM package for the mysql server. Instead, we rely on the operating system’s maintainers to build and distribute the MySQL package for their system. It is always possible to upgrade or switch sources of your MySQL server as long as the following requirements are met:
  • The MySQL server version must be version 5.0 or higher.
  • On InterWorx install, InterWorx should be able to access the root user of the MySQL without a password. This is the default for most Red Hat based fresh OS installs.

1.2 Additional abilities

1.2.1 phpMyAdmin

InterWorx has a fully integrated version of phpMyAdmin which allows SiteWorx users and NodeWorx resellers to manage all MySQL databases under their account, even if the databases are segregated across multiple MySQL users. In addition, from NodeWorx, administrators are able to see all databases for all users on their servers and manage them via phpMyAdmin. Our version of phpMyAdmin sits behind the authentication mechanism of InterWorx and thus is not accessible from the outside without providing correct NodeWorx or SiteWorx credentials (depending what panel you are logging in to).

1.2.2 Remote Servers

In the event you don’t want to use the localhost MySQL server, InterWorx supports adding “remote” servers and assigning SiteWorx accounts to the remote servers. This allows you to segregate MySQL CPU and memory requirements on a separate server. This also allows you to scale the memory allotted to the server up for superior performance since a remote MySQL server can be set to do “only” MySQL. In addition, the remote server is not required to run InterWorx or even an RHEL compatible operating system - you can choose what ever operating system you feel most comfortable administering a MySQL server on.
If you never want to use the localhost server, it is also possible to designate a remote server as the default MySQL server, and all SiteWorx accounts will use the remote MySQL server by default. This is covered in more depth in section 3.3↓.
 Part I: MySQL administration via NodeWorx Up Part I: MySQL administration via NodeWorx Chapter 2: NodeWorx MySQL Overview Page 

(C) 2017 by InterWorx LLC