Install and Use MySQL/MariaDB
Learn how to get started with the popular relational database MySQL/MariaDB. This quickstart guide will cover the installation of both, and an introduction to basic MySQL/MariaDB commands.
Using MySQL Cluster for Scalability and High Availability (HA)
There are many different ways to configure MySQL to improve scalability or high availability (HA), with a lot of overlap between these two concepts. Learn how using MySQL Cluster with Cloud Servers can be used as a solution to provide scalability, high availability, or both.
When to Use MySQL
"NOSQL" solutions like CouchDB, MongoDB, and Redis are popular new choices for storing data. Learn when to choose MySQL over these new options, including what use cases are most appropriate for MySQL, and when it will be a "best fit" for your project needs.
This use case covers scalability options for MySQL, which involves ways to spread the database and the load of application queries across multiple servers in order to improve performance. Scalability is one aspect of creating a high availability (HA) database installation.
Install or Upgrade MySQL on Windows Server 2016
Learn how to install MySQL on a Cloud Server with Windows Server 2016, using the free MySQL Installer tool.
Use MySQL Workbench to Manage MySQL on Windows Server 2016
MySQL Workbench is a convenient visual administration tool designed for database architects and developers to perform server configuration, database migrations, user administration, and other MySQL tasks through a graphic user interface (GUI).
Manage MySQL/MariaDB on a Cloud Server with Linux
MySQL is the most popular SQL database on the internet, along with MariaDB (a drop-in replacement commonly used on CentOS 7 and other Linux distributions). Learn the basics of managing MySQL/MariaDB on a Cloud Server with Linux.
Install phpMyAdmin on a Cloud Server with Linux
PhpMyAdmin is a convenient way to manage MySQL/MariaDB for those who prefer a browser-based interface over the traditional command-line interface. Learn how to install and use phpMyAdmin on a Cloud Server with Linux (Ubuntu 16.04 or CentOS 7).
Optimize MySQL/MariaDB Performance on a Cloud Server with Linux
MySQL/MariaDB is a robust, powerful, and popular database choice. However, without fine-tuning, it can be inefficient in its use of server resources. Learn how to optimize MySQL/MariaDB performance in order to improve database response time and minimize server overhead.
Use PHP to Retrieve Information From a MySQL/MariaDB Database
PHP is designed to easily integrate into a website. One of the most common uses for PHP is to take content from a database and output it on an HTML page. This tutorial will cover how to connect to a MySQL/MariaDB database, pull out information from a simple table, and display it in a simple HTML table.
Solve a MySQL/MariaDB "Too many connections" error
Learn how to solve the MySQL/MariaDB "Too many connections" error, which occurs when all available MySQL/MariaDB connections are in use. This error may occur in a script which connects to MySQL/MariaDB, or on a webpage which is generated (in whole or in part) from elements provided by a MySQL/MariaDB database.
How to use MySQL With Your Ruby on Rails Application
Ruby on Rails uses SQLite as its database by default, but it also supports the use of MySQL. SQLite is an excellent alternative to a traditional database like MySQL, but it has some limitations, particularly with regards to concurrency and scaling to a high load, which may make MySQL a better choice for your project.
Connect to a MySQL/MariaDB Database with PHP on a Cloud Server Running Linux
Learn how to connect to a MySQL/MariaDB database using PHP on a Cloud Server running Linux. This tutorial will cover connecting to a database on the same server as the PHP application, as well as how to connect to a database on a different Cloud Server.
"Error establishing a database connection" MySQL/MariaDB error
Learn how to fix "Error establishing a database connection” for MySQL/MariaDB on a Linux Server. With this guide you can easily fix the error for MySQL and MariaDB.
How to Install and Configure MySQL/MariaDB for WordPress
Learn how to install and configure MySQL/MariaDB for WordPress. With this guide we will show you how to install and setup MySQL or MariaDB for a WordPress installation.
How to Reset the MySQL/MariaDB Root Password, Import and Export Databases
Learn basic MySQL/MariaDB disaster recovery and preparedness: How to reset the root MySQL/MariaDB password, import databases from an exported MySQL dump file, and export databases into a MySQL dump file for backup.
MySQL High Availability (HA)
This use case covers high availability (HA) options for MySQL, which involves ways to cope with and recover from failures, and allow scheduled maintenance activity, without causing any downtime.