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

• 升级ThingsBoard前的准备工作
  • 备份数据库
    • PostgreSQL
    • Cassandra
  • 启动数据库
• Upgrading ThingsBoard PE to 3.0.1
  • ThingsBoard PE package download
  • ThingsBoard PE service upgrade
  • Start the service
• Upgrading ThingsBoard PE to 3.0
  • 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.0.1

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

升级至 ThingsBoard 3.0 前的重要提示

• ThingsBoard UI 已从 AngularJS 1.5.8 重写为 Angular 9。
  • 这意味着什么？
    • 概括而言，意味着：现代化应用、更易开发前端元素、性能提升以及 UI 定制更灵活。
  • 如何升级？
    • 若您不在仪表盘中使用自定义部件或自定义操作，可安全升级。
    • 新的 JS 框架可能不完全支持您当前的代码（自定义部件和自定义操作），需稍作重构。因此建议您使用我们的云环境或开发实例测试您的定制内容。
• 从纯 Cassandra 迁移至混合数据库方案
  • 我们仍支持 Cassandra 存储遥测数据，但不再用于存储设备、客户、租户等实体。
  • 这意味着什么？
    • 这将简化维护和未来改进，并将在 v3.1 中支持高级搜索能力。
  • 如何升级？
    • 若您使用纯 PostgreSQL 或 PostgreSQL（实体）+ Cassandra（遥测），则不受影响。
    • 若您使用纯 Cassandra，升级过程将自动执行但需一定时间。停机时间取决于设备、属性、告警和关系的数量。 若上述实体少于 1000 万，升级通常仅需数分钟，具体取决于数据库性能。

Since ThingsBoard 3.0PE only PostgreSQL database is supported for entities data

• If you are using Cassandra database for entities data please install PostgreSQL database before proceeding upgrade procedure using the following guide:
  • PostgreSQL Installation on Ubuntu
  • PostgreSQL Installation on CentOS/RHEL

ThingsBoard PE package download

1
wget https://dist.thingsboard.io/thingsboard-3.0.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.0.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: If you were using Cassandra database for entities data execute the following migration script:

1
2
# Execute migration script from Cassandra to PostgreSQL
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.5.0PE-cassandra

Otherwise execute regular upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.5.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.0

Since ThingsBoard 3.0PE only PostgreSQL database is supported for entities data

• If you are using Cassandra database for entities data please install PostgreSQL database before proceeding upgrade procedure using the following guide:
  • PostgreSQL Installation on Ubuntu
  • PostgreSQL Installation on CentOS/RHEL

Prepare for upgrading ThingsBoard.

ThingsBoard PE package download

1
wget https://dist.thingsboard.io/thingsboard-3.0pe.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.0pe.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: If you were using Cassandra database for entities data execute the following migration script:

1
2
# Execute migration script from Cassandra to PostgreSQL
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.5.0PE-cassandra

Otherwise execute regular upgrade script:

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

Start the service

1
sudo service thingsboard start

下一步

• 快速入门指南 - 快速了解ThingsBoard主要功能，约15-30分钟完成。

• 连接设备 - 根据连接技术或方案学习如何连接设备。

• 数据可视化 - 配置ThingsBoard复杂仪表盘的说明。

• 数据处理与操作 - 学习使用ThingsBoard规则引擎。

• IoT数据分析 - 学习使用规则引擎执行基本分析任务。

• 高级功能 - 了解ThingsBoard高级功能。

• 贡献与开发 - 了解ThingsBoard贡献与开发。