OS/Software update information for Device(DB Server)

• Added information about MySQL database server for CNS Personal Homepage. (2025/1/8)
• Added information about MySQL database server for CNS Public Work Area. (2025/2/27)
• Added information about PostgreSQL database server. (2025/8/27)

CNS Personal Homepage DB Server "webdb" / CNS Public Work Area DB Server "webpubdb" Specification

MySQL

Device Update Date

• CNS Personal Homepage MySQL DB Server "webdb"
  • From 9:30, February 4(Tuesday), 2025.
• CNS Public Work Area MySQL DB Server "webpubdb"
  • From 8:00, March 13(Thursday), 2025.

OS Changes

The information below is the same for CNS Personal Homepage MySQL DB Server and CNS Public Work Area MySQL DB Server.

MySQL Changes

The information below is the same for CNS Personal Homepage MySQL DB Server and CNS Public Work Area MySQL DB Server.

• Tables whose storage engine was MyISAM will be changed to InnoDB.
• The options required for backup using the mysqldump command are added.
  • When executing the mysqldump command, add the following options: --set-gtid-purged=OFF --no-tablespaces.
  • Example (CNS Personal Homepage MySQL DB Server)

    % mysqldump -u [USER NAME] -p [DATABASE NAME] -h webdb --set-gtid-purged=OFF --no-tablespaces > [FILE NAME].sql
    

  • Example (CNS Public Work Area MySQL DB Server)

    % mysqldump -u [USER NAME] -p [DATABASE NAME] -h webpubdb --set-gtid-purged=OFF --no-tablespaces > [FILE NAME].sql
    

• Due to the requirements of the Group Replication feature used for server redundancy, the following tables will no longer be supported.
  • Tables without a PRIMARY KEY
  • Tables with foreign key constraints of CASCADE, SET NULL, or SET DEFAULT
  • Tables with a storage engine other than InnoDB

For more information about MySQL 8.4, see the MySQL 8.4 Reference Manual:
https://dev.mysql.com/doc/refman/8.4/en/

PostgreSQL

Device Update Date

• CNS Personal Homepage PostgreSQL DB Server "webdb"
  • From 9:30, September 10(Wednesday), 2025.
• CNS Public Work Area PostgreSQL DB Server "webpubdb"
  • From 13:30, September 10(Wednesday), 2025.

OS Changes

The information below is the same for CNS Personal Homepage PostgreSQL DB Server and CNS Public Work Area PostgreSQL DB Server.

PostgreSQL Changes

The information below is the same for CNS Personal Homepage PostgreSQL DB Server and CNS Public Work Area PostgreSQL DB Server.

For more information about PostgreSQL 17.5, see the PostgreSQL 17.5 Documentation:
https://www.postgresql.org/docs/17/index.html