GitHub user bradh352 added a comment to the discussion: Alternative to MySQL

I've been running mariadb (with galera cluster) in production for a while now 
without issue (after banging my head against the wall with failures for a bit).

The main configuration that solved everything for me was:
```
character-set-server           = utf8mb4
collation-server               = utf8mb4_general_ci
character_set_collations='utf8mb4=utf8mb4_general_ci'
skip-character-set-client-handshake
```

I've never had to tweak character sets and collations before for any app, I'm 
guessing it has something to do with some schema settings that cloudstack sets. 
 I didn't look deep into the cloudstack side to see if there would be any 
schema tweaks that would be less dependent on server-side settings.  The 
current recommended collation is `utf8mb4_uca1400_ai_ci` for mariadb, but that 
doesn't work.

GitHub link: 
https://github.com/apache/cloudstack/discussions/12513#discussioncomment-15591082

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to