search

magento / architecture

A place where Magento architectural discussions happen
275 stars 155 forks source link

MC-21637: Adds proposal for refactoring of product import #324

Open jean-bernard-valentaten opened 4 years ago

jean-bernard-valentaten commented 4 years ago

Problem

Product import currently relies on MySQL AUTO_INCREMENT which leads to issues when using MySQL 8

Solution

Either make use of a construct similar to sequences or change primary key to use UUIDs instead of a serial key

Requested Reviewers

@paliarush @akaplya

buskamuza commented 4 years ago

MySQL article about UUIDs https://mysqlserverteam.com/storing-uuid-values-in-mysql-tables/