LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices

Reply
 
Search this Thread
Old 11-27-2002, 06:11 AM   #1
esael
Member
 
Registered: Jul 2002
Posts: 109

Rep: Reputation: 15
Does my server require UPS


Hi,

If my database server is without UPS, what are the impact? My client PCs will be shut down because of power failure so is it necessary for my server to be working? Will power failure cause MySQL data corruption?

Esael
 
Old 11-27-2002, 10:53 AM   #2
michaelk
Moderator
 
Registered: Aug 2002
Posts: 11,970

Rep: Reputation: 752Reputation: 752Reputation: 752Reputation: 752Reputation: 752Reputation: 752Reputation: 752
There is always the possibility. Your odds (not corrupting) are better if you are using a journaling filesystem. The server doesn't need to be running if no one is using it.

Is there someone by the server all of the time
What kind of up time do your clients require?
How easy is to reload the system?
Do you have a backup plan and do you create backups?
How good is the power quality where the server is located. There could be brown outs, surges, lighting strikes etc. that could damage the hardware.

APC provides software for linux that monitors and can shut down the system if the power fails. The UPS needs to be connected to a serial port.
 
Old 11-28-2002, 03:21 AM   #3
esael
Member
 
Registered: Jul 2002
Posts: 109

Original Poster
Rep: Reputation: 15
There are many client PCs connecting to the server at the same location. If there are problems with the power supply, all other PCs will be affected, right? If the client PCs is not functioning, then there is no need for the server to be working. There will be a system admin. Yes, I'll have a backup plan ( if you can suggest one it'll be great).

Esael
 
Old 11-28-2002, 05:08 PM   #4
stickman
Senior Member
 
Registered: Sep 2002
Location: Nashville, TN
Posts: 1,552

Rep: Reputation: 53
Things that you must consider:
-A sudden power outage could possibly leave your file system or individual files in a corrupt state. Are you using journaling?
-What happens if the system goes down in the middle of a transaction? Will data be lost? Are you creating transactions logs?
-What perception will your customers have if your server suddenly goes down? Remember internal users are customers too.
 
Old 11-29-2002, 09:26 AM   #5
esael
Member
 
Registered: Jul 2002
Posts: 109

Original Poster
Rep: Reputation: 15
Hi,

THanks for your advice,

What is journaling? and what it does? I'm using ext2

I'm not using the internet to do transaction but only using it do reporting. The server is for internal client PC. Any problem with this?

Fortunately, we are our own customers
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
server won't boot after ups software install ntwkgirl Linux - Software 3 03-12-2006 02:38 PM
Does the X Window System server in DSL 1.1 require 128MB RAM? t3gah DamnSmallLinux 6 06-29-2005 11:14 PM
Server cannot perform host name look ups recursv Linux - Networking 2 11-08-2004 12:55 PM
Installed Ups now my linux server fails Wimpie22 Linux - Software 3 07-27-2003 01:17 AM
Scheduling server and UPS shutdown klmn1 Linux - Software 0 06-19-2003 10:26 PM


All times are GMT -5. The time now is 01:03 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration