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

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.

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

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.

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 :)