MySQL
Overview
MySQL is an open-source relational database management system. It supports SQL language and offer...
How to Connect
Connecting with Node.js
This guide explains how to establish a connection between a Node.js application and a MySQL datab...
Connecting with Python
This guide explains how to establish a connection between a Python application and a MySQL databa...
Connecting with PHP
This guide explains how to establish a connection between a PHP application and a MySQL database ...
Connecting with Go
This guide explains how to establish a connection between a Go application and a MySQL database u...
Connecting with Java
This guide explains how to establish a connection between a Java application and a MySQL database...
Connecting with phpMyAdmin
phpMyAdmin is a widely used web-based interface for MySQL that allows you to manage databases, ru...
Connecting with mysql
This guide explains how to connect to a MySQL database using the mysql command-line tool. It walk...
How-To Guides
Creating a Database
MySQL is a leading open-source relational database management system (RDBMS) known for its reliab...
Upgrading to a Major Version
Upgrading a database service on Elestio can be done without creating a new instance or performing...
Installing and Updating an Extension
MySQL supports a variety of plugins that extend the functionality of the database engine. These p...
Creating Manual Backups
Regular backups are a key part of managing a MySQL deployment. While Elestio provides automated b...
Restoring a Backup
Restoring backups is essential for recovery, environment duplication, or rollback scenarios. Eles...
Identifying Slow Queries
Slow queries can degrade the performance of your MySQL-based application, leading to lag, timeout...
Detect and terminate long-running queries
Long-running queries in MySQL can degrade database performance by consuming system resources like...
Preventing Full Disk Issues
Running out of disk space in a MySQL environment can result in failed writes, temporary unavailab...
Checking Database Size and Related Issues
As your MySQL database grows, it’s crucial to track how space is being used across schemas, table...
Database Migration
Cloning a Service to Another Provider or Region
Migrating or cloning services across cloud providers or geographic regions is a critical part of ...
Database Migration Service for MySQL
Elestio provides a structured approach for migrating MySQL databases from various environments, s...
Manual Migration Using mysqldump and mysql
Manual migrations using MySQL’s built-in tools mysqldump and mysql, are ideal for users who requi...
Cluster Management
Overview
Elestio provides a complete solution for setting up and managing software clusters. This helps us...
Deploying a New Cluster
Creating a cluster is a foundational step when deploying services in Elestio. Clusters provide is...
Node Management
Node management plays a critical role in operating reliable and scalable infrastructure on Elesti...
Adding a Node
As your application usage grows or your infrastructure requirements change, scaling your cluster ...
Promoting a Node
Clusters can be designed for high availability or role-based workloads, where certain nodes may t...
Removing a Node
Over time, infrastructure needs change. You may scale down a cluster after peak load, decommissio...
Backups and Restores
Reliable backups are essential for data resilience, recovery, and business continuity. Elestio pr...
Cluster Resynchronization
In distributed systems, consistency and synchronization between nodes are critical to ensure that...
Database Migrations
When managing production-grade services, the ability to perform reliable and repeatable database ...
Deleting a Cluster
When a cluster is no longer needed—whether it was created for testing, staging, or an obsolete wo...
Restricting Access by IP
Securing access to services is a fundamental part of managing cloud infrastructure. One of the mo...