Database Archive

11 Jul 2017

For “Too Many Connections” Error in MySQL

Some times on your server in MySQL there is too many connections issue occurs. To resolve this issue you need to increase the value of max_connections. In this article we will help you how to update max_connections
30 Jun 2017

How to Install MongoDB 3.4 on Ubuntu 16.04/14.04

MongoDB is a NoSQL database that offers a high performance, high availability, and automatic scaling enterprise database. NoSQL refers to a database with a data model other than the tabular format used in relational databases such as
5 Oct 2015

Adminer Tool for CentOS/RHEL & Ubuntu/Debian

Adminer tool is a full-featured database management tool written in PHP. It consist of a single PHP file which is ready to deploy on the target server. Adminer supports MySQL, PostgreSQL, SQLite, SQL Server, and Oracle, and
18 Sep 2015

How to Resize MySQL InnoDB logs file in CentOS/RHEL

Log files are important disk-based resources which is managed by the InnoDB storage engine. MySQL creates two log files named ib_logfile0 and ib_logfile1 in the MySQL data directory. We define the size of log file in innodb_log_file_size
9 Aug 2015

How to configure Master-Slave MySQL Replication on CentOS/RHEL 5/6/7

MySQL replication is a procedure that permits you to easily keep up multiple copies of a MySQL data by having them replicated consequently from an master to a slave database. This can helpful for some reasons including
22 May 2015

How to Install and configure MySQL 5.6 on CentOS

Oracle today declared the general accessibility of MySQL 5.6, the world’s most prevalent open-source database. Optimizer enhancements for all-around query execution. InnoDB enhancements for higher value-based throughput. New NoSQL-style memcached APIs. Partitioning changes for questioning and overseeing
24 Apr 2015

Mysql Commands for CentOS/RHEL

MySQL is a uninhibitedly accessible open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most prevalent dialect for including, getting to and overseeing substance in a database. It is most
12 Apr 2015

Configure Master and Slave database replication using mysqlnd plugin

Mysql replication is a process that allows you to maintain the multiple copy of mysql data. With the help of mysqlnd plugin we can divide the load of mysql. We can send select query to slave server
8 Apr 2015

Reset (Re-Sync) Mysql Master-Slave Replication

Some times we face issue in MySQL replication and slave could not sync. The cause of this issue may have lots of reason. Following Steps help you to start Re-Sync Mysql. Note:-When you Re-Sync MySQL Replication all