Printable View
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.
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.
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