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.…
On DBs
[Editor – Originally published in 2016, this post has been updated to use NGINX features that have been revised since then.…
The Ubuntu in the wild blog post ropes in the latest highlights about Ubuntu and Canonical around the world on…
distributed SQL. In a distributed SQL implementation, the database is distributed across multiple physical systems, delivering transactions at a globally…
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…
MySQL is the world’s most popular open source database system and MariaDB (a fork of MySQL) is the world’s fastest…
If you’re unable to restart mysqld and troubleshooting the cause: if u log into SSH and go to /tmp you…
To make sure MySQL uses the query cache, there are a few variables you need to set in the configuration…
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 Create a file called database_backup.sh and also an empty directory called mysql_backup. The…
How can I repair corrupt MySQL tables? Every so often, MySQL tables have a way of corrupting themselves. MySQL offers…