LinuxQuestions.org
Support LQ: Use code LQCO20 and save 20% on CrossOver Office
Go Back   LinuxQuestions.org > Forums > Linux > Linux - Software > Linux - Kernel
User Name
Password
Linux - Kernel This forum is for all discussion relating to the Linux kernel.

Notices

Reply
 
Thread Tools
Old 11-04-2009, 02:55 PM   #1
xmagicxxx
LQ Newbie
 
Registered: Mar 2007
Posts: 9
Thanked: 0
Mysql server crashed without error.


[Log in to get rid of this advertisement]
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
linuxfedora xmagicxxx is offline     Reply With Quote
Old 11-04-2009, 07:05 PM   #2
chiragrk
Member
 
Registered: Nov 2009
Location: India
Distribution: Xandros, Ubuntu
Posts: 60
Thanked: 2
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.
windows_98_nt_2000 chiragrk is offline     Reply With Quote

Reply

Bookmarks


Thread Tools

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 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:28 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
RSS2  LQ Podcast
RSS2  LQ Radio
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: @linuxquestions
Open Source Consulting | Domain Registration