CS2671 Configuration

CS2671 is the database server using Percona MySQL 8.0 and ProxySQL.

Percona MySQL 8.0

Percona MySQL is configured via the /etc/my.cnf file and can be controlled via the user with sudoer access using the following commands:

Command	Usage
sudo service mysql start	Start the MySQL server
sudo service mysql stop	Stop the MySQL server
sudo service mysql restart	Restart the MySQL server, e.g. stop and start
sudo service mysql status	Display the status of the MySQL server

ProxySQL

ProxySQL is used to control access to the MySQL server(s) to allow for tasks like upgrades to be completed without downtime. All connections to the MySQL server from Lucee, PHP, etc… should use the ProxySQL connection, port 6033 and not connect directly to the MySQL server.

ProxySQL can be controlled via a user with sudoer access using the following commands:

Command	Usage
sudo service proxysql start	Start the ProxySQL server
sudo service proxysql stop	Stop the ProxySQL server
sudo service proxysql restart	Restart the ProxySQL server, e.g. stop and start
sudo service proxysql status	Display the status of the ProxySQL server

To configure ProxySQL, the ProxySQL console should be used. To access the ProxySQL console from an SSH terminal, the following command should be entered:

mysql -u proxysqlroot -p -h 127.0.0.1 -P6032 --prompt='Admin> '

The ProxySQL root user password can be found in the OT Server Details Google Sheet.

The ProxySQL documentation can be found here: https://github.com/sysown/proxysql/wiki