Close

Linux Processes – Setting process priorities by setting nice values on CentOS/RHEL 7

Changing a process’s priority is a good way to make your machine run more efficiently. Changing process priorities is to do with increasing/decreasing how much CPU time a process can have while the machine is running. For example if you are setting up a machine to primarily run as a web server, then it is a good idea to elevate the web-server related processes so that they get more access to the CPU.

Read More

MariaDB – Restoring databases

In the previous article we saw how to create backups of our database. Now we’re going to try restoring databases. First thing we need to do is delete our database so that we can start restoring it: We created a backup file for online_shop, so let’s start by deleting that database, this is done using […]

Read More

MariaDB – Backing up databases

There are 3 levels of mysql database backups you can do: Backup the contents of a single database Backup multiple databases Backup the entire mysql server when creating database backups, the resulting backup files are actrually really big sql files that will repopulate a database. In all cases we create database backups using the mysqldump […]

Read More

MariaDB – Basic MySQL CRUD Operations

In the previous article we saw how to create a new database called ‘online_shop’ and then a table inside this new database called ‘customers’. Now we’re going to show how to create/read/update/delete (crud) content in a table. Let’s see what the situation is: [root@mariadb-client ~]# mysql -u root -p’rootpassword’ -h mariadb-server.example.com Welcome to the MariaDB […]

Read More