1
I have an application that is in a hosting that does not support me the storage mechanism Innodb, therefore, I am at the mercy of the use of Myisam.
There is a secure alternative to using transactions in a database with the type of Myisam mechanism?
2
Not by a long shot. You can make a complex mechanism in the application to try to simulate this, but it’s extremely difficult to do it right, it takes a lot of work, you’ll have a huge loss of performance and an even bigger problem at hand.
There is a simple solution: change hosting.
Before you think if you really need the transactions. Not always it is so necessary, the use without is not as tragic as they say, only it is not 100%.
Or switch to Sqlite that has transactions, is simpler and performative (I just don’t know if it solves everything you need).
Browser other questions tagged mysql database transactions
You are not signed in. Login or sign up in order to post.