We run PBA-S version 4.3 or 4.5 and MySQL server on a separate container. To improve MySQL performance I would like to migrate MySQL server to 64-bit system. How to do this the best way?
Create a container with 64-bit OS, install the latest available MySQL 5.0.xx template.
Stop PBA-S and all its services (hspcd, httpd, pdns, pdns_recursor, postfix, servicemon, taskmand, vzcoll).
Migrate all MySQL databases (not only aspc) to new container with built-in MySQL tools mysqldump and mysql (important).
Reconfigure IPs, services runlevel, firewall, etc. on new 64-bit container, verify access from PBA-S.
Start main PBA-S services (hspcd, httpd), validate PCC/CP/Store.
- Start the rest of PBA-S services (pdns, pdns_recursor, postfix, servicemon, taskmand, vzcoll), validate PCC/tasks/DNS/Email.
Before doing that, read the following documentation:
Upgrade to MySQL 5.1.xx within PBAS 4.3.x is not recommended. After upgrade to PBAS 4.5 you can upgrade MySQL to latest available template of MySQL 5.1.xx. Before processing please read Upgrading MySQL.
Upgrade to further versions of MySQL, i.e. 5.5.xx, 5.7.xx is not recommended as well both for PBAS 4.3.x and PBAS 4.5.