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 →

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 →

Powered by WordPress.com.

Up ↑