apache / apache/shardingsphere

How to set the proxy server system variables

Open
#31,735 2 comments 0 reactions 0 assignees View on GitHub
in: proxy
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)

![1718616744002](https://github.com/apache/shardingsphere/assets/49480676/484e6582-1059-4707-a7c3-a565a7b9fa78)

but after connecting to the proxy server, the value is 0. I don't know where to set it.
![image](https://github.com/apache/shardingsphere/assets/49480676/8a3ff309-6f15-45dc-b8d3-54e7f6ff4a46)

Variable 'lower_case_table_names' is a read only variable

![image](https://github.com/apache/shardingsphere/assets/49480676/7d08df48-b12b-4d3b-9319-b3c3740538b0)

I set the value in the console window connected to the proxy server, but there was no change
![image](https://github.com/apache/shardingsphere/assets/49480676/98831906-9918-4102-93f7-c7c14f135243)

Based on the above, I hope to find a way to set this system variable

Contributor guide

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.