Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Cannot Reproduce
-
2.4.4
-
CentOS 7, MaxScale 2.4.4, MariaDB 10.4.10
Description
When a SELECT query is run via MaxScale a result that should contain integers is being converted to strings.
The query is being run from PHP.
Amending the database connection to point directly to the master or slaves behind MaxScale resolves the problem and integers are correctly returned.
This is the MacScale config we have in place:
[maxscale]
|
threads=auto
|
|
|
# Server definitions
|
#
|
|
|
[service-sql1]
|
type=server
|
address=172.16.203.4
|
port=3306
|
protocol=MariaDBBackend
|
|
|
[service-sql2]
|
type=server
|
address=172.16.203.5
|
port=3306
|
protocol=MariaDBBackend
|
|
|
[service-sql3]
|
type=server
|
address=172.16.203.6
|
port=3306
|
protocol=MariaDBBackend
|
|
|
[MariaDB-Monitor]
|
type=monitor
|
module=mariadbmon
|
servers=service-sql1,service-sql2,service-sql3
|
auto_failover=false
|
auto_rejoin=false
|
user=maxscale
|
password=********************
|
monitor_interval=2000
|
|
|
[OLTP-Service]
|
type=service
|
disable_sescmd_history=true
|
router=readwritesplit
|
version_string=Maxscale2
|
servers=service-sql1,service-sql2,service-sql3
|
user=maxscale
|
password=********************
|
|
|
[OLTP-Listener]
|
type=listener
|
service=OLTP-Service
|
protocol=MariaDBClient
|
port=3306
|