We run OBAS version 4.3 or 4.5 and MySQL server is on a separate container. To improve MySQL performance we would like to migrate MySQL server to 64-bit system. What is the best way to do this?
Create a container with 64-bit OS, install the latest available MySQL 5.0.xx template.
Stop OBAS and all of 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 OBAS.
Start the main OBAS services (hspcd, httpd), validate PCC/CP/Store.
- Start the rest of OBAS 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 OBAS 4.3.x is not recommended. After upgrade to OBAS 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 OBAS 4.3.x and OBAS 4.5.