Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
K
kb
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 2
    • Issues 2
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • granite
  • kb
  • Wiki
    • Best_practice
  • maxwell

maxwell · Changes

Page history
Update maxwell authored Mar 25, 2022 by 李子健's avatar 李子健
Show whitespace changes
Inline Side-by-side
Showing with 4 additions and 0 deletions
+4 -0
  • best_practice/maxwell.md best_practice/maxwell.md +4 -0
  • No files found.
best_practice/maxwell.md
View page @ 03cccebc
...@@ -676,6 +676,10 @@ update maxwell.positions set binlog_file = 'mysql-bin.005302',binlog_position = ...@@ -676,6 +676,10 @@ update maxwell.positions set binlog_file = 'mysql-bin.005302',binlog_position =
原因:账户没有mysql库的访问权限,上游修改了mysql库的user表 原因:账户没有mysql库的访问权限,上游修改了mysql库的user表
处理方法:最优方法是给maxwell使用的用户对应的权限;临时的方法是在maxwell的元数据库中的tables表中插入对应user表的信息,注意对应的database_id 处理方法:最优方法是给maxwell使用的用户对应的权限;临时的方法是在maxwell的元数据库中的tables表中插入对应user表的信息,注意对应的database_id
INSERT INTO maxwell.tables (id, schema_id, database_id, name, charset, pk) VALUES (727, 1092, 54, 'user', 'utf8', 'Host,User'); INSERT INTO maxwell.tables (id, schema_id, database_id, name, charset, pk) VALUES (727, 1092, 54, 'user', 'utf8', 'Host,User');
3. com.github.shyiko.mysql.binlog.network.ServerException: Could not find first log file name in binary log index file
原因:reset master或者binlog文件更名导致找不到记录的binlog文件等
处理方法:手动修正positions表中对应实例的binlog信息,或者清空/删除maxwell库重建
``` ```
## 附:完整参数 ## 附:完整参数
......
Clone repository
  • README
  • basic_guidelines
  • basic_guidelines
    • basic_guidelines
    • dev_guide
    • project_build
    • 开发流程
  • best_practice
  • best_practice
    • AlterTable
    • RDS
    • azkaban
    • create_table
    • design
    • elasticsearch
    • elasticsearch
      • ES运维
    • logstash
View All Pages