Should you use open-source databases?
You are not the only one asking this seemingly popular question! Several companies are torn between the rise in appeal…
Scaling MySQL with TCP Load Balancing and Galera Cluster
[Editor – Originally published in 2016, this post has been updated to use NGINX features that have been revised since then.…
Ubuntu in the wild – 22nd of June
The Ubuntu in the wild blog post ropes in the latest highlights about Ubuntu and Canonical around the world on…
How MariaDB achieves global scale with Xpand
distributed SQL. In a distributed SQL implementation, the database is distributed across multiple physical systems, delivering transactions at a globally…
New Course: Complete SQL Mastery
May 7th, 2019 Comments New Course: Complete SQL Mastery Hi guys, I’m super excited to announce that my Complete SQL…
Monitoring MySQL with NGINX Amplify
table.nginx-blog, table.nginx-blog th, table.nginx-blog td { border: 2px solid black; border-collapse: collapse; } table.nginx-blog { width: 100%; } table.nginx-blog th…
12 MySQL/MariaDB Security Best Practices for Linux
MySQL is the world’s most popular open source database system and MariaDB (a fork of MySQL) is the world’s fastest…
Advanced MySQL Load Balancing with NGINX Plus
In this article, we explain how to use some of the advanced features in NGINX Plus and NGINX Open Source to…
cPanel Server : Restoring MySQL SimLink.
If you’re unable to restart mysqld and troubleshooting the cause: if u log into SSH and go to /tmp you…
Turbo charging MySQL by setting up the query cache
To make sure MySQL uses the query cache, there are a few variables you need to set in the configuration…
Moving mySQL DBs between servers
Moving mySQL DBs from one server to another: mysqldump -uUSER -pPASSWORD txp_database > txp_database.sql puts the entire thing in one…
Taking backup of mysql database using cron
Taking backup of mysql database using cron Create a file called database_backup.sh and also an empty directory called mysql_backup. The…