LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software > Linux - Kernel
User Name
Password
Linux - Kernel This forum is for all discussion relating to the Linux kernel.

Notices


Reply
  Search this Thread
Old 11-04-2009, 01:55 PM   #1
xmagicxxx
LQ Newbie
 
Registered: Mar 2007
Posts: 13

Rep: Reputation: 0
Mysql server crashed without error.


Hi,

I had a set of servers crash yesterday and they have asterisk installed on them one serving as a back bone and the other as a standby both are running cent os
One was crashed showing kernel panic and both one's mysql server crashed without giving error, so far i managed to recover most tables in to the database

I checked /var/log/messages as well as mysql logs.but didnt found anything in it.

Request every one to please help me with what we should actually have done in this scenario and how to safeguard against these in the future.

Both these servers were running with a total of 15 people logged in at the time for calls and mysql database is continuously accessed for the calling data such as phone number & addresses. both are dual core machines with 2 gigs of memory each

Thank you
 
Old 11-04-2009, 06:05 PM   #2
chiragrk
Member
 
Registered: Nov 2009
Location: India
Distribution: Xandros, Ubuntu
Posts: 74

Rep: Reputation: 16
MySQL has a feature called database replication which you can use to replicate your data on another hardware/machine. This way you wont rely totally on backups or your current machine. You can reduce the MTTR.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Server Crashed with Bus error sahil.jammu Linux - Server 1 05-04-2009 03:52 AM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Software 3 06-28-2007 11:46 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software > Linux - Kernel

All times are GMT -5. The time now is 05:57 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration