Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 1 down vote favorite

What happens to MySQL if the partition that contains InnoDB's log files (innodb_log_group_home_dir) becomes full, read-only or otherwise unwritable?

If this did happen, what recovery process would be required? Could I use a slave to aid recovery of the master?

share|improve this question
What's the basis of your question? – Warner May 19 '10 at 1:53
Just curious. If something happens to the data_dir disk/array, the data is gone so recovery from slave or backup is necessary. What if something happens to innodb_log_group_home_dir? – Casey May 19 '10 at 3:05

1 Answer

up vote 0 down vote

Got a response on the MySQL InnoDB Forum. I that swear my question sounded less dumb when I posted it.

InnoDB cannot operate without the iblog files. They are pre-allocated, so "out of space" is not a failure mode, unwritable is.

The slave's iblog, binlog, relaylog, general log, etc, are all useless by themselves.

You should plan on stopping the slave, copying all the files over, etc, to rebuild the Master.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.