Upgrade

Ophidia primitives:

1 Update rpm:

yum update ophidia-primitives

2 Copy primitives to MySQL plugin path:

cp /usr/local/ophidia/oph-cluster/oph-primitives/lib/liboph_*.so /usr/lib64/mysql/plugin

3 Reload primitives into MySQL server:

mysql -u root -p mysql < /usr/local/ophidia/oph-cluster/oph-primitives/etc/create_func.sql

Ophidia terminal:

1 Update rpm:

yum update ophidia-terminal

Ophidia analytics framework:

1 Backup configuration files:

mv /usr/local/ophidia/oph-cluster/oph-analytics-framework/etc/oph_configuration /usr/local/ophidia/oph-cluster/oph-analytics-framework/etc/oph_configuration.bak

mv /usr/local/ophidia/oph-cluster/oph-analytics-framework/etc/oph_dim_configuration /usr/local/ophidia/oph-cluster/oph-analytics-framework/etc/oph_dim_configuration.bak

2 Update rpm:

yum update ophidia-analytics-framework

3 Overwrite the conf files with the previous ones:

cp /usr/local/ophidia/oph-cluster/oph-analytics-framework/etc/oph_configuration.bak /usr/local/ophidia/oph-cluster/oph-analytics-framework/etc/oph_configuration

Replace argument names listed in /usr/local/ophidia/oph-cluster/oph-analytics-framework/etc/oph_configuration according to the following mapping:

MAPPER_DB_NAME becomes OPHDB_NAME

MAPPERDB_HOST becomes OPHDB_HOST

MAPPERDB_PORT becomes OPHDB_PORT

MAPPERDB_LOGIN becomes OPHDB_LOGIN

MAPPERDB_PWD becomes OPHDB_PWD

Append the following parameters to /usr/local/ophidia/oph-cluster/oph-analytics-framework/etc/oph_configuration and set them to corresponding arguments in /usr/local/ophidia/oph-cluster/oph-analytics-framework/etc/oph_dim_configuration.bak

MAPPER_DB_NAME in oph_dim_configuration becomes DIMDB_NAME in oph_configuration

MAPPERDB_HOST in oph_dim_configuration becomes DIMDB_HOST in oph_configuration

MAPPERDB_PORT in oph_dim_configuration becomes DIMDB_PORT in oph_configuration

MAPPERDB_LOGIN in oph_dim_configuration becomes DIMDB_LOGIN in oph_configuration

MAPPERDB_PWD in oph_dim_configuration becomes DIMDB_PWD in oph_configuration

4 Create /data/repository and update /usr/local/ophidia/oph-cluster/oph-analytics-framework/etc/oph_configuration file adding: BASE_SRC_PATH=/data/repository

5 Remove old databases from MySQL:

mysql -u root -p -e "drop ophidiadb;"

mysql -u root -p -e "drop oph_dimensions;"

for k in $(mysql -u root -p -e "show databases;" | grep “dbophidiadb"); do mysql -u root -p -e “drop database $k;" done

6 Reload databases (adapt the password accordingly):

mysql -u root -p -e "create database ophidiadb;"

mysql -u root -p -e "create database oph_dimensions;"

mysql -u root -p ophidiadb < /usr/local/ophidia/oph-cluster/oph-analytics-framework/etc/ophidiadb.sql

mysql -u root -p ophidiadb -e "INSERT INTO host (hostname, cores, memory) VALUES ('127.0.0.1', 1, 1);"

mysql -u root -p ophidiadb -e "INSERT INTO dbmsinstance (idhost, login, password, port) VALUES (1, 'root', '[password]', 3306);"

mysql -u root -p ophidiadb -e "INSERT INTO hostpartition (partitionname) VALUES ('test');"

mysql -u root -p ophidiadb -e "INSERT INTO hashost (idhostpartition, idhost) VALUES (1,1);"

Ophidia server

1 Backup configuration files:

mv /usr/local/ophidia/oph-server/etc/ophidiadb.conf /usr/local/ophidia/oph-server/etc/ophidiadb.conf.bak

mv /usr/local/ophidia/oph-server/etc/server.conf /usr/local/ophidia/oph-server/etc/server.conf.bak

2 Update rpm: yum update ophidia-server

3 Overwrite the conf files with the previous ones:

cp /usr/local/ophidia/oph-server/etc/ophidiadb.conf.bak /usr/local/ophidia/oph-server/etc/ophidiadb.conf

Replace argument names listed in /usr/local/ophidia/oph-server/etc/ophidiadb.conf according to the following mapping:

MAPPER_DB_NAME becomes OPHDB_NAME

MAPPERDB_HOST becomes OPHDB_HOST

MAPPERDB_PORT becomes OPHDB_PORT

MAPPERDB_LOGIN becomes OPHDB_LOGIN

MAPPERDB_PWD becomes OPHDB_PWD

cp /usr/local/ophidia/oph-server/etc/server.conf.bak /usr/local/ophidia/oph-server/etc/server.conf

Drop the lines related to the following arguments (if present):

POLL_TIME

BASE_BACKOFF

4 Check oph_server process pid and kill the process.

5 Restart the server: /usr/local/ophidia/oph-server/bin/oph_server > /dev/null 2>&1 &