apache / apache/shardingsphere
How to set the proxy server system variables
- Dominant language
- Java
- Stars
- 20.8k
- Forks
- 6.9k
- Avg merge
- 11h 35m
- Merged PRs (30d)
- 326
Description
The database that needs to be proxied is MySQL. The system variable values of the master and slave databases are both 1(for lower_case_table_names)

but after connecting to the proxy server, the value is 0. I don't know where to set it.

Variable 'lower_case_table_names' is a read only variable

I set the value in the console window connected to the proxy server, but there was no change

Based on the above, I hope to find a way to set this system variable
Contributor guide
Research direction
No source file or test is named. Start by reproducing the lower_case_table_names mismatch through the MySQL proxy and compare the proxy and master/slave system-variable behavior, including the read-only error. Done means identifying whether the variable is configurable through the proxy and documenting the supported setting or limitation.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, mysql
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100