Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to get only the binlog that listens to the specified db database #345

Open
puritykid opened this issue Jun 1, 2022 · 1 comment
Open

Comments

@puritykid
Copy link

How to get only the binlog that listens to the specified db database? Now there are many databases under an instance. By processing event filtering, it is found that the delay is very high. Is there a good way to filter out the binlog in the required db by specifying the database when initiating the dump request?

@jssqsyy
Copy link

jssqsyy commented Dec 30, 2022

我现在的项目也是遇到类似的情况,一个mysql实例有两个schema,prod和dev,同时启动两个监听客户端,只有一个延迟很低,另一个延迟大概有20s左右,我的方案是重新在另一台服务器上搭建一个mysql,把他们分离开,这样就能保证两边延迟都很低。否则你只能把数据库改成多实例的,并且一个实例对应一个binlog文件,这样应该也能保证低延迟。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants