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.
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.
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.
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.
Today we gonna guide you through 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.
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.
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
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.
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.
In this tutorial we will guide you through the steps of installing WordPress on an Ubuntu 18.04 VPS with all necessary components, such as Apache web server, PHP and MySQL/MariaDB database server, and configure WordPress to use a database on a remote server.
WordPress is the most popular and most widely-used content management system (CMS). It is the CMS of choice for 26% of the entire web. It is based on PHP, and it stores its information in a MySQL database. The large amount of themes and plugins makes this CMS an excellent choice for someone that needs a user-friendly way to get their ideas onto a website that looks good. Let’s get started with the installation.
In this guide, we will explain how to install LAMP on Ubuntu 18.04.
LAMP (Linux, Apache, MySQL, PHP) is a combination of open source software, typically installed on a server used for hosting dynamic websites and web applications. It includes the Linux operating system, the Apache web server, MySQL for data storage and management, and PHP for handling the dynamic content.
Installing LAMP on Ubuntu 18.04 is an easy task and should not take more than 10 minutes. Let’s begin with the installation process.