Re: multi-column indexes on InnoDB tables

2006-06-27 Thread Gabriel PREDA
Yes they're all right ! Database is the last thing on your problem list... I don't know how you thought the system... if it's WEB based... more problems arrise... In a potential scenario... I miself would power up the database server with an UPS... because it contains DATA... the application...

Re: multi-column indexes on InnoDB tables

2006-06-27 Thread Karl Larsen
Chris White wrote: On Tuesday 27 June 2006 10:22 am, Asif Lodhi wrote: ALL I am asking is how strong you think MySQL stands up in such a business scenario. I have even created the manual business procedures for power-failure scenarios. I DO need to know HOW gracefully MySQL will recover aft

Re: multi-column indexes on InnoDB tables

2006-06-27 Thread Brent Baisley
Sounds like you have more potential problems than is typical. It also sounds like you may want to setup replication, even if the data is replicated to an old, old computer that you were going to throw out. It's not a big deal if it falls behind in the replication at times. And if you could get a

Re: multi-column indexes on InnoDB tables

2006-06-27 Thread Chris White
On Tuesday 27 June 2006 10:22 am, Asif Lodhi wrote: > ALL I am asking is how strong you think MySQL stands up in such a > business scenario. I have even created the manual business procedures > for power-failure scenarios. I DO need to know HOW gracefully MySQL > will recover after each power fai