XtraDB

[Gabriel Torres]

Hi guys,

I've just upgraded to Percona (thanks all for the suggestion), and I was just wondering how to upgrade to XtraDB. From what I understood, on Percona, InnoDB is automatically replaced with XtraDB, as we can check with SHOW ENGINES;, so no extra step is required to use XtraDB.

Can someone confirm this?

Thanks,

Gabriel.

[p4guru]

Percona XtraDB = InnoDB :)

[Makoto]

As long as you see XtraDB is loaded with SHOW ENGINES,

+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                    | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+

You're using XtraDB. It should be loaded by default.

[Gabriel Torres]

Thanks for the confirmation, guys!

[xtech]

Hi guys,

I've just upgraded to Percona (thanks all for the suggestion), and I was just wondering how to upgrade to XtraDB. From what I understood, on Percona, InnoDB is automatically replaced with XtraDB, as we can check with SHOW ENGINES;, so no extra step is required to use XtraDB.

Can someone confirm this?

Thanks,

Gabriel.

Gabriel, do you confirm the performance improvement with percona?

[Gabriel Torres]

xtech, too soon to say, as I made this move during the weekend, when our traffic is very low. I should have a better opinion by the end of the week. However, I've seen an improvement for DB-intensive tasks, such as searching for a specific item using the mysql console.

[xtech]

Nice! I am also considering move to percona in a near future.

[Makoto]

I've definitely seen a lot of performance benefits when migrating from MySQL to MariaDB (which was a very long time ago), and even more so when upgrading from MariaDB 5.5 to MariaDB 10.0.

I'd personally advocate migrating to MariaDB over Percona, but that's just my personal bias.