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)

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 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/