Database Tuner is a plugin for Automate that dynamically adjusts MySQL to perform optimally for ConnectWise Automate.
The plugin works by scaling various components of MySQL based on the maximum connections variable and live performance data. All the adjustments are done in real-time without the need to bring the database offline. The performance tune is run every 12 hours to ensure that the database is always optimally configured. The plugin also offers messages advising if additional resources are needed based on the size of the database, as well as the option to put the database back to the default settings.
Database Tuner is designed for Automate servers with over 5,000 agents deployed. Its tuning algorithms include the sizing of buffers and caches, transaction handling, thread behavior, I/O scaling, connection handling, and adjustments to the MySQL query optimizer behavior. For smaller servers, we advise starting with our database tuneup service, as a number of the components tuned by Database Tuner are only needed at larger scales.
Technical Case Study: Reading from the computers table
To put Database Tuner to the test we created a simulated load scenario with the mysqlslap load testing tool. The computers table has 86 columns total, and it uses the InnoDB storage engine. We configured mysqlslap to automatically generate a table with the same number of character and integer columns (skipping columns containing timestamps and other data types). The simulation created 10 simultaneous connections (simulating 10 users) all trying to read the data 5 times (since the sluggish behavior from the Control Center is caused by a delay in reading the data). This test case was run 50 times to get an average representation.
As you can see, in our test environment with a light background load, the average time to run all queries was reduced by 21.46%. In a production environment (with an increased background load) the savings would be even greater.
What are others saying about Database Tuner?
Great plugin to add!
Automate has been much faster and more stable since installing the Database Tuner plugin.
Best thing you can do to your Automate Server is this!
I’ve been a Automate user since it was pre-CW (good ole’ LabTech software days!); I came in right before Ignite, so I’ve been utilizing Automate at various places for over 10 years. I just came to a new MSP for me and we moved over to Automate (On Prem) on some server hardware that was less than what is recommend by ConnectWise for Automate (We were in a crunch). This plugin made a huge difference on the basics of the systems, from constantly failing disabled monitors to glitches causing the Thick Client to have to be reloaded. I haven’t had a single one of these issues since I’ve started using the Database Tuner plugin. IF it makes a huge difference on 10 year old hardware that isn’t quite meeting the CW Automate requirements and makes it run smooth, Image what this will do to your system that has the modern resources in it. This will be a plugin that is continued to use when we do get our new hardware in as well.
Every Automate instance has a different environment. While we believe that the Database Tuner plugin will improve any environment, we want to make sure that the improvement is tangible. We advise anyone who is interested in the plugin to use the form below and start with a free 14-day trial. You’ll get the full performance tune, and you can decide for yourself if the plugin is a good fit for your server.
Our goal is to provide the most value for our service. Our plugin is priced as a monthly subscription; as the application changes so to do the performance needs, and thus our work is never done. We offer Database Tuner for $300/month. This gives partners an expertly tuned database for about the price of lunch. The average MSP can recover $660/user annually with our plugin, not to mention any time lost to stability issues. On average, time saved will make Database Tuner pay for itself for any Automate instance with more than 5 users.