2012/10/4 Andrew Miklas and...@pagerduty.com
Hi guys,
I recently had a data corruption issue with InnoDB. MySQL was shut down
improperly (power failure), and when the system came back up, MySQL refused
to start. On inspection of the logs (see below), it looks like the
tablespace became
Hi Manuel,
Thanks for the fast reply.
On Oct 4, 2012, at 12:05 AM, Manuel Arostegui wrote:
snip
it shouldn't be a biggie if you have a BBU. Do you guys use HW RAID + BBU?
We've checked with our hosting provider, and the database was indeed stored on
a BBU RAID.
What's your
: mysql@lists.mysql.com
Subject: Re: InnoDB corrupt after power failure
Hi Manuel,
Thanks for the fast reply.
On Oct 4, 2012, at 12:05 AM, Manuel Arostegui wrote:
snip
it shouldn't be a biggie if you have a BBU. Do you guys use HW RAID +
BBU?
We've checked with our hosting provider
Hi Rick,
On Oct 4, 2012, at 2:40 PM, Rick James wrote:
I hope you turned OFF caching on the drives, themselves. The BBU should be
the single place that caches and is trusted to survive a power outage.
The DB server in question is running in a virtualized environment, so the array
shows up
To: Rick James
Cc: Manuel Arostegui; mysql@lists.mysql.com
Subject: Re: InnoDB corrupt after power failure
Hi Rick,
On Oct 4, 2012, at 2:40 PM, Rick James wrote:
I hope you turned OFF caching on the drives, themselves. The BBU
should be the single place that caches and is trusted to survive