[MXS-2477] Schema Router's ignore_database option's documentation should be clarified Created: 2019-05-10 Updated: 2020-08-25 Resolved: 2019-05-21 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | schemarouter |
| Affects Version/s: | 2.3.6 |
| Fix Version/s: | 2.4.0 |
| Type: | Bug | Priority: | Major |
| Reporter: | Geoff Montee (Inactive) | Assignee: | Marko Rajala (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Sprint: | MXS-SPRINT-82 |
| Description |
|
I've been told that the Schema Router's ignore_database option can accept a comma-separated list of fully qualified table names, in addition to database names. However, the documentation only mentions that it accepts database names. https://mariadb.com/kb/en/mariadb-maxscale-23-schemarouter-router/#ignore_databases If it can really accept fully qualified table names as well, then I think the documentation should say so. It should probably also have an example. |
| Comments |
| Comment by Geoff Montee (Inactive) [ 2019-05-21 ] | ||
|
Thanks for adding the new parameters and updating the documentation, marko.rajala. Would it be possible for you to modify the new example in the documentation somewhat, so that it shows how to ignore multiple databases or tables with ignore_tables_regex? The example currently has this:
To ignore multiple databases or tables, I think the patterns would have to be separated by the "|" character. Can you also please show in the example how to fully qualify table names? In MariaDB, the "." character is used to qualify table names. But this character has a special meaning within a PCRE2 regex pattern. Would it have to be escaped? If you take these two changes together, the example should look something like this:
|