4 ms·

I have been really thinking about switching my DBs from MySQL to MariaDB. Wondering if someone could help me out with a few questions.. Is it a really a drop-i

by nivla 13y ago

I have been really thinking about switching my DBs from MySQL to MariaDB. Wondering if someone could help me out with a few questions.. Is it a really a drop-in replacement? Any gotchas I need to be aware off? How does MariaDB compare with MySQL performance and memory wise? Did anyone face any issues with replication? Thank you in advance.

JeremyMorgan 13y ago
I haven't done any really extensive work, but I have replaced it, and it is "drop in" because it's a fork of MySQL. None of my applications had any problems interfacing and the performance is reported to be better, though honestly I don't push it to the limits to say whether that's the case for me.
voidlogic 13y ago
> How does MariaDB compare with MySQL performance Slower last time I tested with my app on my HW. But you should test now with your app now on your HW of course to be sure :) What I have heard is if you have lots of CPUs MariaDB doesn't scale up as well. If you scale out, that might not matter.
- gcr 13y ago
  Why would this be so? MariaDB started from the same source tree that MySQL had. In order for performance to drop, a Maria developer would have to intentionally commit changes that lower performance.
  - lordgilman 13y ago
    Regressions can be accidental. Did you see how the parent stressed testing on your specific hardware with your specific code?
  - wging 13y ago
    We're not talking about performance loss but a relative performance difference. It's at least possible that MySQL might've introduced performance gains that MariaDB didn't get. I have no idea whether this is the case.
deleted 13y ago
[deleted]
spudlyo 13y ago
It all depends. When you're talking about MySQL, do you mean MySQL 5.5 (the penultimate and most stable version) or the brand new Oracle released 5.6? If you're not one to jump on the 5.6 bandwagon there isn't a lot of difference between MariaDB, XtraDB (Percona) and MySQL 5.5. To make it even more confusing, MariaDB includes Percona's XtraDB (a patched InnoDB) so in essence with MariaDB you're also getting Percona, although perhaps not the latest offerings from Percona. Oracle MySQL 5.6 has a number of interesting new features and performance improvements that I don't believe have yet made it into either XtraDB or MariaDB. So if you're talking about MySQL 5.5, MariaDB and XtraDB are really drop in replacements, they're all based on the same codebase, and hardly anything differs except the InnoDB engine. MariaDB and XtraDB have as few experimental InnoDB bug-fixes and performance tweaks that vanilla 5.5 does not.
xmodem 13y ago
Just switch to postgres. Don't take any chances.

by nivla 13y ago

JeremyMorgan 13y ago

I haven't done any really extensive work, but I have replaced it, and it is "drop in" because it's a fork of MySQL. None of my applications had any problems interfacing and the performance is reported to be better, though honestly I don't push it to the limits to say whether that's the case for me.

voidlogic 13y ago

> How does MariaDB compare with MySQL performance Slower last time I tested with my app on my HW. But you should test now with your app now on your HW of course to be sure :) What I have heard is if you have lots of CPUs MariaDB doesn't scale up as well. If you scale out, that might not matter.

gcr 13y ago
Why would this be so? MariaDB started from the same source tree that MySQL had. In order for performance to drop, a Maria developer would have to intentionally commit changes that lower performance.
- lordgilman 13y ago
  Regressions can be accidental. Did you see how the parent stressed testing on your specific hardware with your specific code?
- wging 13y ago
  We're not talking about performance loss but a relative performance difference. It's at least possible that MySQL might've introduced performance gains that MariaDB didn't get. I have no idea whether this is the case.

deleted 13y ago

[deleted]

spudlyo 13y ago

It all depends. When you're talking about MySQL, do you mean MySQL 5.5 (the penultimate and most stable version) or the brand new Oracle released 5.6? If you're not one to jump on the 5.6 bandwagon there isn't a lot of difference between MariaDB, XtraDB (Percona) and MySQL 5.5. To make it even more confusing, MariaDB includes Percona's XtraDB (a patched InnoDB) so in essence with MariaDB you're also getting Percona, although perhaps not the latest offerings from Percona. Oracle MySQL 5.6 has a number of interesting new features and performance improvements that I don't believe have yet made it into either XtraDB or MariaDB. So if you're talking about MySQL 5.5, MariaDB and XtraDB are really drop in replacements, they're all based on the same codebase, and hardly anything differs except the InnoDB engine. MariaDB and XtraDB have as few experimental InnoDB bug-fixes and performance tweaks that vanilla 5.5 does not.

xmodem 13y ago

Just switch to postgres. Don't take any chances.