MyISAM and Innodb

adamtang · Post by **adamtang** » 11 May 2023, 15:21

Hi, I'm new. My hosting mysql default is MyISAM. Will it cause issues? Does Aimeos needs Innodb?

Post by **aimeos** » 11 May 2023, 15:36

Guess, that won't work out of the box. The Aimeos tables are all enforced as InnoDB but the Laravel "users" table is not AFAIK. Thus, you have to change the "users" table from MyISAM to InnoDB first before you install Aimeos.

adamtang · Post by **adamtang** » 11 May 2023, 16:54

aimeos wrote: ↑11 May 2023, 15:36 Guess, that won't work out of the box. The Aimeos tables are all enforced as InnoDB but the Laravel "users" table is not AFAIK. Thus, you have to change the "users" table from MyISAM to InnoDB first before you install Aimeos.

Hi Admin, just a side question. I assume Aimeos's default db is MySQL or Mariadb? Mariadb should be better right? Also, alot of open source project default to PostgreSQL. Mariadb/MySQL or Postgresql?

I'm planning for database server. What do you recommend?

Post by **aimeos** » 12 May 2023, 07:25

Aimeos supports MySQL/MariaDB, PostgreSQL and MS SQL Server. MySQL or MariaDB is most often used and are usually the fastest systems.

Help for Aimeos