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 →

Installing MySQL 5.6 on Ubuntu 14.04

Ubuntu 14.04 defaults to MySQL 5.5, but also has MySQL 5.6 available for installation from the  universe archive. Step 1: Install MySQL Server 5.6 Install mysql-server 5.6 with apt-get command : sudo apt-get update sudo apt-get install mysql-server-5.6 To install MySQL 5.6, install the mysql-server-5.6 package instead. sudo apt-get install mysql-server-5.6 There are two ways to install MySQL.... Continue Reading →

Install MySQL Server 5.6 (CentOS/Redhat)

Introduction In October 2013, the MySQL development team officially launched support for yum repositories. This means that you can now ensure that you have the latest and greatest version of MySQL installed directly from the source!.In this guide we will install MySQL 5.6 on a fresh installation of Centos 6. Installing MySQL The yum repository... Continue Reading →

Powered by WordPress.com.

Up ↑