Database Archive
15 Apr 2019
How to Install Oracle Database 12c Release 2 in Linux 7
Oracle Database is an object-relational database management system (RDBMS) developed by Oracle Corporation. The Oracle Database 12c is a high-performance, enterprise-class database. Oracle Database is the most popular, trusted database systems. Oracle Database support multiple operating systems
12 Apr 2019
Install MySQL Password Validation Plugin on Linux
When thinking about security within a MySQL installation is protecting MySQL data. MySQL provides many tools and plugins in order to protect your data. Now MySQL version 5.6.4 comes with a new security plugin called Password Validation
18 Mar 2019
How to Change MySQL Password Policy Level on Linux
MySQL version 5.6.6 comes with a new security plugin called Password Validation Plugin. The validate_password plugin test password strength and improve security. Sometimes while changing the password you got the error “ERROR 1819 (HY000): Your password does
11 Jul 2017
For “Too Many Connections” Error in MySQL
By Anuket Jain On 11 July 2017 In Database
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
By Anuket Jain On 30 June 2017 In Database
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
By Anuket Jain On 5 October 2015 In Database
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
By Anuket Jain On 18 September 2015 In Database
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
By Anuket Jain On 9 August 2015 In Database
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
By Anuket Jain On 22 May 2015 In Database
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
By Anuket Jain On 24 April 2015 In Database
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
- 1
- 2