In this post, We’re going share the details about Operation and Administration part of the MaxScale. To view Installation and Configuration of MaxScale checkout our previous blog.
Before going through this week’s topic, I would highlight some recent change at MaxScale has went through.
MariaDB BSL enforces usage limitation for free use, require licensing for the unlimited access.
" Usage Limitation: Usage of the software is free when your application uses the Software with a total of less than three database server instances for production purposes "
All the MaxScale Operational / Administrative commands can be executed on MaxAdmin console. To login the console we can use the default password ‘mariadb’.
Alternatively password can be given inline to login the MaxAdmin console.
MaxScale Operational / Admin Commands
1. list services
This can be used to identify the services that are running and the router associated with the service.
Here, Service RW is associated with readwritesplit router,
Service Console is associated with cli router (which a MaxAdmin Process).
2. show service [service_name]
This can be used view detailed statistics about any of the running service.
This provide us useful statistics like Percentage of connections split between Master and Slave, Number of current connections, Total connections etc.,
3. enable root [service_name]
By default, root login to the backend servers is disabled when connecting through the MaxScale. We can enable root login to backend server with this command.
4. set / clear [server_name] maintenance
This is one of the most useful command, We can use this to take out a node out of production traffic for maintenance.
You can see from the above example, Initially three nodes were taking traffic, When set node2 on maintenance mode connections are dropped off.
Once maintenance is complete, We can use clear command to put back the node on production traffic.
5. reload config
We don’t need to restart MaxScale for the changes in configuration to take effect. We can able to load the changes in the configuration with reload command.
6. flush logs
By default, MaxScale error log is stored at /var/log/maxscale/
This command can be used to flush the current log and create a error log.
7. show dbusers [service_name]
This command displays the aggregated list of unique users present in all the backend servers of a service.
MaxScale caches the user details on a hash table for faster connections. Hash table entries are updated each time when it encounters a miss or failure. It can also be updated forcefully by the command MaxScale> flush dbusers [service_name]