database Archives - RoseHosting

10 Useful mysqladmin Commands for Database Administration

December 28, 2022November 14, 2022 by Jeff Wilson

In this blog post, we will show you ten useful mysqladmin commands for database administration.

Mysqladmin is a client for performing administrative operations. We can use this for checking the server’s configuration, creating and removing databases, users, tables, rows, and many more in MySQL. MySQL is a relational database management system used worldwide where the information is stored in tables. There are many database types offered by MySQL such as int, bigint, float,tinyint, smallint, mediumint and many more.

In this tutorial, first, we will install MySQL on the latest Ubuntu 22.04, then show you the mysqladmin commands. Let’s get started!

How to Install MySQL Database on Ubuntu 20.04

June 3, 2022November 29, 2021 by Jeff Wilson

MySQL is an open-source relational database management system (RDBMS), it’s widely used and part of the popular LAMP/LEMP stacks. The data is organized in one or more tables in which the data types may be related to each other and MySQL uses SQL Structured Query Language to manage its data.

installing mysql database on ubuntu 20.04

Considering its part of the LAMP/LEMP stack it is used by many database-driven web applications such as WordPress, Magento, Drupal, and Joomla.
Today we will install MySQL on our server and create a database and user with chosen permissions on this database, let’s get started!

Access Your Database Remotely Through an SSH Tunnel

June 3, 2022August 18, 2021 by Jeff Wilson

Secure Shell or SSH is a client-server-based communication protocol that is used to connect securely from one machine to another. It uses a network port to create a connection session between the server that listens on the chosen port and the client which sends the SSH connection request on that port.

With this protocol, we can manage our servers and work on them remotely. For example, we can add/edit/delete the services running on the server using an SSH client like PuTTY or Terminal.

MariaDB Galera Cluster Replication

March 6, 2024July 2, 2021 by Jeff Wilson

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.

MongoDB Replica Set with Master-Slave Replication and Automated Failover

March 6, 2024April 28, 2021 by Jeff Wilson

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.

How to Install CouchDB on Ubuntu 20.04

June 3, 2022January 11, 2021 by Jeff Wilson

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.

How to Install Apache Cassandra on CentOS 8

June 3, 2022January 6, 2021 by Jeff Wilson

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.

How to Install MongoDB on Ubuntu 16.04

December 9, 2022July 13, 2017 by Jeff Wilson

Today we are going to discuss how to install MongoDB on Ubuntu 16.04. MongoDB is a free and open source document-oriented NoSQL and cross-platform database server. It is a high-performance database program, used by one of the biggest companies in the world like Google, Adobe, SAP, EA, eBay, Verizon. The process of Installing MongoDB on Ubuntu 16.04 should take approximately 10 minutes. In this tutorial, we will install the MongoDB community version. Let’s get started.