• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Upgrade to Percona Server on a Plesk Server or VPS

Slavik

XenForo moderator
Staff member
#1
Slavik submitted a new resource:

Upgrade to Percona Server on a Plesk Server or VPS - Supercharge your XenForo Board by installing Percona Server on Plesk

WARNING: AT THE TIME OF WRITING THIS GUIDE IS CONSIDERED HIGHLY EXPERIMENTAL. AS FAR AS I KNOW, P8NTBALLER IS THE ONLY PRODUCTION SITE IN THE WORLD RUNNING PLESK ON PERCONA.

THIS GUIDE REQUIRES PLESK 11.5 OR HIGHER. LOWER VERSIONS OF PLESK WILL BREAK IF YOU ATTEMPT THESE STEPS.

FULL DATABASE BACKUPS SHOULD BE TAKEN AND THESE STEPS SHOULD ONLY BE UNDERTAKEN BY SERVER ADMINS COMFORTABLE WITH MAKING THESE ALTERATIONS AND WHO UNDERSTAND THE FULL RISKS OF THE FOLLOWING GUIDE.

---

This guide...
Read more about this resource...
 

Marcus

Well-known member
#4
You may have to add these steps as my.cnf is not included within Pecona releases (yet):

1. create /etc/my.cnf with the right values (https://tools.percona.com/wizard/)
2. rename /var/lib/mysql/ib_logfile* files if you change innodb_log_file_size to a different file size than these files.Without the right file size, Pecona won't start. If Pecona can not find these fields, it creates it on its own. There may be problems with the caching system if you just change the files, I don't know more about that.
3. "/etc/init.d/mysql restart"
 
Last edited:

Marcus

Well-known member
#6
That helped :) I have 64 GB RAM for my community server. Pecona set the value to 54G but what do you think? Is it more useful to add cache to nginx or PHP? It's not my expertise field.
 

Marcus

Well-known member
#7
with outcommenting
PHP:
#sql_mode  = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
its still slow :/
PHP:
INSERT INTO xf_session_activity (user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE ip = VALUES(ip), controller_name = VALUES(controller_name), controller_action = VALUES(controller_action), view_state = VALUES(view_state), params = VALUES(params), view_date = VALUES(view_date), robot_key = VALUES(robot_key)
Params: 117, 117, 1556707374, XenForo_ControllerPublic_Forum, Index, valid, node_name=, 1376824387,
Run Time: 0.109770
 

Marcus

Well-known member
#9
Outcommenting like this helped :)
PHP:
# BINARY LOGGING #
#log_bin  = /var/lib/mysql/mysql-bin
#expire_logs_days  = 14
#sync_binlog  = 1
 

Slavik

XenForo moderator
Staff member
#10
I cant remember the exact setting now, but if your OS filesystem is ACID complient, enabling strict synced logging takes a massive effect.