MySQL InnoDB Cluster – A Hands on Tutorial

MySQL InnoDB cluster provides a complete high availability solution for MySQL.Each MySQL server instance runs MySQL Group Replication, which provides the mechanism to replicate data within InnoDB clusters, with built-in failover. This work instruction details the steps to setting up a cluster MySQL InnoDB, how to manage IT and the recovering procedure in case of...

Install MySQL 8.0 in Linux and Windows

MySQL community server is a free open source, popular and cross-platform database management system. It supports both SQL and NoSQL, and has a pluggable storage engine architecture. Additionally, it also comes with multiple database connectors for different programming languages, allowing you to develop applications using any of the well known languages, and many other features. MySQL Server is intended...

MongoDB in the Cloud with Atlas

MongoDB Atlas provides an easy way to host and manage your data in the cloud. MongoDB Atlas provides all of the features of MongoDB,without the operational heavy lifting required for any new application. MongoDB Atlas is available on-demand through a pay-as-you-go model and billed on an hourly basis, letting you focus on what you do...

MongoDB Ops Manager

MongoDB Ops Manager is a service for managing, monitoring and backing up a MongoDB infrastructure. In addition, Ops Manager allows Administrators to maintain a server pool to facilitate the deployment of MongoDB. Ops Manager provides the services described below. Monitoring Ops Manager Monitoring provides real-time reporting, visualization, and alerting on key database and hardware indicators....

Upgrade from MySQL 5.7 to MySQL 8.0

MySQL server's can be upgraded by performing either an INPLACE upgrade or LOGICAL upgrade. The Inplace upgrade involves shutting down the MySQL 5.7 server, replacing the old binaries with MySQL 8.0 binaries and then starting the MySQL 8.0 server on the old data directory. The Logical upgrade involves exporting SQL from the MySQL 5.7 version...

MongoDB Database Administration Commands

This article lists the  commands used for MongoDB administration.Please feel free to suggest and contribute more commands. Login to mongodb instance # mongo -u <username> -p <password> --authenticationDatabase <dbname> Authenticate and logout  from database use admin;  db.auth('user','password'); // Logout db.logout() Show all databases show dbs Define a database name use <databasename> This command is to...

Setting up MySQL Master- Master 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...

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...

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...

Create Hot Backups of MySQL Databases with Percona XtraBackup

Introduction Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits:  Backups that complete quickly and reliably  Uninterrupted transaction processing during backups  Savings on disk space and network bandwidth  Automatic backup verification Higher uptime due to faster restore time Percona XtraBackup makes MySQL hot backups for...