PEP PLA
Freelance MySQL and PostgreSQL consultant
Who am I
Pep has worked with databases all his life. Born in a small town by the Mediterranean, he currently lives in Barcelona. He is passionate about technology, travel, good food, music and everything related to NASA. He hates talking about himself in the third person and has a particular sense of humor. Happily married, he is the father of three children and three cats.
Articles
Raspberry on the Rocks: Build Percona Server for MySQL With MyRocks on Your Raspberry Pi
Raspberry PI is a small single-board computer (SBCs) developed by the Raspberry Pi Foundation in association with Broadcom. This tiny computer is extremely popular and widely used in many areas. Thanks to its size, low cost, and low energy requirements, it can be used to collect data in remote locations or from sensor devices. We often need to be able to store large amounts of data efficiently on these devices.
The Impacts of Fragmentation in MySQL
Fragmentation is a common concern in some database systems. Highly fragmented tables can affect performance and resource allocation. But reducing fragmentation often involves rebuilding the table completely. This blog post will discuss fragmentation and its impact on InnoDB.
How to use procedures to increase security in MySQL
MySQL privilege system is small, almost all administrative tasks can be completed using a handful of privileges. If we exclude generic ones as ALL, SHOW DATABASES and USAGE, create and drop permissions as CREATE USER, DROP ROLE or CREATE TABLESPACE, the number of privileges remaining is really limited: PROCESS, PROXY, RELOAD, REPLICATION_CLIENT, REPLICATION_SLAVE, SHUTDOWN and SUPER.
The night of the living files
Scary movies for teenagers and database administration tasks share some common traits. Usually, the movie starts with a group of teens making unwise choices. Maybe you, as a DBA, are no longer a teenager, but you shouldn't underestimate your ability to do the same.
