Technology · Database
MySQL database support for ConnectWise Automate
On-premise ConnectWise Automate runs on a MySQL database, and most Automate performance problems start there. TechPIO engineers tune, maintain and back up the Automate database so the control centre stays fast and the data stays safe.
About the platform
What is MySQL and how we use it
MySQL is an open-source relational database management system, developed by Oracle, that is widely used behind web applications and business software. On-premise ConnectWise Automate servers store their configuration, monitoring and agent data in a MySQL database.
TechPIO looks after MySQL as part of ConnectWise Automate consulting: database health checks and performance tuning, table maintenance and clean-up of oversized tables, backup and restore procedures for the Automate server, and migration of the database during server moves or upgrades.
At a glance
- Category: Database
- Delivered through: ConnectWise Automate Consulting
- Coverage: business hours, or 24/7 through our managed NOC
- White-label: your brand, your clients, our engineers
- Official website: mysql.com
What we do
How we support MySQL for MSPs
Hand over one task or the whole platform. Every change is made inside your instance, with your permissions, and documented in your systems.
Health checks and performance tuning
Slow queries, configuration, indexing and table sizes reviewed so the Automate control centre and web interface stay responsive.
Maintenance and clean-up
Scheduled maintenance, purging of oversized monitoring and history tables and data-retention settings aligned to your needs.
Backup and recovery
Automate database backups set up, monitored and restore-tested so an Automate server can be rebuilt with confidence.
Server moves and upgrades
MySQL migration as part of Automate server migrations, version upgrades and hardware refreshes.
Related services
Services that include MySQL work
The TechPIO services where our MySQL engineers do their day-to-day work.
Also in our stack
Related technologies
Platforms that usually sit alongside MySQL in an MSP stack.
Frequently asked questions
MySQL questions MSPs ask us
How TechPIO works in MySQL, what we need from you and what to expect.
Still have a question?
Talk to an engineer who knows MSP operations, not a sales script. We reply within one business day.
Is MySQL support only for ConnectWise Automate?
It is where most of our MySQL work happens, because on-premise Automate depends on it. We also look after MySQL behind other on-premise tools as part of project work.
Can you fix a slow Automate control centre?
Usually yes. Most slowness traces back to the database: oversized tables, missing maintenance or configuration. We review, tune and document the fix.
Do you back up the Automate database?
Yes. We set up and monitor database backups and run restore tests as part of Automate administration.