I have a droplet on DigitalOcean, and i was using Mysql 5.5 with my ubuntu 14.04. Recently i switched to Percona (i used 5.5 as my mysql was 5.5). After replacing my mysql, i realized that my server was MyISAM instead of InnoDB.
I’ve read that MyISAM is not as good as InnoDB, and in my configuration i could see that Percona XtraBackup was not visible.
It should look like -
Engine: InnoDB Support: DEFAULT Comment: Percona-XtraDB, Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES
But it actually looks like -
Engine: MyISAM Support: YES Comment: MyISAM storage engine Transactions: NO XA: NO Savepoints: NO
As you can see, my configuration does not even support Transactions, which i dont feel very good about. But it seems Percona is actually running without XtraDB. Is this a bad thing? Any suggestions? Thanks!