Find the answer to your Linux question:
Results 1 to 3 of 3
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Engineer
    Join Date
    Mar 2003

    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.

    \"Keep your friends close and your enemies even closer\" from The Art of War by Sun Tzu\"

  2. #2
    Just Joined!
    Join Date
    Apr 2003
    Australia & England
    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.

  3. #3
    Linux Guru
    Join Date
    Apr 2003
    London, UK
    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.


  4. $spacer_open

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts