Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2001
    Posts
    288

    Rebooting server

    What I want to now is, what happens if the server is writing to the database and you decide to reboot? Will the writing stop abruptly or will the the server finish the writing process and then restart the server?
    <<I don't need no stinking rules for signature setup!>>

  2. #2
    I'm not really sure, but I guess it depends what kind of a reboot it is, as in you doing a power cycle from a control panel, or "shutdown -r now" from ssh.

  3. #3
    Join Date
    Jan 2006
    Location
    Jersey
    Posts
    2,971
    Depends on the database you are using.

    Part of the reason servers running MySQL database need UPS is because if there is an abrupt shutdown while something is being written/updated/changed it will get corrupted because MyISAM expects the system to run uninterrupted. And while you can try to retrieve it, sometimes it might be impossible.

    One the other hand, databases such as SQL 2005 will not get corrupted during an abrupt shutdown because it has systems in place to safeguard data from corruption due to abrupt shutdowns.
    Last edited by HNLV; 02-09-2008 at 08:21 AM.
    Email: info ///at/// honelive.com

  4. #4
    Join Date
    Nov 2005
    Location
    Minneapolis, MN
    Posts
    1,648
    Depends on how you reboot it.

    If you log into the server and issue a shutdown through the operating system, all of the daemons should be shut down gracefully before the reboot kicks off. In this case your writes will be taken care of when the OS starts signaling the DB process that it's being ordered to shut down.

    If you use the web-based reboot option (if your host provides that) it's like yanking the plug on the server. There's a strong possibility of data loss or corruption.
    Eric Spaeth
    Enterprise Network Engineer :: Hosting Hobbyist :: Master of Procrastination
    "The really cool thing about facts is they remain true regardless of who states them."

  5. #5
    Join Date
    Jun 2001
    Posts
    288
    How many times do you guys reboot your server? I was advised to reboot my server once a month.
    <<I don't need no stinking rules for signature setup!>>

  6. #6
    Join Date
    Jun 2004
    Location
    Bay Area
    Posts
    1,320
    If you run nu buggy home-made scripts there is no need to reboot that often. Actually I only reboot for a kernel upgrade, which maybe happens once every 6 months tops..
    Powered by Level3, GBLX and AT&T

  7. #7
    Join Date
    Mar 2003
    Location
    /root
    Posts
    23,990
    Quote Originally Posted by DeNasio View Post
    How many times do you guys reboot your server? I was advised to reboot my server once a month.

    That is not a good advise.

    You will only reboot the server if it is not responding or you are doing some kernel upgrade.


    Net

    Specially 4 U
    Reseller Hosting: Boost Your Websites | Fully Managed KVM VPS: 3.20 - 5.00 Ghz, Pure Dedicated Power
    JoneSolutions.Com is on the net 24/7 providing stable and reliable web hosting solutions, server management and services since 2001
    Debian|Ubuntu|cPanel|DirectAdmin|Enhance|Webuzo|Acronis|Estela|BitNinja|Nginx

Posting Permissions

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