Version 5 (modified by ibaldin, 5 years ago)

--

Notes on ORCA Eastsound 5.0

Migration Notes

ORCA 5.0 requires that MySQL be modified - table structure and limits need to be changed. The full.schema.sql has already been modified (for creating new tables). The existing tables can be modified using the script below.

First you have to change the /etc/my.cnf file:

Under the [mysqld] section add this line:

max_allowed_packet=32M

Also, you need to change the schemas for both mysql databases (for both containers) to change shirakoproperties column type from 'text' to 'largetext'. Save this as a script script.sql:

alter table Actors modify shirakoproperties longtext;
alter table Clients modify shirakoproperties longtext;
alter table ConfigMappings  modify shirakoproperties longtext;
alter table Inventory  modify shirakoproperties longtext;
alter table ManagerObjects modify shirakoproperties longtext;
alter table Miscellaneous modify shirakoproperties longtext;
alter table Packages modify shirakoproperties longtext;
alter table Plugins modify shirakoproperties longtext;
alter table Proxies modify shirakoproperties longtext;
alter table Reservations modify shirakoproperties longtext;
alter table Slices modify shirakoproperties longtext;
alter table Units modify shirakoproperties longtext;
alter table Users modify shirakoproperties longtext;

And then run it like this (for the two databases):

mysql -u orca -p orca12080 < script.sql mysql -u orca -o orca14080 < script.sql

CouchDB

ORCA 5.0 includes integration with CouchDB to support the actor registry. The code for CouchDB is located here.