Dear Customers,
We're going to upgrade current MariaDB SQL server from version 10.2.x to 10.3.x. Data bases may appear down for about 5-10 minutes between 10-11 PM EST on August 25th, 2019.
Upgrade will bring numerous performance improvements for high-concurrency load and performance data structures. Scalability and performance improvements to global data structures. The Information Schema will use much less memory when you select from INFORMATION_SCHEMA.TABLES or any other table with many VARCHAR or TEXT columns.
Changes in data bases structure:
1. In MariaDB 10.3, the mysqldump client includes logic for the mysql.transaction_registry table. You cannot use the mysqldump client from an earlier MariaDB release on MariaDB 10.3 and later. More information can be found on MariaDB website: https://mariadb.com/kb/en/library/upgrading-from-mariadb-102-to-mariadb-103/#major-new-features-to-consider
2. MariaDB enables "strict mode" by default as of version 10.2. Strict mode controls how MariaDB and MySQL handle invalid or missing values in data-change statements such as INSERT or UPDATE. Applications not built with strict mode enabled may cause undesired behavior; please verify applications using MariaDB are compatible before upgrading. More information can be found on cPanel website: https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-strict
Please note: This upgrade is a part of major software and hardware upgrades. After we complete preliminary upgrade tasks, we'll move accounts to different server with new processor, memory and SSD/NVME disks. We'll schedule this transfer for next weekend (08/31/19 - 09/01/19).
Thank you for your patience.
WestNIC Staff