ThingsBoard PE v3.1.x CentOS 升级说明

• 升级ThingsBoard前的准备工作
  • 备份数据库
    • PostgreSQL
    • Cassandra
  • 启动数据库
• Upgrading ThingsBoard PE to 3.1.1
  • ThingsBoard PE package download
  • ThingsBoard PE service upgrade
  • Start the service
• Upgrading ThingsBoard PE to 3.1
  • ThingsBoard PE package download
  • ThingsBoard PE service upgrade
  • Start the service

升级ThingsBoard前的准备工作

停止ThingsBoard 检查ThingsBoard及数据库服务是否在运行。 先停止ThingsBoard，检查状态确认已停止，再处理数据库。

1
sudo systemctl stop thingsboard

1
sudo systemctl status thingsboard

备份数据库

升级前请对数据库进行备份。

PostgreSQL

检查PostgreSQL状态。备份时无需停止PostgreSQL。

1
sudo systemctl status postgresql

请确保有足够的空间存放数据库备份 检查数据库大小

1
sudo -u postgres psql -c "SELECT pg_size_pretty( pg_database_size('thingsboard') );"

检查可用空间

1
df -h /

如有足够可用空间，可执行备份。

1
sudo -Hiu postgres pg_dump thingsboard > thingsboard.sql.bak

确认备份文件已创建。

Cassandra

检查Cassandra状态。备份Cassandra需先停止服务。

1
sudo systemctl status cassandra

将所有memtable从节点刷新到磁盘上的SSTable。

1
nodetool drain

停止Cassandra。

1
sudo systemctl stop cassandra

需再次检查状态以确认已完全停止。

1
sudo systemctl status cassandra

请确保有足够的空间存放数据库备份 检查数据库大小。

1
du -h /var/lib/cassandra/ | tail -1

检查可用空间。

1
df -h /

执行Cassandra数据库备份。

1
2
mkdir backup
sudo tar -cvf backup/cassandra.tar /var/lib/cassandra

确认归档是否正在创建

启动数据库

Cassandra

1
sudo systemctl start cassandra

PostgreSQL 无需操作，PostgreSQL已在运行。

Upgrading ThingsBoard PE to 3.1.1

NOTE: These upgrade steps are applicable for ThingsBoard version 3.1PE. In order to upgrade to 3.1.1PE you need to upgrade to 3.1PE first. Prepare for upgrading ThingsBoard.

ThingsBoard PE package download

1
wget https://dist.thingsboard.io/thingsboard-3.1.1pe.rpm

ThingsBoard PE service upgrade

• Stop ThingsBoard service if it is running.

1
sudo service thingsboard stop

• Install Thingsboard Web Report component as described here.

1
sudo rpm -Uvh thingsboard-3.1.1pe.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.ts.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:

1
2
3
4
database:
  ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
  ts:
    type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)

Execute regular upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.1.0

Start the service

若将 Redis 用于缓存，在启动 ThingsBoard 前需清空所有已存储的 key。

连接到您的 Redis 实例（或 container/pod，视部署方式而定），执行：

redis-cli flushall

注意：仅当 Redis 专门用于 ThingsBoard 时可使用此命令。若其他应用也使用 Redis，需定位 ThingsBoard 使用的数据库并仅清空该库。默认数据库 index 为 0，可通过 ThingsBoard 环境变量 REDIS_DB 配置。

redis-cli

select 0

flushdb

1
sudo service thingsboard start

Upgrading ThingsBoard PE to 3.1

NOTE: These upgrade steps are applicable for ThingsBoard version 3.0.1PE. In order to upgrade to 3.1PE you need to upgrade to 3.0.1PE first. Prepare for upgrading ThingsBoard.

ThingsBoard PE package download

1
wget https://dist.thingsboard.io/thingsboard-3.1pe.rpm

ThingsBoard PE service upgrade

• Stop ThingsBoard service if it is running.

1
sudo service thingsboard stop

• Install Thingsboard Web Report component as described here.

1
sudo rpm -Uvh thingsboard-3.1pe.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.ts.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” if you are using Cassandra database for timeseries data:

1
2
3
4
database:
  ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
  ts:
    type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)

NOTE: Cassandra database does not support advanced filters. If you were using Cassandra database for timeseries data please make sure that database.ts_latest.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) is “sql”:

1
2
3
4
database:
...
  ts_latest:
    type: "${DATABASE_TS_LATEST_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)

and execute the following migration script:

1
2
# Execute script to migrate latest timeseries data from Cassandra to PostgreSQL
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=cassandra-latest-to-postgres

Execute regular upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=3.0.1

Start the service

若将 Redis 用于缓存，在启动 ThingsBoard 前需清空所有已存储的 key。

连接到您的 Redis 实例（或 container/pod，视部署方式而定），执行：

redis-cli flushall

注意：仅当 Redis 专门用于 ThingsBoard 时可使用此命令。若其他应用也使用 Redis，需定位 ThingsBoard 使用的数据库并仅清空该库。默认数据库 index 为 0，可通过 ThingsBoard 环境变量 REDIS_DB 配置。

redis-cli

select 0

flushdb

1
sudo service thingsboard start