[Discussion] Can WeScale store system tables in a database other than 'mysql'?

[earayu]

Background

WeScale currently stores its system tables, which are used to record metadata such as the schema_migrations table required by OnlineDDL, in the 'mysql' database. The question is whether it is possible for WeScale to store these tables in a different database, such as 'system_db'.

Proposal

We could explore the possibility of introducing an interception layer that checks the database and table being used when WeScale components communicate with MySQL. If the database is 'mysql' and the table is a WeScale system table, we can rewrite the database to 'system_db'.

This issue serves as a starting point for discussing the technical feasibility of this approach.