How to Create MongoDB Replication Clusters

Unlike relation database servers, scaling NoSQL databases to meet increased demand on your application is fairly simple – you drop in a new server, make a couple of config changes, and it connects to your existing servers, enlarging the cluster. All existing databases and collections are automatically replicated and synced with the other member nodes.

A replication cluster works well when the entire data volume of your database(s) is able to fit onto a single server. Each server in your replication cluster will host a full copy of your databases.

How to Create a MySQL Master Slave Cluster on Ubuntu 14

Improve application performance and availability by learning how to create a MySQL Master\Slave cluster on Ubuntu 14

Install and Configure MongoDB on Ubuntu 14

MongoDB is one of the most popular open source NoSQL database solutions available. Unlike relational databases that store rows of data, document oriented databases like this one store data as, you guessed it, documents. These types of databases are not constricted by rigid schemas. They also scale much easier and more efficiently than relational databases, meaning it is a lot easier to store once unthinkable amounts of application data.

MongoDB is able to achieve and maintain high performance – much greater than any relational database, such as Microsoft SQL – even while storing petabytes of data by offloading a lot of logic to your application. A relational database it is not, but this trade off gives are developers the flexibility they need to work with data in today’s high volume, big data world.

The tutorial will guide you through the installation through to managing your databases.

Installing Memcached to Improve Database Performance

SQL databases are very good at storing and retrieving data, and they can do so quickly. However, no matter how well you tune your database servers there will come a time during periods of high traffic that your database server becomes a large bottleneck. By utilizing technologies like Memcache, we can keep results of frequently used database queries in a cache stored in RAM. Using the cached results significantly decreases that amount of time and effort to retrieve data and present in our application.

Memcache is what’s known as an in-memory key-value store. The key is a unique identifier that is used to quickly search for cached strings or objects. The value is the data that has been cached. For the purpose of storing database query results, the key will typically be the query used on your database.

How to Configure MySQL 5.1 Master Slave Database Replication

Learn how to replicate your MySQL databases from one server to another to ensure a live copy is always available. This configuration uses a master-slave methodology, which maintains a live version of your database on another server in read-only mode. In a disaster scenario, where your master server fails, the slave can then be promoted to a master, bring your application back online without the need to restore from backups.

Installing and Configuring MariaDB on Ubuntu 14

Overview This tutorial will guide you through the deployment process of MariaDB on Ubuntu 14.  We’ll start by configuring the hardware and then move into the installation and configuration of MariaDB. MariaDB is a fork of the very popular and open source MySQL database, which is now owned by Oracle. In fact, the two were […]

Installing and Configuring MariaDB 10 on CentOS 6

This tutorial will guide you through the deployment process of MariaDB on a Red Hat-based Linux server, such as CentOS. We’ll start by configuring the hardware and then move into the installation and configuration of MariaDB.

Install and Configure MySQL 5 on Ubuntu Server 13

Learn how to install MySQL 5.5 on Ubuntu 13.10 the right way, following best practices for security.

Moving MySQL Databases to Separate Disks

You may have a database server which started out small, with all its databases stored on the same disks, that is now experiencing severe storage I/O bottlenecks.

© 2014 Shane Rainville