How To Install phpPgAdmin On Ubuntu 20.04

how to install phppgadmin on ubuntu 20.04

PostgreSQL is one of many powerful and famous object-relational database systems. It is a free and open-source database management system. Usually, people manage their PostgreSQL databases through a command-line interface, which might give some difficulties to novice users.

install phppgadmin on ubuntu 20.04

PhpPgAdmin is an open-source web administration interface for PostgreSQL written in PHP. It is used to manage PostgreSQL databases through a web interface.

In this tutorial, we will show you how to install PhpPgAdmin on an Ubuntu 20.04 VPS.

Read more

MariaDB Galera Cluster Replication

MariaDB Galera Cluster Replication

MariaDB Galera Cluster is a database clustering solution that lets you set up a virtually synchronous multi-primary cluster for the MariaDB database. Clustering is a technology that provides high availability to your database by distributing the changes among multiple database nodes. If one of the database nodes fails others are quickly available to continue serving.

Read more

MongoDB Replica Set with Master-Slave Replication and Automated Failover

A replica set is a group of MongoDB database nodes used for defining database clusters with master-slave replication and automated failover. A replica set contains a single primary node, multiple secondary nodes, and an arbiter node. The primary node receives all write operations while other nodes apply operations from the primary so that all nodes have the same data set.

Read more

MySQL SHOW USERS: List All Users in a MySQL Database

list MySQL users

Today we are going to guide you on how to show all users in the MySQL users Database.

A common question that most beginner MySQL users ask is “How do I see all of the users in my MySQL server?” Most of them assume that there is a show users command in MySQL, but there isn’t one. This is a common mistake because there are other MySQL commands for displaying information about the database. For example, SHOW DATABASES will show us all of the databases that are present in our MySQL Server, and SHOW TABLES will show us all the tables in the MySQL database that you have selected.

It’s not unusual for people to assume that there should be a SHOW USERS command in MySQL. Even though there isn’t a specific command for it, there are several ways to actually see the list of users and even filter them to see exactly what you need. This can all be done with the MySQL command line tool – let’s get started.

Read more

How to Fix WordPress Error Missing MySQL Extension Problem

your php installation appears to be missing the mysql extension

If you have received the “Your PHP installation appears to be missing the MySQL extension which Is required by WordPress” error, then this tutorial will be able to help you fix that. This error is triggered when the PHP code in your site is not compatible with the version of PHP your WordPress site is currently using.

More specifically, this problem is related to the outdated MySQL extension which was removed as of PHP 7.0. In this tutorial, we will help you fix the problem with the PHP missing MySQL extension error, and help you complete the WordPress installation successfully.

Read more

MariaDB/MySQL Auto-Сlustering with Load Balancing and Replication for High Availability and Performance

mariadb/mysql auto-сlustering with load balancing and replication for high availability and performance

These days high availability and database clustering are very important for highly loaded production applications. If your server is down for a fraction of time, you are losing customers and money. Therefore making a database environment highly available has typically one of the highest priorities. Set up a highly available cluster is not easier for any developers and system administrators.

Read more

How to Install MongoDB on Ubuntu 20.04 and CentOS 8

how to install mongodb on ubuntu 20.04 and centos 8
installing mongodb on ubuntu 20.04 and centos 8

MongoDB is an open-source and cross-platform NoSQL database system developed by MongoDB Inc. It is 100 times faster than a traditional database system like RDMS. It uses JSON-like documents to store its data. It is used in many modern web applications because it can be easily integrated with several programming languages. It is used by many big companies including, Uber, Stack, Lyft, Accenture, and many more.

Read more

How to Install CouchDB on Ubuntu 20.04

How to install couchdb on ubuntu 20.04
install couchdb on ubuntu 20.04

In this short tutorial, we will explain how to install CouchDB on Ubuntu 20.04. CouchDB is a free and open-source document-oriented NoSQL database written in Erlang. It allows you to run a single logical database server on any number of servers or VPSes. You can use CouchDB as a single node or clustered database. It stores and collects data in JSON-based document formats. If you are looking for high-performance NoSQL database systems then CouchDB is the best choice for you. Installing CouchDB on Ubuntu 20.04 should take less than 10 minutes.

Read more

How to Install Apache Cassandra on CentOS 8

installing apache cassandra on centos 8

Apache Cassandra is an open-source NoSQL database system designed to handle a large amount of data. It supports clusters spanning multiple data centers and high availability with no single point of failure. It offers a lot of features including, Highly Scalable, Distributed, Replication Support, Fault-tolerant, MapReduce support, Query language, and many more. If you are looking for scalability and high availability without compromising performance then Apache Cassandra is the best choice for you.

In this tutorial, we will show you how to install Apache Cassandra on CentOS 8.

Read more

How to Install phpMyAdmin on CentOS 8

This tutorial explains the process of installing one of the most popular open-source applications for managing MySQL databases – phpMyAdmin. phpMyAdmin is a free and open-source web-based application written in PHP, used to easily manage MySQL databases through your favorite web browser instead of needing to use the MySQL command line interface.

PhpMyAdmin allows users to create, modify, rename, and delete databases, tables, or fields, execute SQL commands through the browser, import and export tables to a wide range of formats, create users and modify their privileges, and much more… Thanks to this tool, we will almost never need to use the MySQL command line again. We are going to install phpMyAdmin on a CentOS 8 VPS with Apache, MariaDB, and of course, PHP. Let’s begin.

Read more