Changes and Enhancements in MySQL 5.7.19

MySQL 5.7.19 is available from late July 2017 onwards. Below are the changes in this version, compared to the prior one.

Read more

MySQL Server Replication Implementation

In the previous article of this series – Advantages of MySQL Server Replication, we have discussed the concept, basics and advantages of MySQL Server Replication. In this article, we will be seeing how to setup and implement a well configured MySQL master-slave replication for scalability and performance.

Read more

Advantages of MySQL Server Replication

Replication is a powerful feature in-built in MySQL Database Server. In replication data from the primary server (Master) is copied to one or more secondary servers (Slaves). The shared data can be all databases, a subset of databases or even tables only. This data replication is asynchronous, means that, slaves need not maintain connection to master all the time to synchronize data and request the latest version of data anytime they are configured to.

Read more

Basics of MariaDB Server Commands

MariaDB, the popular open source database software can be installed and run various types of servers like: standalone machine, virtual machines, cloud, containers etc. It is available with all major Linux distributions such as Debian and Ubuntu. Furthermore it is the default database in RedHat Linux, CentOS, Fedora, openSUSE, SUSE Linux Enterprise etc. The latest tar and binary downloads for Linux, Solaris and Windows are available at the Official MariaBD Download site.

This article discusses about the essential post-installation administrative tasks for managing MariaDB Server effectively.

Read more

Advantages of Database As A Service – Database Outsourcing

Growing Database Operational Requirements

With growing application level and enterprise requirements, firms are either willingly or unwillingly expanding their data capabilities. These include data organization and structure, storage, security and other functional/non-functional requirements like setting up and configuring the data store for fast and efficient data search, retrieval, speedy writes, etc. Apparently, along with a fast growing data store, the resource requirements for a 24/7 available Database Administrator (DBA) team with quick turnaround, solid state-of-the art technologies for data storage, networking and distribution, backup and security have become the integral part of these small to large firms and enterprises.

Read more

Tools for Database Management. TeamSQL.

We continue to talk about tools for working with MySQL databases. In our reviews we test management and monitoring systems as well as other programs that will be useful for you to work with databases. Today we will consider a project called TeamSQL that has recently appeared on the market.

Read more

Performing Backup of a Live MySQL Database using mysqldump

Live MySQL Backup without Locking Tables

Mysqldump client utility is the easiest and favorite tool for DBAs to backup a MySQL database. It supports numerous options to configure the backup such as type of backup format, what to backup, how to deal with key constraints, how to deal with transactions etc. The output of a mysqldump backup operation is named as a dump file and it can be restored to recreate the backed up database. The dump files can be in formats like CSV, tab-delimited, SQL, XML etc. The dump file can be further compressed using a suitable compression utility like Tar, Gzip, XZ, Bzip2 etc to reduce the dump file size to make it easier for storage and transfer.

Read more

Is Docker Perfect for Databases?

Docker – a Revolutionary Container Platform

Before going into the analysis, let’s have a brief idea about Containers and Docker. A Container is an executable package of software designed to provide an isolated environment for applications to run in a host server. They have all the necessary code, runtime, libraries etc. to provide a safe environment for the application software. Prominent enterprises like Uber, Facebook, Google etc are using Containers in a very high scale. Docker is a software container platform and is used to create container units on host machines. Many such units share the host’s OS, RAM, Processor and other resources. Disk usage is minimized by sharing filesystem layers and common files. Docker containers help in many aspects for Software Lifecycle, starting from development to deployment and implementation. It provides an agile continuous integration platform with isolated units for development teams, with development, test and production environments. It makes a server compatible for a wide variety of software applications that have different dependencies. Docker makes the host platform portable and distributed by virtue of its self sufficient and isolated container feature. All these come along with reduced need of computing power and space, since Docker Containers use the same Kernel in a host, rather than VMs using separate guest OS.

Read more

MySQL Backup and Restore Methods

It is important from an administrative and operational point of view to safeguard your data and database from all kind of risks. Applying this to a MySQL database, it has lot of challenges to overcome and survive – so that the data associated with it is safe, with precise data integrity and genuineness over time. As like any software applications, a MySQL database is also facing threats and challenges in the below forms:

  1. Hardware and software failures
  2. Operating system/File system crashes
  3. Data corruption and deletion
  4. Database upgrades and data corruption
  5. Etc.

Read more