Tyoung's Blog

DBA之路


  • Home

  • About

  • Tags

  • Categories

  • Archives

  • Search

XtraBackup error:log block numbers mismatch分析处理

Posted on 2016-09-11 | In MySQL | | Views:

日志信息

大清早的起来,打开手机看到Zabbix的邮件提醒,MariaDB数据库备份失败,数据库的备份计划已经正常运行将近一年了,于是对于这次备份失败很是好奇。远程连上服务器,查看XtraBackup备份日志的部分信息如下:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
160910 00:05:01 Connecting to MySQL server host: localhost, user: xxx, password: set, port: xxx, socket: /var/lib/mysql/mysql.sock
Using server version 10.0.23-MariaDB-enterprise-log
innobackupex version 2.3.5 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 45cda89)
incremental backup from 0 is enabled.
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /opt/mysql_data
xtrabackup: open files limit requested 65535, set to 65535
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
Found and using lsn: 846260275194 for name backup-53309-all_databases
xtrabackup: error: log block numbers mismatch:
xtrabackup: error: expected log block no. 586990567, but got no. 587187167 from the log file.
xtrabackup: error: it looks like InnoDB log has wrapped around before xtrabackup could process all records due to either log copying being too slow, or log files being too small.
xtrabackup: Error: xtrabackup_copy_logfile() failed.

Read more »

MySQL启动方式及多实例

Posted on 2016-06-26 | In MySQL | | Views:

MySQL启动方式

mysqld

启动方式:

本文假设已添加MySQL安装目录/usr/local/mysql/bin至系统环境变量PATH
所以在执行MySQL相关命令时,不再切换到MySQL安装目录,或者使用完整路径。

1
2
3
4
shell > mysqld --user=mysql &

[1] 23046
2016-06-24 22:57:33 0 [Note] mysqld (mysqld 5.6.29-log) starting as process 23046 ...
Read more »

MySQL安装和初始化

Posted on 2016-06-21 | In MySQL | | Views:

系统详情

  • 系统:CentOS 6.7
  • 数据库版本:5.6.29-log MySQL Community Server (GPL)

以下操作、介绍仅针对CentOS 6发行版本,其他发行版本的Linux可能有细微变化。

Read more »

MySQL迁移到MariaDB

Posted on 2016-03-12 | In MySQL | | Views:

业务场景

为了后期数据库管理方便,统一公司当前使用的MySQL数据库版本(当前存在MySQL和MariaDB同时使用的情况),需要将某项目的MySQL数据库替换为MariaDB。

Read more »

12
Tyoung

Tyoung

纸上得来终觉浅,绝知此事要躬行。

9 posts
1 categories
15 tags
RSS
GitHub LinkedIn
0%
© 2015 — 2020 Tyoung