Welcome to Linux Forums!

With a comprehensive Linux Forum, information on various types of Linux software and many Linux Reviews articles, we have all the knowledge you need a click away, or accessible via our knowledgeable members.

Linux Forum ArticlesLinux ForumsLinux Forum DownloadsLinux HostsFree MagazinesJobs
Home|Register|FAQ|Member List|Calendar|Unanswered Posts|Forum Rules|Today's Posts|Advanced Search|
SEARCH FOR IN
Go Back   Linux Forums > GNU Linux Zone > Servers
Reload this Page mysql and stabiltiy
Linux Forums
Linux Forums
Welcome To The Linux Forums!
Welcome to Linux Forums. We pride ourselves in being one of the largest Linux communities on the web, we encourage you to REGISTER on our forums and participate in the community. There are over 150,000 members ready to answer your questions. JOINING US today will allow you to make new posts, get support, send messages to other members and submit downloads to our downloads directory and many other great features!

Servers Anything server related, Apache, MySQL, Samba, server security, sendmail, exim, etc

Reply
 
Thread Tools Display Modes
Old 07-12-2003   #1 (permalink)
flw
Linux Engineer
 
Join Date: Mar 2003
Location: U.S.A.
Posts: 1,025
mysql and stabiltiy

I every once in a while, I have to take linux servers down, hard-pull the power cord (lousy app out of control) and have never (not yet) had a problem with the OS comming backup and run services fine.

Generically, if mysql is running with one or more open databases would it also be a resilent as Linux is?

I ask because lack of stablity and database corruption is a long trait of MS SQL.
__________________
Dan

\"Keep your friends close and your enemies even closer\" from The Art of War by Sun Tzu\"
flw is offline   Reply With Quote
Old 08-08-2003   #2 (permalink)
Just Joined!
 
Join Date: Apr 2003
Location: Australia & England
Posts: 75
Your data could become corrupted if you do such a thing ( I can't believe you pull the cord out!) which there are users connected to the database.
Even if there are apps out of control, surely you can ssh to the machine and stop the process?
If you can't stop that process for whatever reason, you could surely shutdown any big services that you have running such as mysql.
I guess this doesn't really answer your question in detail though.
__________________
LRU 309633
Slackware 9.1
ventricle is offline   Reply With Quote
Old 08-08-2003   #3 (permalink)
Linux Guru
 
Join Date: Apr 2003
Location: London, UK
Posts: 3,284
It is possible that you could screw the entire database. you MUST stop the mysql process correctly with "mysqladmin shutdown", obviously inluding any params like hostname, username etc.

Jason
jasonlambert is offline   Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

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

Free Magazines
Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe
Systems Management News, the newspaper for IT systems administration and data center managers!
Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe
The Enterprise Newsweekly
eWeek is the essential technology information source for builders of e-business.
subscribe
Oracle Magazine
Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe
Total Telecom
Total Telecom is "The Economist of the communications industry".
subscribe
More free magazines »



All times are GMT. The time now is 11:11 PM.




© 2000 - 2008 - All Rights Reserved - Property of  MAS Media

Content Relevant URLs by vBSEO 3.2.0