文章不在长，坚持不懈记录下努力前行的脚步
发布时间：2017-11-03 11:54:32
在使用innobackup来恢复数据库的过程当中，如果copy-back后没有调整目录权限，启动时就会报以下错误......【阅读全文】
发布时间：2017-03-13 10:29:27
Last_SQL_Errno: 1051 Last_SQL_Error: Worker 2 failed executing transaction '' at master log mysql-bin.045231, end_log_pos 119055873; Error 'Unknown table 'fission_log.FISS_LOG_20170305'' on query. Default database: 'fission_log'. Query: 'D.........【阅读全文】
发布时间：2017-03-10 15:24:40
mysqlbinlog --no-defaults --base64-output='decode-rows' -vv /home/mysqldb/db/mysql-bin.000041|grep 'alter' -iERROR: Error in Log_event::read_log_event(): 'Sanity check failed', data_len: 8138, event_type: 31ERROR: Could not read entry at offset 277: Error in log format or read error.客.........【阅读全文】
发布时间：2017-02-14 19:02:30
2017-02-14 09:28:26 7573 [Note] Slave: MTS group recovery relay log info based on Worker-Id 3, group_relay_log_name ./relay-bin.023359, group_relay_log_pos 26423750 group_master_log_name mysql-bin.016005, group_master_log_pos 264235872017-02-14 09:28:26 7573 [ERROR] Error looking for file after ./r.........【阅读全文】
发布时间：2017-01-06 19:02:34
数据库丝滑迁移host1指源数据库，host2指迁移目标库主机(从库)host11.备份./innobackupex --defaults-file="/etc/my.cnf" --user="admin" --password="admin" --host="localhost" --port=3306 --socket="/tmp/mysql.sock" --no-version-check --use-memory=8GB --rsync --tmpdir=/tmp "/home/ful"2.压缩传输cd .........【阅读全文】
