Skip to content

Conversation

paulbrzeski
Copy link
Contributor

Sharing a couple of changes we've made to our Trellis so we can fine tune MariaDB settings for high traffic websites.

Changes include,

  • MariaDB/innodb optimisation
  • Small improvements to make things more semantic
  • Various configs to support above

This PR only provides the defaults, you can override these settings like any other using your group_vars configs.

Example settings from our production servers below,

MariaDB for a server with 4GB of RAM and sharing environment with PHP and Nginx
New variables to add to group_vars/%ENV%/mariadb.yml,

mariadb_set_innodb_buffer_pool_size: true
mariadb_innodb_buffer_pool_size: 512M
mariadb_set_innodb_log_file_size: true
mariadb_innodb_log_file_size: 128M

More info - https://mariadb.com/kb/en/innodb-system-variables/#innodb_buffer_pool_size

(previously #1430)

@swalkinshaw
Copy link
Member

Thanks @paulbrzeski. Can you rebase this one as well please?

I'll test but it looks good and will be a nice addition (along with the PHP PR too!) 🎉

@paulbrzeski paulbrzeski force-pushed the mariadb-tuning-settings branch from 8323eb5 to 7007a43 Compare March 3, 2023 12:52
@paulbrzeski
Copy link
Contributor Author

paulbrzeski commented Mar 3, 2023

Hi @swalkinshaw, All done! Cheers

@zak-wearecore
Copy link
Contributor

Any idea when this will be merged?

@swalkinshaw
Copy link
Member

See #1497

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

3 participants