Find the answer to your Linux question:
Results 1 to 3 of 3
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    flw
    flw is offline
    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\"

  2. #2
    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.

  3. #3
    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

Posting Permissions

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