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

refactor MySQL audit rules to increase usability #121

Closed
sjjian opened this issue Dec 2, 2021 · 1 comment
Closed

refactor MySQL audit rules to increase usability #121

sjjian opened this issue Dec 2, 2021 · 1 comment
Assignees
Labels
feature verified the issue all pr is verified
Milestone

Comments

@sjjian
Copy link
Member

sjjian commented Dec 2, 2021

背景:

现有的规则中,部分规则使用固定的数值,例如 “普通索引必须要以"idx_"为前缀”,无法通过配置 value 改变“idx_“的数值,导致该规则无法通用,对于不同的公司这个规则可能不一样,有的公司可能是其他前缀。

整改方向

“普通索引必须要以"idx_"为前缀” 改为 “普通索引必须使用固定前缀”,对于value默认为 “idx_”

@sjjian sjjian self-assigned this Dec 2, 2021
@sjjian sjjian added the feature label Dec 2, 2021
@sjjian sjjian added this to the v1.2112.0 milestone Dec 2, 2021
@sjjian
Copy link
Member Author

sjjian commented Dec 2, 2021

原始规则 变更后的规则 默认值
数据库名称建议以"_DB"结尾 数据库名称必须使用固定后缀结尾 _DB
普通索引必须要以"idx_"为前缀 普通索引必须使用固定前缀 idx_
unique索引必须要以"uniq_"为前缀 unique索引必须使用固定前缀 uniq_
表名、列名、索引名的长度不能大于64字节 表名、列名、索引名的长度不能大于指定字节 64
建议使用Innodb引擎,utf8mb4字符集 1. 必须使用指定数据库引擎 Innodb
建议使用Innodb引擎,utf8mb4字符集 2. 必须使用指定数据库字符集 utf8mb4

@sjjian sjjian mentioned this issue Dec 2, 2021
@sjjian sjjian closed this as completed Dec 3, 2021
@Marcus9530 Marcus9530 added the verified the issue all pr is verified label Dec 31, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature verified the issue all pr is verified
Projects
None yet
Development

No branches or pull requests

2 participants