Month: September 2023

Script to Install MariaDB 10.5 on Debian 11 with Boot Disk + Data Disk

by

Note: besure to replace /dev/sdb with the correct location of the data disk. sudo apt update sudo apt install dosfstools sudo mkfs -t ext4 /dev/sdb sudo mount /dev/sdb /mnt/mariadb-data sudo apt install mariadb-server sudo systemctl stop mariadb sudo cp -R -p /var/lib/mysql/* /mnt/mariadb-data sudo cp /etc/mysql/mariadb.conf.d/50-server.cnf /etc/mysql/mariadb.conf.d/50-server.cnf.backup sudo sed -i ‘s/\/var\/lib\/mysql/\/mnt\/mariadb-data/g; s/bind-address\s*=\s*127\.0\.0\.1/bind-address = 0.0.0.0/g’ /etc/mysql/mariadb.conf.d/50-server.cnf.backup2 … Read more

GCP Machine Families Compared

by

I work with a client who operates a high-traffic Woocommerce website. Their current setup involves utilizing a SQL-based database system, and recently, there have been instances of noticeable performance slowdowns. After extensive troubleshooting, it became evident that the performance bottleneck was occurring at the database server level. The client had been utilizing Cloud SQL to … Read more

From Novice to Pro: 3 Google Cloud Platform Projects for Starters

by

The cloud industry is fiercely competitive. Every job posting for a cloud role can attract scores of applicants, all vying for that single position. Case in point: I recently advertised a “Junior Cloud Engineer” position on Upwork. To my astonishment, over a hundred candidates applied. Most were exceptionally qualified, making the selection process challenging. However, … Read more