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.

From Version 2.0, MaxScale license changed from GPLv2 to MariaDB BSL.

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]