#appwrite connection to galera cluster

11 messages · Page 1 of 1 (latest)

boreal latch
#

mariadb 11, all works well in docker compose and mariadb container, but when I changed to galera cluster it throws errors like that

Fatal error: Uncaught Exception: Failed to connect to database: Failed to create connection: SQLSTATE[HY000] [2054] Server sent charset (0) unknown to the client. Please, report to the developers in /usr/src/code/app/http.php:85

Stack trace:
#0 [internal function]: {closure}()

}
  thrown in /usr/src/code/app/http.php on line 85
[2024-04-25 13:24:46 #1.4]    ERROR    php_swoole_server_rshutdown() (ERRNO 503): Fatal error: Uncaught Exception: Failed to connect to database: Failed to create connection: SQLSTATE[HY000] [2054] Server sent charset (0) unknown to the client. Please, report to the developers in /usr/src/code/app/http.php:85

Stack trace:
#0 [internal function]: {closure}()

}
  thrown in /usr/src/code/app/http.php on line 85
#

target database details regarding that error:
utf8mb4,utf8mb4_general_ci

boreal latch
#

environment is docker swarm and mariadb is installed and replicated on each of 4 nodes

#

so I tried to create only local connections to cut down on network latency as much as possible and expose db from host.docker.internal

#

for all the other services I host it works perfectly well

#

but appwrite has problems for some reason

#

can someone suggest where to look for solution?

#

I also deployed maxscale inside the cluster and if I connect appwrite to maxscale deployment, all works as expected

#

despite the fact that maxscale works literally the same way, connecting to mariadb through host.docker.internal

#

so something in the middle is destroying the connections... but how?

plucky valve
#

Any updates on this ?