What is Instant Alter ? What is MariaDB ?

B Ashok
Tera Guru

‎09-12-2022 02:21 AM

Hi Team, 

We have received the below notification : 

ServiceNow will perform maintenance on production and sub-production instances with secondary databases to ensure the system property glide.db.instant_alter.enabled exists and is set to "false".  This maintenance will ensure that the database does not default to instant alter over online alter, and replication will not break when writing from MariaDB v10.4 to v10.2.

Can you please help me What is Instant Alter? What is MariaDB ?

Thanks

0 Helpfuls
  • 2,003 Views
2 REPLIES 2

Mark Manders
Mega Patron

‎09-12-2022 02:48 AM

Best way to get a clear answer on this, is to go to the source: you can reply to this ServiceNow case with these questions.

If my answer helped you in any way, please then mark it as helpful. If it resolved the issue, please mark it as correct. This way others will find it in the solved queue and helps them on similar queries.

Mark


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
0 Helpfuls

Minh Huy Lam Qu
Giga Sage

‎01-10-2024 07:09 PM

Hello @B Ashok 

What is Instant Alter?

=> The benefits of this feature allow for database columns to be added instantly, improving performance when modifying ServiceNow tables during family release upgrades or normal platform operations.

 

What is MariaDB?

=> ServiceNow instance use MariaDB for the database layer (MariaDB is another version of MySQL).

For more information you can refer to this KB: Enabling Instant Alter Functionality on Eligible Instances - Known Error (servicenow.com)

 

Regards,

Huy Lam