cookieY / Yearning

🐳 A most popular sql audit platform for mysql
http://next.yearning.io/
GNU Affero General Public License v3.0
8.43k stars 1.98k forks source link

[Feature] 可以加个数据库分组吗,支持工单处理多分库的alter场景 #1062

Open helopng opened 2 months ago

helopng commented 2 months ago

描述需求 目前功能只有单一数据库的,可以支持一下分库场景吗,目前开发对分库一条条提工单很头疼。。

你的思路 如果可以加一个数据库分组,这样对分库的create,alter就在一条工单里执行了 Flyway是配置分库数据源,然后for循环datasource来分别执行alter,可以参考下

截图

Issues-translate-bot commented 2 months ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


Title: [Feature] Can you add a database group to support the alter scenario of work order processing in multiple databases?

Describe requirements Currently, the function is only for a single database. Can it support the sub-database scenario? Currently, it is a headache for development to submit work orders one by one for sub-databases. .

your thoughts If you can add a database group, then the create and alter of the sub-database will be executed in one work order. Flyway configures the sub-datasource, and then for loops the datasource to execute alter respectively. You can refer to the following

screenshot None

helopng commented 2 months ago

用gpt写了个循环执行分库alter,就是用起来不如页面上方便

Issues-translate-bot commented 2 months ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


I used gpt to write a loop to execute sub-library alter, but it is not as convenient to use as on the page.