Server – VPS – Web Hosting Info
MySQL
Linux Server Type: Restoring MySQL SimLink.
Feb 16th
If you’re unable to restart mysqld and troubleshooting the cause: if u log into SSH and go to /tmp you may see that there is no simlink
To create a simlink you can do the following:
cd /var/lib/mysql/
touch mysql.sock
chmod 1777 mysql.sock
chown mysql.mysql mysql.sock
Create a symlink for the sock file :-
ln -s /var/lib/mysql/mysql.sock /tmp
Restart mysql :- service mysql restart
Then your MySQL service should be back to normal.
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).
More >
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.
