LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
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
 
LinkBack Search this Thread
Old 11-04-2009, 02: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, 07:05 PM   #2
chiragrk
Member
 
Registered: Nov 2009
Location: India
Distribution: Xandros, Ubuntu
Posts: 72

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


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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


All times are GMT -5. The time now is 03:18 PM.

Main Menu
 
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
identi.ca: @linuxquestions
Facebook: @linuxquestions
Open Source Consulting | Domain Registration