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 →

MySQL monitoring with Datadog

Datadog is a monitoring service for cloud-scale applications, bringing together data from servers, databases, tools, and services to present a unified view of an entire stack. These capabilities are provided on a SaaS-based data analytics platform. Datadog uses a Python based, open-source agent. Its backend is built using a number of open and closed source technologies including D3, Apache Cassandra, Kafka, PostgreSQL, etc.It’s possible to correlate... Continue Reading →

MySQL Monitoring through Nagios on CentOS 6.8

Nagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. Before we begin, do note that the steps shown here are actually a continuation from my earlier series of tutorials based on Nagios: Prerequisites : Create a Nagios Monitoring Server on CentOS 6.8   Refer :  https://dptsource.blogspot.in/2017/03/install-and-configure-nagios-on-centos.html  ... Continue Reading →

Powered by WordPress.com.

Up ↑