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…
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…
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…
How can I repair corrupt MySQL tables?
How can I repair corrupt MySQL tables? Every so often, MySQL tables have a way of corrupting themselves. MySQL offers…