Comments on: Impact of DDL Operations on Aurora MySQL Readers https://www.percona.com/blog/impact-of-ddl-operations-on-aurora-mysql-readers/ Wed, 31 Jan 2024 22:31:01 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Sam https://www.percona.com/blog/impact-of-ddl-operations-on-aurora-mysql-readers/#comment-10974159 Sat, 09 Sep 2023 17:25:12 +0000 https://www.percona.com/blog/?p=84234#comment-10974159 This is not a satisfactory behaviour of this cloud vendor product. Moreover, you have mentioned that in classic mysql, metadata lock has been taken during alter which is not correct. It has been taken only during the beginning and ending of the statement. This is to capture the snapshot and have consistent alter.

]]>
By: Vivek Buddhadev https://www.percona.com/blog/impact-of-ddl-operations-on-aurora-mysql-readers/#comment-10973911 Tue, 07 Feb 2023 05:32:59 +0000 https://www.percona.com/blog/?p=84234#comment-10973911 Thanks for the detailed explanation. It’s usefull.

]]>
By: Prakash Sharma https://www.percona.com/blog/impact-of-ddl-operations-on-aurora-mysql-readers/#comment-10973882 Tue, 03 Jan 2023 08:53:08 +0000 https://www.percona.com/blog/?p=84234#comment-10973882 Good Blog to know about Aurora Replica’s behavior.

]]>
By: Rahul https://www.percona.com/blog/impact-of-ddl-operations-on-aurora-mysql-readers/#comment-10973881 Mon, 02 Jan 2023 07:05:32 +0000 https://www.percona.com/blog/?p=84234#comment-10973881 Interesting, do you have insight if the behavior is same in earlier Aurora versions i.e. 1.x nd 2.x ?

]]>