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 application 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

How to Create a Backup of MySQL Databases Using mysqldump on Ubuntu 20.04

In this tutorial, we will show you how to create a backup of MySQL databases on an Ubuntu 20.04 VPS, and create a backup of the entire /var/lib/mysql directory.

We will create the backup of the databases using MySQL’s command, aptly named mysqldump. After that we will then show you how to perform a backup of the /var/lib/mysql directory where MySQL have been located. Performing regular backups of your database and database server is vital to protecting the data that you have on your server. This way, in case something goes wrong on your Ubuntu 20.04 VPS, or if MySQL breaks for some reason (incompatibilies or otherwise), you’ll have a safe backup that you can revert to and prevent the loss of your precious data.

Once you create a backup of MySQL databases and save them on your server or on a remote location, you can then always be able to restore the databases later from this backup, if needed. Creating a backup of MySQL database is essential for any website owner, and it should be done on a regular basis. Just follow the simple steps in this tutorial and your data will be redundant in no time. Let’s begin.

Read more

How to Install Apache Cassandra on Debian 9

In this tutorial, we will show you how to install Apache Cassandra on a Debian 9 VPS.

Apache Cassandra is a free and open-source distributed NoSQL database management system that provides High-Availability with no single point of failure. Cassandra does not use the table model seen in MySQL, MSSQL or PostgreSQL – rather, it uses a cluster model. It is designed to handle large amounts of data across commodity hardware. It provides linear scalability by adding a new machine to it without any interruption to applications. Apache Cassandra is used by many popular organizations including Apple, NetFlix, eBay, and Easou.

Let’s begin with the installation.

Read more