We have a mysql cluster.
How can we checking and repairing tables ?
Thanks !
David Marois
DBA
mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
Use a backup powersupply and shutdown software to gracefully shutdown
after a power fail.
Yaw Ofori-Adjei wrote:
I have used MySQL for about 2 years nowand I love it.
My only problem is that I am in africa were power
fluctuations are rampant. I usally get table handelr
error 127 after every
I have used MySQL for about 2 years nowand I love it.
My only problem is that I am in africa were power
fluctuations are rampant. I usally get table handelr
error 127 after every power outage. S'times simple
repair just doesn't work and the entire database must
be restore. It there a way around
It there a way around this error occuring
after every outage?.
Eeek!
Are you running myisamchk -r? - obviously, there isn't really much of a
way to avoid having to repair tables after a hard OS crash. I would
highly recommend trying to get ahold of something like an APC battery
supply which
Hello.
Have a look at the transaction safe table types (InnoDB, BDB, ...). I
did not try them myself, but from what I read on the list, there is a
good chance that they will return to a consistent state themselves.
Bye,
Philemon.
PS: Of course, the better solution would be a back-up