Скачать или смотреть How to Automate MySQL Hosting & Management | ScaleGrid

MySQL management eating up too much of your time? Ready to automate those time-consuming tasks so you can refocus on product?

ScaleGrid's database as a service platform allows you to deploy, monitor, provision, and scale your clusters seamlessly in both public and private clouds.

Create a new MySQL cluster in minutes with the creation wizard. Enter a unique name, select your data center region, VM size, version, and storage engine to kick off the process.

Then, we can customize our high availability setup by enabling a master-slave configuration. Choose between asynchronous or semisynchronous replication, and select the data center regions you wish to replicate to.

Enable SSL and disk encryption in two clicks, then enter your IP addresses to configure your firewall rules.

Review the details on the last page, and click Create to spin up your first cluster!

Once your cluster is live, grab your Connection String to connect your MySQL cluster to your application using any of these popular programming languages and interfaces.

Now, let's walk through MySQL backups. On your Overview tab, click the Backups & Restores button and select Backups. You can perform a one-time backup on demand, or customize a backup schedule based on frequency, start time, number to retain, and your backup target. Click save to automate your backup schedule, and restore a backup anytime in just three clicks.

When you're ready to scale up, just click the Scale button on your MySQL cluster details page and select your new instance size to dynamically scale your CPU, memory, and disk size automatically. So long as you have a replica set, your deployment will scale through a rolling upgrade with zero downtime for your application. 1:36

Find the Monitoring Console on your MySQL cluster details page to get advanced insights into your deployment. Select between your Master and Slave server, time range to analyze, and time zone you're located in.

The Overview tab provides all of your MySQL performance reports, including opscounter, connections, threads activity, and open table metrics. Select the Expand icon in the corner for a detailed look into your performance, and definitions on the metric.

You can also check out your operating system metrics, InnoDB storage engine metrics, and replication metrics by switching between the top tabs.

One of the most powerful MySQL tools at ScaleGrid is the Slow Query Analyzer. Dive into a heatmap of all the queries in your system for any particular time range. The higher up a query, the slower it is, and all queries of the same type have the same color. Click over a bubble to see what type of query is associated with it, and drag to zoom in for a closer look at a specific time range.

The pie chart on the right breaks down the top queries causing read load in your system, and the report below allows you to analyze your query data in a detailed tabular format that can be sorted by column.

ScaleGrid is also the only multi-cloud DBaaS platform that allows you to host and manage your MySQL instances through your own cloud setup. Simply create a Cloud Profile to connect to your AWS or Azure account, and begin leveraging advanced capabilities like Virtual Private Clouds, Security Groups, and Reserved Instances to save up to 75% on your long-term hosting costs.

You also maintain full control of your deployments with MySQL super user access and SSH access to your machines.

Manage all of your open source databases in one centralized management console alongside your MySQL deployments, including PostgreSQL, Redis, and MongoDB.

Ready to automate your time-consuming MySQL operations? Start a free 30-day trial at scalegrid.io to explore all the incredible features at your fingertips. Don't waste another minute - get back to what you love most, building your amazing applications.

If you have any questions, please email us at [email protected].

ScaleGrid Managed Databases: https://scalegrid.io/
ScaleGrid for MySQL Database: https://scalegrid.io/mysql/
MySQL Enterprise On-Premises: https://scalegrid.io/enterprise/
ScaleGrid Pricing: https://scalegrid.io/pricing/
Help Docs for MySQL Database: https://help.scalegrid.io/docs/mysql-...
Free 7-Day Trial: https://console.scalegrid.io/users/re...