We are moving now from MyISAM to InnoDB. We have faced previous problems in MyISAM where the index fail and the table is not available for access. So we are wondering what type of errors that InnoDB might show because we want to fully maintain integrity of our data.
Below is .cnf file.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
innodb_file_per_table
server-id=9508071
log-bin=mysql-bin
log-error=mysql-bin.err
binlog_do_db=datacv
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Best Answer
MyISAM tables sometimes get corrupted in a power failure. REPAIR TABLE is the remedy.
InnoDB checks and repairs all its tables after any crash.
If a crash occurs in the middle of, say, a multi-row UPDATE in MyISAM, some of the rows will be updated, some won't. In InnoDB, the entire "transaction" will be automatically rolled back. That is, it's all or none.
Check your indexes when moving: http://mysql.rjweb.org/doc.php/myisam2innodb