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 &
Last updated