[MDEV-27986] Galera testing of ALTER ONLINE TABLE Created: 2022-03-03  Updated: 2023-03-20  Resolved: 2023-03-20

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Galera
Fix Version/s: 11.1.0

Type: Task Priority: Critical
Reporter: Jan Lindström (Inactive) Assignee: Ramesh Sivaraman
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-28810 Test MDEV-16329 (ALTER ONLINE TABLE) ... Closed
PartOf
is part of MDEV-16329 Engine-independent online ALTER TABLE Closed
Relates
relates to MDEV-28808 Test MDEV-16329 (ALTER ONLINE TABLE) ... Stalled
relates to MDEV-28809 Test MDEV-16329 (ALTER ONLINE TABLE) ... Closed

 Description   

Galera has few different online schema upgrade methods (wsrep_osu_method). In this task all of the should be tested with ALTER ONLINE TABLE i.e. TOI, RSU and NBO. Furthermore, Galera can replicate ALTER to MyISAM and Aria tables using TOI.

Test topologies:

  • master <--> slave galera cluster
  • mariadb master ----> galera cluster as slave
  • galera cluster as master -----> mariadb slave
  • multimaster galera cluster

Tests should contain both

  • non-conflicting ALTERs (i.e. to different tables from multiple-threads/nodes)
  • conflicting ALTERs (i.e. to same table but different ALTER from multiple-threads/nodes)
  • ALTERs to tables that have parent i.e. foreign key references
  • Master(s) should have also other simple load

<fil more details if needed>



 Comments   
Comment by Elena Stepanova [ 2022-06-21 ]

New branch for testing: bb-10.10-MDEV-16329

Comment by Ramesh Sivaraman [ 2023-03-20 ]

okay to push

Generated at Thu Feb 08 09:57:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.