Teddy A Jasin wrote:
>
> Hi All,
>
> Currently I have four websites using one MySQL server. The MySQL and the four
>websites
> each is placed on different server.
> However this MySQL server, I dont know why after running for a few days can
> stop responding that I have to restart the MySQL server.
> This caused my four websites also down.
>
> Now, how do I create the MySQL server such that I have 2 MySQL server running on the
> same server that if the main MySQL server is down, the other will be up and running.
>Of course
> that the other server must have the same databases.
>
> For your info, currently we have over 100MB of databases on the server running on
>Linux Redhat 6.2.
> A typical visit at one time on the website will be 2000 over (one hour).
>
> Thanks
> Teddy
RedHat 6.2 will erase your mysql.sock file if you put it in /tmp.
The culprit is /etc/cron.daily/tmpwatch.
It cleans /tmp and /var/tmp.
Either disable this command, or have mysql put the socket somewhere
else.
I put mine in /usr/local/tmp.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php