DevOps

How to create a user in MySQL/MariaDB and grant permissions on a specific database

2 comments

Logos de MariaDB y MySQLCreating a user in MySQL or MariaDB and granting permissions to him to access a specific database and be able to write data on it is a very usual task that is necessary to perform each time you install a new application based on any of these database engines, like web applications running on top of LAMP stack. Whether it is a simple WordPress, or a more complex application tailor made, one way or another you will always have to complete these steps at some point before its deployment.

DanielHow to create a user in MySQL/MariaDB and grant permissions on a specific database

How to enlarge the size of an EBS volume in AWS and extend an ext4 partition

No comments

Logo AWS EBSWhen we completely fill up an ext4 filesystem mounted on a partition hosted in an EBS volume of Amazon Web Services and we can not do anything to free space because we do not want to lose any of the stored data, the only solution is to grow up the volume and extend the associated partition up to 100% of its capacity to obtain free space again.

DanielHow to enlarge the size of an EBS volume in AWS and extend an ext4 partition

Differences between physical CPU vs logical CPU vs Core vs Thread vs Socket

2 comments

When we try to know a computer’s architecture and performance at CPU level using Linux commands like nproc or lscpu, we often find out that we are not able to properly interpret their results because we confuse terms such as physical CPU, logical CPU, virtual CPU, core, thread, socket, etc. If we add concepts like HyperThreading (not to be confused with multithreading), we are in a situation where we can not be sure how many cores our box has, we don’t understand why commands like htop indicate that we have 8 cpus when we thought we had bought a single quad-core processor, etc. In short, it’s a mess.

DanielDifferences between physical CPU vs logical CPU vs Core vs Thread vs Socket