I perform my local development with that docker setup and thought I could share it to see if it can help others. Don't hesitate to close it if this is not really needed, or some sort of duplicate.

@marcaurele how do I test it? I don't use docker for cloudstack development, what commands etc can be used to test it?

in a terminal : docker-compose up

@marcaurele does mariadb 10.x work out of the box, for example mysql 5.7 needs the following config:

[mysqld]

server_id = 1
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION"
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
max_connections=1000
log-bin=mysql-bin
binlog-format = 'ROW'

Can you check/ensure any additional config to be provided?

@rhtyd it's maridb 10.0 and not 10.X which is equivalent to mysql 5.6, so there's no need for any extra configuration. It's working out of the box.

@marcaurele OK, what about the innodb settings?

innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
max_connections=1000
log-bin=mysql-bin
binlog-format = 'ROW'

Are those the custom configuration made for CS?

@marcaurele see install/admin docs, those are recommended mysql settings. The max mysql conn. settings has to do with max job/thread pool size limits.

pushed another file which is included in the compose to customize the configuration.

Thanks, LGTM @marcaurele we just need another review and then we can merge this.

@rafaelweingartner / @wido / @DaanHoogland / @GabrielBrascher are you using docker for your development?