Things to do after connecting server to RunCloud

MySQL

Create /etc/mysql/conf.d/z_additional.cnf with the below contents. (Note: The files are read alphabetically, so need to make to sure it is read by MySQL at the end, thus the z_ prefix.)

[mysqld]

# Disable binary log
skip-log-bin

# Default MySQL character set and collation
# See: https://coderwall.com/p/xdrjxg/proper-mysql-character-set-and-collation-setup
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
skip-character-set-client-handshake

# Useful to large multi insert query
# MySQL has a hard limit of 1GB
max_allowed_packet = 1G

# Should be total of InnoDB size + 60 or 70%
# See: https://dba.stackexchange.com/a/27341/206249
# See: https://www.liquidweb.com/kb/mysql-performance-innodb-buffers-directives/
innodb_buffer_pool_size = 16G

Run service mysql restart


Get real IP when behind Cloudflare

Edit /etc/nginx-rc/main-extra.conf

set_real_ip_from 173.245.48.0/20;
set_real_ip_from 103.21.244.0/22;
set_real_ip_from 103.22.200.0/22;
set_real_ip_from 103.31.4.0/22;
set_real_ip_from 141.101.64.0/18;
set_real_ip_from 108.162.192.0/18;
set_real_ip_from 190.93.240.0/20;
set_real_ip_from 188.114.96.0/20;
set_real_ip_from 197.234.240.0/22;
set_real_ip_from 198.41.128.0/17;
set_real_ip_from 162.158.0.0/15;
set_real_ip_from 104.16.0.0/13;
set_real_ip_from 104.24.0.0/14;
set_real_ip_from 172.64.0.0/13;
set_real_ip_from 131.0.72.0/22;
set_real_ip_from 2400:cb00::/32;
set_real_ip_from 2606:4700::/32;
set_real_ip_from 2803:f800::/32;
set_real_ip_from 2405:b500::/32;
set_real_ip_from 2405:8100::/32;
set_real_ip_from 2a06:98c0::/29;
set_real_ip_from 2c0f:f248::/32;
real_ip_header X-Forwarded-For;

Increase “Open Files Limit”

Tutorial: https://easyengine.io/tutorials/linux/increase-open-files-limit/
reboot is necessary.


PHP modules

apt install php74rc-pecl-imagick

systemctl reload php74rc-fpm

PHP config

Create /etc/php74rc/conf.d/z_additional.ini

memory_limit=-1

opcache.max_accelerated_files=1000000
opcache.memory_consumption=2048
opcache.interned_strings_buffer=256
opcache.max_wasted_percentage=20