CODEWITHSUNDEEP
yii2mysql-cluster
Deena Samy
Deena Samy

Reputation: 503

Connect Yii2 app to My sql cluster

Does it makes any different if I was using mysql db and now I want to use Mysql cluster on my server. How will this affect my yii2 application ?? do I have to make any changes to db connection or just connect to any node ? does this affect Active Queries ?? Does it affect the active model relations ??

Thanks in advance.

Upvotes: 0

Views: 196

Answers (1)

Bizley
Bizley

Reputation: 18021

You need to carefully read Known Limitations of NDB Cluster section in the MySQL docs.

Most important parts are:

  • column width limit for indexation,
  • TEXT and BLOB cannot be indexed,
  • BIT column cannot be a primary key, unique key, or index, nor can it be part of a composite primary key, unique key, or index,
  • you cannot have table with AUTO_INCREMENT column and no explicit primary key,
  • only READ COMMITTED transaction isolation level,
  • foreign keys are supported only in NDB Cluster 7.3 and later.

AR implementation in Yii 2 should be basically fine. You connect in the same way as usual.

Upvotes: 1

Related Questions