Relational Database Management Systems Compared featured image

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 …

Server Setup

Setting up Your Application: How to Choose the Best Server Setup?

Introduction Technology and the internet have become central presences in our regular, academic, and professional lives. That is why the sheer number of websites and applications that exist concurrently does not come as a surprise. If you are a business, you would want to have an associated web platform. An application enables you to market and deliver your services to …

MySQL basics

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 …

MySQL basics

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 …

How to use vnStat and iftop

How to use vnStat and iftop to monitor data consumption within a VM

In the generation of cloud computing, virtual machines (VMs) have become very common, while the usage of physical machines has started to gradually decrease. In this post, we will introduce the tools, ‘vnStat’ and ‘iftop,’ which we can use to monitor data consumption in a VM. First, I am creating a machine with the following resources: 20 GHz CPU 16 …

Measuring VM Traffic on CloudSigma

How to measure the traffic on your VM with the CloudSigma API and RRDtool

Learn how to measure the traffic of your virtual machines in CloudSigma using the simple instructions below, to obtain, store and graph the traffic from our different network interfaces. To obtain the statistics of each interface we can make use of the CloudSigma API and a simple script that will store the data of each network interface. The database we …