Article ID: 119556, created on Jan 10, 2014, last review on Dec 27, 2016

  • Applies to:
  • Odin Business Automation Standard 4.5

Symptoms

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?

Resolution

  1. Create a container with 64-bit OS, install the latest available MySQL 5.0.xx template.

  2. Stop OBAS and all of its services (hspcd, httpd, pdns, pdns_recursor, postfix, servicemon, taskmand, vzcoll).

  3. Migrate all MySQL databases (not only aspc) to new container with built-in MySQL tools mysqldump and mysql (important).

  4. Reconfigure IPs, services runlevel, firewall, etc. on new 64-bit container, verify access from OBAS.

  5. Start the main OBAS services (hspcd, httpd), validate PCC/CP/Store.

  6. Start the rest of OBAS services (pdns, pdns_recursor, postfix, servicemon, taskmand, vzcoll), validate PCC/tasks/DNS/Email.

Important notes

Before doing that, read the following documentation:

Upgrading MySQL

mysql_upgrade — Check Tables for MySQL Upgrade

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.

Additional information

How to upgrade OBAS database to MySQL 5.0

Move OBAS database to separate server (MySQL5)

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 70a5401e8b9354cd1d64d0346f2c4a3e 624ca542e40215e6f1d39170d8e7ec75

Email subscription for changes to this article
Save as PDF