tassoskoutlas / devbox Goto Github PK

Optimise MySQL

https://support.acquia.com/hc/en-us/articles/360005253954-Fixing-database-deadlocks
https://blog.acromedia.com/drupal-8-commerce-performance-tuning

Checkout mautic MySQL config options
https://github.com/mautic/mautic

mysql -u username -p -e "CREATE DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci";

• Add symfony CLI tool
• Add a symfony vhost with correct
• Add symfony project config role

Add env configuration in config which will be sourced by both shell and apache.

Currently devbox adopts a multiuser approach on database layer. This needs to be simplified into a single user with multiple databases and expose db_user and db_pass as environmental variables that can be used directly in settings.php.

Create an environment variable to designate where is the system used (local, devel, stage, prod).

Improve apache process performance via optimising:

=ENABLE
mpm_event

=DISABLE
alias
autoindex
env
negotiation
reqtimeout
status
php7.2
mpm_prefork

Initially loaded modules
core_module (static)
so_module (static)
watchdog_module (static)
http_module (static)
log_config_module (static)
logio_module (static)
version_module (static)
unixd_module (static)
access_compat_module (shared)
alias_module (shared)
auth_basic_module (shared)
authn_core_module (shared)
authn_file_module (shared)
authz_core_module (shared)
authz_host_module (shared)
authz_user_module (shared)
autoindex_module (shared)
deflate_module (shared)
dir_module (shared)
env_module (shared)
filter_module (shared)
mime_module (shared)
mpm_event_module (shared)
negotiation_module (shared)
proxy_module (shared)
proxy_fcgi_module (shared)
reqtimeout_module (shared)
rewrite_module (shared)
setenvif_module (shared)
status_module (shared)

https://www.monitis.com/blog/25-apache-performance-tuning-tips/
https://geekflare.com/php-fpm-optimization/

vagrant up (create db + docroot)
mysql -e "CREATE DATABASE drupal CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci"
vagrant ssh
cd ~/projects/...
composer create-project drupal/recommended-project .
cp web/sites/default.settings.php settings.php - uncomment last lines
cp web/sites/example.settings.local.php web/sites/default/settings.local.php
drush site-install --account-name=admin --account-pass=admin
https://www.drupal.org/project/drupal/issues/2003420

Allow for multiple vhost templates based on project type.

When doing vagrant up with the official ubuntu/focal64 image, vagrant hangs waiting for the machine to boot and ssh to be available. The machine shown as running but Virtualbox also hangs and has to be terminated to destroy the box.

Issue appears to be this one: https://askubuntu.com/questions/1243582/unable-to-boot-official-vagrant-boxes-for-20-04

geerlingguy/drupal-vm#1806
https://www.cyberciti.biz/faq/linux-unix-tuning-nfs-server-client-performance/

Clean up README to reflect new way of working with devbox.

Add Cockpit for admin purposes

On task Install Apache Webserver packages

Automatically turn all traffic into HTTPS
Change all vhosts for HTTPS

Message from Ansible

[DEPRECATION WARNING]: Distribution Ubuntu 18.04 on host devbox should use
/usr/bin/python3, but is using /usr/bin/python for backward compatibility with
prior Ansible releases. A future Ansible release will default to using the
discovered platform python for this host. See https://docs.ansible.com/ansible/
2.9/reference_appendices/interpreter_discovery.html for more information. This
feature will be removed in version 2.12. Deprecation warnings can be disabled
by setting deprecation_warnings=False in ansible.cfg.