Server – VPS – Web Hosting Info
How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1
Apr 18th
This tutorial is based on Falko Timme’s tutorial for MySQL Cluster 5.0. It shows how to configure a MySQL 5.1 cluster with five nodes: 1 x management, 2 x storage nodes and 2 x balancer nodes. This cluster is load-balanced by an Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster).
Read the rest of this entry »
Turbo charging MySQL by setting up the query cache
Mar 27th
To make sure MySQL uses the query cache, there are a few variables you need to set in the configuration file . Usually its my.cnf or my.ini so check on your server with the shell command locate , in our case we are running on a CentOS 5.2 distro and to its my.cnf located in /etc so we opened it by using : nano /etc/my.cnf
Moving mySQL DBs between servers
Mar 27th
Moving mySQL DBs from one server to another:
mysqldump -uUSER -pPASSWORD txp_database > txp_database.sql
puts the entire thing in one nicely portable text file.
on a new server it takes
mysql -uUSER -pPASSWORD txp_database < txp_database.sql
to import it.
Taking backup of mysql database using cron
Mar 27th
Taking backup of mysql database using cron
Create a file called database_backup.sh and also an empty directory called mysql_backup. The database_backup.sh script should have the following info :
How can I repair corrupt MySQL tables?
Sep 12th
How can I repair corrupt MySQL tables?
Every so often, MySQL
tables have a way of corrupting themselves. MySQL offers a quick and
painless method of repairing those tables.
