Results 1 to 7 of 7
Thread: Rebooting server
-
02-09-2008, 08:00 AM #1Web Hosting Guru
- 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!>>
-
02-09-2008, 08:15 AM #2Custom Hosting Master
- Join Date
- Jan 2007
- Posts
- 2,602
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.
-
02-09-2008, 08:17 AM #3Vice Cheese
- 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
-
02-09-2008, 08:19 AM #4Web Hosting Master
- 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."
-
02-10-2008, 06:32 AM #5Web Hosting Guru
- 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!>>
-
02-10-2008, 06:35 AM #6Web Hosting Master
- 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
-
02-10-2008, 06:38 AM #7The Linux Specialist
- Join Date
- Mar 2003
- Location
- /root
- Posts
- 23,990
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