MySQL InnoDB Cluster – A Hands on Tutorial

MySQL InnoDB cluster provides a complete high availability solution for MySQL.Each MySQL server instance runs MySQL Group Replication, which provides the mechanism to replicate data within InnoDB clusters, with built-in failover. This work instruction details the steps to setting up a cluster MySQL InnoDB, how to manage IT and the recovering procedure in case of... Continue Reading →

Install MySQL 8.0 in Linux and Windows

MySQL community server is a free open source, popular and cross-platform database management system. It supports both SQL and NoSQL, and has a pluggable storage engine architecture. Additionally, it also comes with multiple database connectors for different programming languages, allowing you to develop applications using any of the well known languages, and many other features. MySQL Server is intended... Continue Reading →

Upgrade from MySQL 5.7 to MySQL 8.0

MySQL server's can be upgraded by performing either an INPLACE upgrade or LOGICAL upgrade. The Inplace upgrade involves shutting down the MySQL 5.7 server, replacing the old binaries with MySQL 8.0 binaries and then starting the MySQL 8.0 server on the old data directory. The Logical upgrade involves exporting SQL from the MySQL 5.7 version... Continue Reading →

MySQL Database Administration Commands

To login (from unix shell) use -h only if needed. # [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the MySQL server. mysql> create database [databasename]; List all databases on the MySQL server. mysql> show databases; To delete a database. mysql> drop database [database name]; To delete a table. mysql> drop table... Continue Reading →

Create Hot Backups of MySQL Databases with Percona XtraBackup

Introduction Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits:  Backups that complete quickly and reliably  Uninterrupted transaction processing during backups  Savings on disk space and network bandwidth  Automatic backup verification Higher uptime due to faster restore time Percona XtraBackup makes MySQL hot backups for... Continue Reading →

Powered by WordPress.com.

Up ↑