Hi Andis.
I have no experience with this, but once your UPS kicks in
can you schedule a graceful shutdown after some number
of minutes?
On my Red Hat 7.0 machine, I see this in /etc/inittab:
# When our UPS tells us power has failed, assume we have a few minutes
# of power left. Schedule a shutdown for 2 minutes from now.
# This does, of course, assume you have powerd installed and your
# UPS connected and working correctly.
pf::powerfail:/sbin/shutdown -f -h +2 "Power Failure; System Shutting Down"
# If power was restored before the shutdown kicked in, cancel it.
pr:12345:powerokwait:/sbin/shutdown -c "Power Restored; Shutdown Cancelled"
Maurice
On Wed, Jul 25, 2001 at 10:01:27AM -0700, Andis wrote:
> Hi!
>
> I have LAN with some PC, which use MySQL database. Sometime power supplay failure
>occurs. I have back-UPS too, but them can't hold power for 2 or more hours and
>because it server loose power supplay and just stop (without correct system
>shut-down).
>
> I got such problem: I waste data in this situation (users waste what them did). As I
>understand, MySQL server don't write data on disc immediatly, but after some time.
>
> What can I do for saving data regularly (for example once at hour or something like
>that)?
>
>
> With best regards -
>
> Andis Grasis
>
> Latvia
--
Maurice Aubrey <[EMAIL PROTECTED]>
MySQL 3.22.32: up 6.0 days, processed 412,923,893 queries (802/sec. avg.)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
