You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by "chunkyen (via GitHub)" <gi...@apache.org> on 2026/01/24 07:23:53 UTC
[D] Alternative to MySQL [cloudstack]
GitHub user chunkyen created a discussion: Alternative to MySQL
Looks like it is all Doom and Gloom for MySQL [https://www.theregister.com/2026/01/23/mysql_post_oracle/](https://www.theregister.com/2026/01/23/mysql_post_oracle/).
All my testing has been done with MySQL. So does the community recommends using MariaDB as Cloudstack datastore? Any pitfalls to look out for?
GitHub link: https://github.com/apache/cloudstack/discussions/12513
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by Jürgen Gotteswinter via users <us...@cloudstack.apache.org>.
Perconas Cluster is called PXC Cluster, Percona XtraDB Cluster. Traditionally Percona adds their own secret sauce, its a MySQL consulting company. I would see it the same way as MariaDB. You can buy commercial support, but the software itself is free.
Am 26.01.26, 13:35 schrieb "Marty Godsey" <martyg@rudio.net <ma...@rudio.net>>:
If I am not mistaken, isn’t Percona XtraDB Cluster and Galera the same thing? I think Persona is just a commercial version of Galera.
From: jgotteswinter (via GitHub) <git@apache.org <ma...@apache.org>>
Date: Monday, January 26, 2026 at 3:47 AM
To: users@cloudstack.apache.org <ma...@cloudstack.apache.org> <users@cloudstack.apache.org <ma...@cloudstack.apache.org>>
Subject: Re: [D] Alternative to MySQL [cloudstack]
WARNING: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
GitHub user jgotteswinter added a comment to the discussion: Alternative to MySQL
We are using Percona XtraDB Cluster, but i can also recommend the Percona MySQL. Happy user for many many years.
GitHub link: https://atpscan.global.hornetsecurity.com?d=RyEtXR-n1S7AZPsdrzUccYGJlRt0VsKeIN-jS0TqG6s&f=DrqsUSirJtAkMdJrldfyGNO-pgJ83VP_zIF6i-b1p52RgTXTOJZyaQ4Lm8hmqwqh&i=&k=5Ub2&m=703EqALzf6rypjQOV_SHCIfpdoaO-YcvHRMjiamqGbUuM1s9U3QVVlIn5k7z_b6sXcoye4BrScXEwff5aOS4AZTihSHDW4c8F564Wo9BREiP4_K0qRWkFnTlPaka4rF2&n=W7Zhr5xmT5YvknavOufgd_p1r6Svx4MvRdl-ZLFanxgJaGe17OHGBsbBuY9kLvcc&r=d6oeTK5U-AdrIwdzH3MtxnSslEbNG5x1St82f7sw3bneVu0qMct5PCnO8IfID2I2&s=cfcf5c199d3129810a15e08b8195d9c5d7d47750677e8ac11afa1e72dd7d4e5b&u=https%3A%2F%2Fgithub.com%2Fapache%2Fcloudstack%2Fdiscussions%2F12513%23discussioncomment-15603777 <https://atpscan.global.hornetsecurity.com?d=RyEtXR-n1S7AZPsdrzUccYGJlRt0VsKeIN-jS0TqG6s&f=DrqsUSirJtAkMdJrldfyGNO-pgJ83VP_zIF6i-b1p52RgTXTOJZyaQ4Lm8hmqwqh&i=&k=5Ub2&m=703EqALzf6rypjQOV_SHCIfpdoaO-YcvHRMjiamqGbUuM1s9U3QVVlIn5k7z_b6sXcoye4BrScXEwff5aOS4AZTihSHDW4c8F564Wo9BREiP4_K0qRWkFnTlPaka4rF2&n=W7Zhr5xmT5YvknavOufgd_p1r6Svx4MvRdl-ZLFanxgJaGe17OHGBsbBuY9kLvcc&r=d6oeTK5U-AdrIwdzH3MtxnSslEbNG5x1St82f7sw3bneVu0qMct5PCnO8IfID2I2&s=cfcf5c199d3129810a15e08b8195d9c5d7d47750677e8ac11afa1e72dd7d4e5b&u=https%3A%2F%2Fgithub.com%2Fapache%2Fcloudstack%2Fdiscussions%2F12513%23discussioncomment-15603777>
----
This is an automatically sent email for users@cloudstack.apache.org <ma...@cloudstack.apache.org>.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org <ma...@cloudstack.apache.org>
Re: [D] Alternative to MySQL [cloudstack]
Posted by Marty Godsey <ma...@rudio.net>.
If I am not mistaken, isn’t Percona XtraDB Cluster and Galera the same thing? I think Persona is just a commercial version of Galera.
From: jgotteswinter (via GitHub) <gi...@apache.org>
Date: Monday, January 26, 2026 at 3:47 AM
To: users@cloudstack.apache.org <us...@cloudstack.apache.org>
Subject: Re: [D] Alternative to MySQL [cloudstack]
WARNING: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
GitHub user jgotteswinter added a comment to the discussion: Alternative to MySQL
We are using Percona XtraDB Cluster, but i can also recommend the Percona MySQL. Happy user for many many years.
GitHub link: https://atpscan.global.hornetsecurity.com?d=RyEtXR-n1S7AZPsdrzUccYGJlRt0VsKeIN-jS0TqG6s&f=DrqsUSirJtAkMdJrldfyGNO-pgJ83VP_zIF6i-b1p52RgTXTOJZyaQ4Lm8hmqwqh&i=&k=5Ub2&m=703EqALzf6rypjQOV_SHCIfpdoaO-YcvHRMjiamqGbUuM1s9U3QVVlIn5k7z_b6sXcoye4BrScXEwff5aOS4AZTihSHDW4c8F564Wo9BREiP4_K0qRWkFnTlPaka4rF2&n=W7Zhr5xmT5YvknavOufgd_p1r6Svx4MvRdl-ZLFanxgJaGe17OHGBsbBuY9kLvcc&r=d6oeTK5U-AdrIwdzH3MtxnSslEbNG5x1St82f7sw3bneVu0qMct5PCnO8IfID2I2&s=cfcf5c199d3129810a15e08b8195d9c5d7d47750677e8ac11afa1e72dd7d4e5b&u=https%3A%2F%2Fgithub.com%2Fapache%2Fcloudstack%2Fdiscussions%2F12513%23discussioncomment-15603777
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "maxadamo (via GitHub)" <gi...@apache.org>.
GitHub user maxadamo closed the discussion with a comment: Alternative to MySQL
Around a year ago, MariaDB acquired Galera (Codership), making Percona unnecessary now. The official SST methods for Galera are now rsync and mariabackup. Mariabackup allows the donor to remain available during the SST process.
Postgres would only be helpful in multi-region configurations where there are multiple replicas operating across various geographic locations. This is dicciful to achieve with Galera, as It could significantly slow down database writes.
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-18417730
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "weizhouapache (via GitHub)" <gi...@apache.org>.
GitHub user weizhouapache closed the discussion with a comment: Alternative to MySQL
@bradh352
Just saw this. This is an issue caused by a change in MariaDB 11.6, which PR #13962 is trying to fix.
I proposed a similar workaround to yours in the comment: https://github.com/apache/cloudstack/pull/13962#issuecomment-5408756982
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-18419355
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "chunkyen (via GitHub)" <gi...@apache.org>.
GitHub user chunkyen edited a discussion: Alternative to MySQL
Looks like it is all Doom and Gloom for MySQL [https://www.theregister.com/2026/01/23/mysql_post_oracle/](https://www.theregister.com/2026/01/23/mysql_post_oracle/).
All my testing has been done with MySQL. So does the community recommends using MariaDB as Cloudstack datastore? Any pitfalls to look out for?
Supporting Postgres would be more future proof IMHO.
GitHub link: https://github.com/apache/cloudstack/discussions/12513
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "bradh352 (via GitHub)" <gi...@apache.org>.
GitHub user bradh352 added a comment to the discussion: Alternative to MySQL
If you're on a MySQL version prior to v8, you can just uninstall mysql and install MariaDB and run the standard mysql_upgrade (err, mariadb_upgrade) command.
But if you're on version 8, you have to do a full dump / reload due to incompatible on-disk formats. I haven't gone through this process for cloudstack, but assuming your database isn't too large its not a big deal.
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-15598163
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "bradh352 (via GitHub)" <gi...@apache.org>.
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 users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "maxadamo (via GitHub)" <gi...@apache.org>.
GitHub user maxadamo edited a comment on the discussion: Alternative to MySQL
Around a year ago, MariaDB acquired Galera (Codership), making Percona unnecessary now. The official SST methods for Galera are now rsync and mariabackup. Mariabackup allows the donor to remain available during the SST process.
Postgres would only be helpful in multi-region configurations where there are multiple replicas operating across various geographic locations. This is difficult to achieve with Galera, as it could slow down database writes.
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-18417730
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "bradh352 (via GitHub)" <gi...@apache.org>.
GitHub user bradh352 added a comment to the discussion: Alternative to MySQL
Maybe that version was less strict or defaulted to something closer to mysql. Its still an LTS release that's got a couple of years left on it so if it works well, its a good option.
Realistically someone should probably test all 3 MariaDB LTS versions that are still supported (10.11, 11.4, 11.8) and document compatibility and possibly required configuration changes for those versions.
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-15598120
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "maxadamo (via GitHub)" <gi...@apache.org>.
GitHub user maxadamo closed the discussion with a comment: Alternative to MySQL
After experimenting with different setups, I decided against replicating between two distinct clusters. Instead, I'm stretching the Galera cluster by putting two nodes at each location and a single node at a third site that will run the arbitrator.
I've also enabled the `gmcast` settings, which allow splitting the cluster in multiple segments, so commits are relayed by one host at time and are propagated in the local site.
Without this parameter, one host sends to all, and it means crossing the WAN twice instead of just once.
The GTID replication kept generating errors. Also, MaxScale geo-replication is not free and is only in technology preview.
**I really wish I could have used Postgres with Patroni! It would have very effective.** __
Alongside Galera and keeplived I am also using `etcd` with keys generated by a systemd service to prevent split-brain scenarios. This functionality would have been available by default with Patroni.
So, plus one for Postgres supports 👍.
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-18625296
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "chunkyen (via GitHub)" <gi...@apache.org>.
GitHub user chunkyen closed a discussion: Alternative to MySQL
Looks like it is all Doom and Gloom for MySQL [https://www.theregister.com/2026/01/23/mysql_post_oracle/](https://www.theregister.com/2026/01/23/mysql_post_oracle/).
All my testing has been done with MySQL. So does the community recommends using MariaDB as Cloudstack datastore? Any pitfalls to look out for?
Supporting Postgres would be more future proof IMHO.
GitHub link: https://github.com/apache/cloudstack/discussions/12513
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "maxadamo (via GitHub)" <gi...@apache.org>.
GitHub user maxadamo closed the discussion with a comment: Alternative to MySQL
I am currently working to implement this database architecture. It consists of two Galera clusters, replicating through signal18/replication-manager.
There will be a primary cluster and HAProxy points to that one.
<img width="611" height="392" alt="image" src="https://github.com/user-attachments/assets/ec33a4e5-7a75-42ce-ae5a-1749f4c20756" />
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-18478168
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "chunkyen (via GitHub)" <gi...@apache.org>.
GitHub user chunkyen added a comment to the discussion: Alternative to MySQL
Looks like we will have to face the reality of moving to MariaDB. Has anyone done a CloudStack MySQL to MariaDB migration before?
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-15595398
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "jgotteswinter (via GitHub)" <gi...@apache.org>.
GitHub user jgotteswinter added a comment to the discussion: Alternative to MySQL
We are using Percona XtraDB Cluster, but i can also recommend the Percona MySQL. Happy user for many many years.
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-15603777
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "DaanHoogland (via GitHub)" <gi...@apache.org>.
GitHub user DaanHoogland closed the discussion with a comment: Alternative to MySQL
this seems outdated, please reopen or start a new q&a item if there are still issues.
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-17973169
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "TadiosAbebe (via GitHub)" <gi...@apache.org>.
GitHub user TadiosAbebe added a comment to the discussion: Alternative to MySQL
@bradh352 I am also running galera cluster in my environment, but i don't remember setting or changing the above configurations manually. What failures were you facing before tweaking the configuration?
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-15594668
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "bradh352 (via GitHub)" <gi...@apache.org>.
GitHub user bradh352 added a comment to the discussion: Alternative to MySQL
I'd get random failures clicking through the UI all about collation issues. That was months ago on Cloudstack 4.20 I think. Its always been MariaDB 11.4 though.
Guess I should ask what version of MariaDB you're running...
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-15594943
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "TadiosAbebe (via GitHub)" <gi...@apache.org>.
GitHub user TadiosAbebe added a comment to the discussion: Alternative to MySQL
We are on Mariadb 10.11.13
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-15596157
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org
Re: [D] Alternative to MySQL [cloudstack]
Posted by "bhouse-nexthop (via GitHub)" <gi...@apache.org>.
GitHub user bhouse-nexthop closed the discussion with a comment: Alternative to MySQL
if you need a cross-region cluster, yeah, things get way more complicated unless your regions are fairly close.
I've run datacenters before within 20 or so ms of eachother (stable dedicated links like wavelengths, not public internet) with a stretched galera with success, mostly because of the opportunistic certification ... but I didn't explicitly try that with cloudstack.
GitHub link: https://github.com/apache/cloudstack/discussions/12513#discussioncomment-18481032
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@cloudstack.apache.org