Setting up MySQL Master-Slave Replication with GTID

A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (master). This identifier is unique not only to the server on which it originated, but is unique across all servers in a given replication setup. There is a 1-to-1 mapping between all transactions and... Continue Reading →

Create a Simple CRUD Database App in HTML with MySQL Database and PHP

Some of you might be owing a website and would certainly be editing and updating it frequently. Through this article I will make know how you could develop a working website with a very little knowledge and could even host it using your Linux box. A quick example of a CRUD application would be a... Continue Reading →

AWS-Elastic Load Balancer Tutorial

Elastic Load Balancing automatically distributes your incoming application traffic across multiple targets, such as EC2 instances. It monitors the health of registered targets and routes traffic only to the healthy targets. Elastic Load Balancing supports three types of load balancers: Application Load Balancers, Network Load Balancers, and Classic Load Balancers. Table of Contents  Benefits of... Continue Reading →

MySQL Database Administration Commands

To login (from unix shell) use -h only if needed. # [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the MySQL server. mysql> create database [databasename]; List all databases on the MySQL server. mysql> show databases; To delete a database. mysql> drop database [database name]; To delete a table. mysql> drop table... Continue Reading →

Securing MongoDB with X.509 Authentication

We look at how to configure transport encryption on a deployed MongoDB replica set.Encrypting intra-node traffic ensures that no one can “sniff” sensitive data on the network.This article will guide you through the process of setting up a MongoDB cluster that will utilise X.509 authentication with self signed certificates. Our cluster will consist of 3... Continue Reading →

CPU Utilisation and Slow Queries in MongoDB

If we have a  performance issue on MongoDB database, there are a number of things to look at, such as indexing strategies, database schema design issues, abnormal traffic load, network problems, inadequate available physical memory resources, locking problems, inappropriate access strategies, hardware limitations, and the number of open database connections. An obvious place to start... Continue Reading →

Deploying PostgreSQL on a Docker Container

PostgreSQL, often simply "Postgres", is an object-relational database management system (ORDBMS) with an emphasis on extensible and standards-compliance. As a database server, its primary function is to store data, securely and supporting best practices, and retrieve it later, as requested by other software applications, be it those on the same computer or those running on... Continue Reading →

Powered by WordPress.com.

Up ↑