MySQL InnoDB + MyISAM

Question

MySQL

Good day.

Actually a question whether it is normal to use various types of tables in one database?
What is the risk?

The need to use innoDB + MyISAM in one of the projects is that - you need full-text search + transactions and integrity constraints.

Perhaps there are more suitable subds for such a task, but one of the requirements is the use
of mySQL in the project.

Answer 1

And it is impossible to hang up full-text search on sphinx for example? And then all tables in innoDB.

Answer 2

Yes, you can safely use it without any problems.
A couple of rules for such systems (from personal experience):
- Do not make joint change requests. It is better to query each type of table separately.
- Linked field types must be exactly the same.
- For backup use save to dump. No copying of files is fraught with data corruption.

Answer 3

The search for truth is better to take out. In general, they can be used together, sometimes they do. Transactionality and foreign key checks will not spread to MyISAM, the rest will work.

Answer 4

There will be problems with transactions. rallback will work strangely: it will roll back only part of the changes - the part that was made in InnoDB. And that which in MyISAM will leave. Naturally, this will manifest itself not only on rallback, but it may manifest itself, for example, when the server crashes, when foreign keys do not have time to work, the transaction will be partially rolled back.

Answer 5

PostgreSQL + tsvector