How to configure my.cnf about dokku-mariadb HOT 8 CLOSED

Hi,

Has there been any further progress on this?

I need to configure SSL and table encryption properties. I can locate the my.cnf in the container itself although I don't know how persistent it is if I make changes to it directly.

Thanks,
Paul

from dokku-mariadb.

Ability to specify database configuration would be handy indeed. MySQL docs speak of config for mysqld. How would configuration persist in container context?

from dokku-mariadb.

We only currently mount a host directory for /var/lib/mysql. We would take a pr to add support for /etc/mysql/conf.d, or you can sponsor the work so it can be done faster.

from dokku-mariadb.

If there are no plans to do this soon, I'll take a look at doing a pull request. Could do with tweaking some settings for performance reasons ie. innodb_buffer_pool_size.

I'm guessing mapping a volume to /var/lib/dokku/services/mariadb/APP/conf.d/ would do it, along with pre-populating it with the defaults.

from dokku-mariadb.

@josegonzalez, taking a look at this, I've added the volume to my fork, however I noticed the plugin already seems to create a config directory here https://github.com/dokku/dokku-mariadb/blob/master/functions#L24 just wondering what this is for?

from dokku-mariadb.

No use atm, but we could use it for this. Can you also make the same pr for mysql?

from dokku-mariadb.

I've done a pr for this, checked mysql and it already seems to have it.
https://github.com/dokku/dokku-mysql/blob/master/functions#L48

from dokku-mariadb.

The /etc/mysql/conf.d directory is now mounted, so you should be able to just add whatever you want into it.

from dokku-mariadb.