MySQL is one of the most popular open-source RDBMS (Relational Database Management Systems). It is an integral part of the rapidly growing LAMP Stack and has gained impressive fandom among developers and system admins. Compared to non-relational databases, SQL provides excellent functionalities to arrange, store, and manage data effectively. The distinguishing table arrangement functionalities and stand-out capabilities of the SQL …
Installing MariaDB on CentOS 7
In the world of database engines, MySQL and MariaDB are two of the major players. MariaDB is practically MySQL with some key changes. It’s a community-developed fork of MySQL backed by commercial support, for example, Wikipedia, Google, WordPress.com, etc. MariaDB is free and open-source and guaranteed to stay so. In this guide, we will guide you through the steps of …
SQLite vs MySQL vs. PostgreSQL: Relational Database Management Systems Compared
Introduction Database management tools are mostly used by the relational data model. This model organizes data into tables consisting of columns and rows. While this model remains dominant in terms of storing and managing worldwide data, there are other data models such as NoSQL and NewSQL out there. In this tutorial we will delve into three of the most widely …
MySQL User – Create and Grant Permissions
In this CloudSigma tutorial, you will learn how to create a MySQL user, grant various permissions and privileges, and delete it. MySQL is an open-source Relational Database Management System (RDBMS) that helps users to store, organize, and manage the data. It is very popular and widely used in the IT industry. Learn how to setup MySQL on a server, and …
How to setup MySQL on a server and MySQL basics
In this CloudSigma tutorial, you will learn how to setup MySQL on a server, and the MySQL basics. MySQL is an open-source Relational Database Management System (RDBMS) that helps users store, organize, and manage data. It is very popular and widely used in the IT industry. Creating the machine First, you have to create a machine. You can do that …
Data characteristics to be considered for cloud servers
=Understanding data characteristics and the requirements for each characteristic is essential in choosing the right cloud storage strategy and deployment model. This post will help you understand how to best define your data characteristics and requirements as a starting point to implementing a successful data strategy. Let’s have a look at those characteristics and requirements. Data Characteristics 1. Performance …