Client/Server architecture of MySQL Networked environment using a client/server model. -central acts as server -Various client programs connects to the server and make requests. Components Of MySQL Installations : The MySQL Database also follows the client and server model architecture and following are the components… Read More
Introduction to MySQL Database Administration. What is MySQL? MySQL is the most popular open source SQL database management system and it is developed, distributed and supported by Oracle Corporation. Initially MySQL was introduced by MySQLAB organization and acquired by SUN MICRO SYSTEMS then MySQL acquired… Read More
Installation of MySQL Sever in Ubuntu using Generic Binaries. To begin the Installation process first download the generic binary from mysql.com or use the below link for downloading MySQL Sever Software Link to Download Binaries: https://dev.mysql.com/downloads/mysql/ Steps to Configure MySQL Server: Create a group with… Read More
When to Use MongoDB Is MongoDB right for your application? That depends on the kind of data you have, and what you want to do with that data. NoSQL databases have risen to the occasion when it comes to unstructured data and the kind… Read More
Dear Readers, In this article we will see Rise of NoSQL databases. Over the last few years we have seen the rise of a new type of databases, known as NoSQL databases that are challenging the dominance of relational databases. Relational databases have dominated the software industry for a… Read More
Which one to choose RDS v/s MySQL on EC2 A lot of clients for whom we manage AWS come up with a simple question of which out of “RDS vs EC2” is better for their MySQL database requirements. The answer to this simple question is… Read More
Introduction Clustering adds high availability to your database by distributing changes to different servers. In the event that one of the instances fails, others are already available to continue serving. Clusters come in two general configurations, active-passive and active-active. In active-passive clusters, all writes are… Read More
About MySQL replication MySQL replication is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database. Advantages of replication in MySQL include: Scale-out solutions – spreading the load among… Read More
MySQL Replication Setup Replication in MySQL. You will have to setup Master and Slave server. All read-writes to the DB could go to your Slave Server. Advantage of having Replication is you can take a backup from your slave server without interrupting Master server,… Read More
Installing Multiple MySQL The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines. MySQL provides a tool to facilitate the execution of… Read More
