phinx [2323] Add Native Support for ALGORITHM=INSTANT in Migrations for MYSQL

Fix for the issue - https://github.com/cakephp/phinx/issues/2323 Original fix - https://github.com/cakephp/migrations/pull/955/files

Also changed version of PHP for Docker because project requires min 8.1 but there is 7.3 in the container

Dec 03 '25 23:12 lutdev

[x] Fix tests

Dec 04 '25 08:12 lutdev

I'm not super familiar with this feature of mysql, but could you set the algorithm and lock for other operations when altering a table, like adding or removing an index?

Dec 04 '25 16:12 MasterOdin

I'm not super familiar with this feature of mysql, but could you set the algorithm and lock for other operations when altering a table, like adding or removing an index?

for most of operations, only "In Place" algorithm takes place) https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html So, I think it's not possible to set an algorithm for such kind of operations. For example, I need it only when need to modify column. And without migrations it's a bit painful :D

Dec 04 '25 21:12 lutdev