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

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

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