MySQL is the most popular open-source relational database management system which is supported by a huge and active community of open source developers. It is available on over 20 platforms…
Category
Databases
-
-
PostgreSQL or Postgres is an open-source general-purpose object-relational database management system with many advanced features that allows you to build fault-tolerant environments or complex applications. In this guide, we will…
-
MariaDB is an open-source relational database management system, backward compatible, binary drop-in replacement of MySQL. In addition, it is developed by some of the original developers of MySQL and by…
-
MariaDB is an open-source relational database management system, backward compatible, binary drop-in replacement of MySQL. In addition, it is developed by some of the original developers of MySQL and by…
-
Centos/RedhatDatabasesLinux
How to Install and Use PostgreSQL on CentOS 8
by Lotfi Waderni May 2, 2020PostgreSQL is a powerful, open source object-relational database system ( ORDBMS ). Unlike other relational database systems, PostgreSQL allows users to create unique operators, complex data types, aggregate functions, data…
-
Centos/RedhatDatabasesLinuxUbuntu
How to enable the slow query log in MySQL/ MariaDB Server
by Lotfi Waderni April 9, 2019When you are troubleshooting, and you want to determine which database queries take a long time to run, slow queries can affect database performance and overall server performance. The slow…
-
DatabasesLinuxUbuntu
How to install MariaDB 10 Server on Ubuntu 18.04 LTS
by Lotfi Waderni January 20, 2019MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB is designed as a drop-in replacement of MySQL(R) with more…
-
Centos/RedhatDatabasesLinux
How To Reset MySQL or MariaDB Root Password On CentOS 7 / RHEL 7
by Lotfi Waderni January 15, 2019In this tutorial we will cover how to reset the root password of MySQL and MariaDB on CentOS 7 / RHEL 7 Step 1 – Checking the version of Database…
-
Centos/RedhatDatabasesLinux
How To install PostgreSQL 11 on CentOS 7 / RHEL 7
by Lotfi Waderni January 9, 2019What is PostgreSQL? PostgreSQL is a powerful, open source object-relational database system ( ORDBMS ). Unlike other relational database systems, PostgreSQL (Postgres) allows users to create unique operators, complex data…
-
DatabasesLinuxUbuntu
How To Install PostgreSQL 11 on Ubuntu 18.04 LTS / 16.04 LTS
by Lotfi Waderni January 7, 2019What is PostgreSQL? PostgreSQL is a powerful, open source object-relational database system ( ORDBMS ). Unlike other relational database systems, PostgreSQL (Postgres) allows users to create unique operators, complex data…