maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #06516
MariaDB Online-DDL
-
To:
<maria-discuss@xxxxxxxxxxxxxxxxxxx>
-
From:
<Rhys.Campbell@xxxxxxxxxxxx>
-
Date:
Fri, 17 Mar 2023 10:47:56 +0000
-
Accept-language:
de-DE, en-US
-
Arc-authentication-results:
i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=swisscom.com; dmarc=pass action=none header.from=swisscom.com; dkim=pass header.d=swisscom.com; arc=none
-
Arc-message-signature:
i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=PgkEEkBVs1nkUy7sTvJFj3ndkdrYiyN9d5TvduPtN1w=; b=oCsBnUzx8Kz8OQsCNwZmkgcdItHz27FOt3nD+9XetxiyjgnplQmmXew2swc49OEN9vG9kTNGyoCuyImJ+PUbxKkr9HIgxJCDa8S8pPhJb9rwojByu/kdpTh5taw/BuHUcY3+WVUe8aVuzPeNotwpnfIYJCXd9IZWrjIawpyG2eiXZ59QqPrPvpiXL5Cp3qt8PNvzTIHKqHXq+P1kT8W5iXJhis3dPGPmYsyYHWZOcQ+G+ADGReaS8kJnswZAgMObfK5Q10rXV/LgRtsMx5ltajxlQx3Q01+9deL/fP9CJrcSxGShOJ7vqMhW4gXQabEfK+ju2wCnjX5sP9BpROM17A==
-
Arc-seal:
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=cuAefQYtiUyheJL9wKHHOl/8pIFIhhTuBYqLFShBR4tatvTa5JTtvvTSGdUy8jkgN0pnwFxsvLQHu/WevU8jEtPAFiUYwIjbU3eks2p4zvylpmjYAr6KJCQVbz0sajH5rTbyTTzPUgqQqRqIC6bLfJVpsLlp/EzB/4rrIZyCryaV7ru+Y7l+io2cdLZj3db+YT+DTFdOVNAxefDibi8vKJIxoaIXpMBmruvmuaTlCbUxLkIglN5JQD9vg2lut0YtLyudRYfOnCxTuZSTZpEccvH1TSQh+3NsttUOW1VorzqNgqzOWDvTRtwA09EKN4Au9zDQ4L4cvEIwvuh3seLxHA==
-
Authentication-results:
dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=swisscom.com;
-
Msip_labels:
MSIP_Label_2e1fccfb-80ca-4fe1-a574-1516544edb53_Enabled=true; MSIP_Label_2e1fccfb-80ca-4fe1-a574-1516544edb53_SetDate=2023-03-17T10:47:54Z; MSIP_Label_2e1fccfb-80ca-4fe1-a574-1516544edb53_Method=Standard; MSIP_Label_2e1fccfb-80ca-4fe1-a574-1516544edb53_Name=C2 Internal; MSIP_Label_2e1fccfb-80ca-4fe1-a574-1516544edb53_SiteId=364e5b87-c1c7-420d-9bee-c35d19b557a1; MSIP_Label_2e1fccfb-80ca-4fe1-a574-1516544edb53_ActionId=216bd240-5c99-41e0-9885-c2e7c23cd2bc; MSIP_Label_2e1fccfb-80ca-4fe1-a574-1516544edb53_ContentBits=0
-
Thread-index:
AdlYvT/PhzxRa0B+RwKimTYmEkmCBA==
-
Thread-topic:
MariaDB Online-DDL
Hello All,
I'm back working with MariaDB again after a break of some years. While InnoDB Online-DDL had appeared when I was working with it, it was still sometimes a challenge to manage schema changes for very large tables.
https://mariadb.com/kb/en/innodb-online-ddl-overview/
Can anyone summarize how InnoDB stacks up for Online-DDL now?
Is it comparable to MSSQL (which I found to be pretty good for tables in the many tens of GB)?
Are workarounds like pt-online-schema-change and blue/green deployments still required? Are there any specific areas to watch out for?
Any feedback appreciated.
Cheers,
Rhys
Follow ups
