Shiya, Author at ClusterEngine.me

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.

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.

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.

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.