Customer-management-framework - mariadb vs mysql

Support Installation
#1

We have a mysql setup (and are considering using AWS’s Aurora for availability across multiple Availability Zones). However, reading the documentation it says MariaDB is required.
Is the CMF completely not usable with mysql OR are there only certain parts not available?

From

https://github.com/pimcore/customer-data-framework/blob/master/doc/02_Installation.md

Blockquote
Please note that Customer Management Framework requires MariaDB as database. It will not work with default MySQL. MariaDB is used to save activities with the MariaDB Dynamic Columns feature: https://mariadb.com/kb/en/library/dynamic-columns/

#2

Hi,
there is already an alternative activity store available to support mysql.

To do so, just overwrite the default activity store as follows:

    # overwrite activity store to mysql
    CustomerManagementFrameworkBundle\ActivityStore\ActivityStoreInterface:
        class: CustomerManagementFrameworkBundle\ActivityStore\MySQL

BR
Christian

#3

I’ve done above in services.yml
I haven’t used activities yet but will keep testing.
Appreciate your help Christian.

#4

Sorry for the bump, but the documentation still says it won’t work with MySQL. Will there be other MariaDB only features in the future? I mean, I can of course implement the fix you provided here, but if you guys want to continue in the MariaDB direction, I’d rather not. If you are going to keep supporting MySQL, should we maybe change the documentation a bit?

#5

Hello.
Is it ok to work with MySql? Or will we have problems with this extension in the future? What would be the best way? Switch to MariaDB or install the fix for MySql? What would be your recommendation?

Thx

#6

Hi,
currently there are no plans for further mariadb specific features. So I guess running on mysql is fine too…

BR
Christian

#7

Good morning.

Okay, thank you very much for your assessment on this topic. I will continue with MySql and test it in a sandbox. Have a great day and stay healthy!

Greetings
Richard