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... Continue Reading →

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... Continue Reading →

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... Continue Reading →

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.... Continue Reading →

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... Continue Reading →

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

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 ↑