Set Up PostgreSQL, pgAdmin on Windows 10
Muhammad Anwar
December 04, 2020
PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compli...
Results for
database
Install PostgreSQL 13 on CentOS, RHEL 7, 8
Muhammad Anwar
December 03, 2020
This guide will walk you through the steps to install PostgreSQL release 13 on a CentOS 7 or 8. These instructions can also be applied if yo...
Install pldebugger for PostgreSQL on Ubuntu 18/19/20.04
Muhammad Anwar
October 02, 2020
The debugger may be used to debug PL/pgSQL functions in PostgreSQL, as well as EDB-SPL functions, stored procedures and packages in EDB Post...
MySQL, MariaDB Backup and Restore Step by Step
Muhammad Anwar
March 29, 2020
MySQL and MariaDB include a built-in backup utility that simplifies the process to create a backup of a database. With mysqldump , you can...
PostgreSQL Backup and Restore Step by Step
Muhammad Anwar
March 29, 2020
If you are using PostgreSQL in a production environment, it is recommended to frequently take backups to ensure that your important data is...
Secure Your MongoDB Databases
Muhammad Anwar
March 04, 2020
This tutorial will show you how to install and secure MongoDB on an Ubuntu or Debian. This guide will also explain on some basic features an...
Set Up a Highly Available MySQL Replication Cluster on Ubuntu, Debian
Muhammad Anwar
March 02, 2020
Database clustering is particularly useful for highly active website and application. With replication, at least two or more MySQL servers ...
Set Up Highly Available MongoDB Sharded Cluster on Ubuntu
Muhammad Anwar
February 17, 2020
This tutorial will show you how to set up a fault-tolerant MongoDB sharded cluster on a Ubuntu or Debian. For instance, if you would like t...
Set Up a Multi-node Oracle (RAC 18c) on CentOS/RHEL 7
Muhammad Anwar
January 27, 2020
This tutorial will walk you through the steps to set up a multi-node oracle real application cluster using (grid 18c and database 18c) on ...
Install PhpMyAdmin with Apache on CentOS, RHEL 8
Muhammad Anwar
December 31, 2019
phpMyAdmin allows you to administer and manage your MySQL/MariaDB database using the web interface. This tutorial will walk you through the...
An Introduction to Database Sharding
Muhammad Anwar
February 11, 2019
Sharding has been receiving lots of attention in recent years, but many don't have a clear understanding of what it is or the scenarios...
How To Set Up Memcached on Ubuntu 18.04
Muhammad Anwar
January 07, 2019
Memory object caching systems like Memcached can optimize back-end database performance by temporarily storing information in memory, retai...
How To Set Up PostgreSQL Logical Replication on Ubuntu 18.04
Muhammad Anwar
September 03, 2018
This guide will show you how to set up two-nodes logical replication with PostgreSQL on Ubuntu 18.04. One server will act as the master an...
How to Set Up a Multi-Node MySQL High Availability Cluster on Ubuntu 18.04
Muhammad Anwar
August 27, 2018
The MySQL Cluster distributed database provides high availability and throughput for your MySQL database management system. A MySQL Cluster...
How To Set Up Redis on Ubuntu 18.04
Muhammad Anwar
July 04, 2018
Redis is an in-memory key-value store known for its flexibility, performance, and broad language support. It is commonly used as a database,...
How To Install and Secure MySQL on Ubuntu 18.04
Muhammad Anwar
May 07, 2018
MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) ...
How To Set Up PostgreSQL on Ubuntu 18.04
Muhammad Anwar
May 07, 2018
PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a p...
How To Install Apache CouchDB on CentOS 7 Server
Muhammad Anwar
December 04, 2017
Apache CouchDB is an open source, document-oriented NoSQL database software that's focused on scalable architecture. Each database is...
How To Install Linux, Apache, MySQL, PHP (LAMP) Stack on Ubuntu 17.10
Muhammad Anwar
November 23, 2017
This tutorial will walk you through the steps to set up a LAMP on an Ubuntu 17.10. LAMP Stack is a group of open source software that is...
How To Install Nginx, MariaDB and PHP (FEMP Stack) on FreeBSD 11
Muhammad Anwar
October 29, 2017
This step by step guide will walk you through the steps to install and configure the FEMP Stack on FreeBSD 11.
Subscribe to:
Posts
(
Atom
)