
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

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?
Recommended threads
- Document Data is null.
I'm using flutter and I've just got everything set up, the document meta data is null but the actual query is fine. (see screenshot) The permission I have ar...
- cli 5.0.5 command for pull and push of d...
Hi i am using selfhosted appwrite 1.5.10, for migration (duplicate project) purpose i am using cli 5.0.5, but i am unable to find commands for pull and push, wh...
- Do I need Redis if using appwrite
Saw appwrite has built-in redis, but does this work for listdocuments, getdocument and other query etc? what does the appwrite redis covers under the hood?
