Posted by kyle_mathews on July 22, 2010 at 7:06pm
After reading this issue (http://drupal.org/node/861192) today I wondered what the Pantheon community though about moving the default DB to MariaDB? I haven't played with it at all but the benchmarks look really good and assuming it's stable enough, I don't see any reason not to make the switch.
Comments
re: Change default DB to MariaDB
The purpose of Pantheon is to leverage existing, supported and stable technologies to make Drupal as fast as possible, not to necessarily introduce new tech to drupal.
If drupal/pressflow makes the switch, I'm sure we would follow.
I suspect that as the project matures, we will be adding support for more options in DB and/or webservers and/or caching mechanisms.
In the meantime, one can turn off mysql in Mercury 1.1 and setup/configure a different DB.
Hope this helps,
Greg
--
Greg Coit
Systems Administrator
http://www.chapterthree.com
MariaDB is a drop-in replacement of MySQL
MariaDB isn't "new tech" per se as I understand it. It's just a faster MySQL. Drupal/Pressflow don't need to make the switch because there's nothing that needs changed there to as MariaDB already works perfectly w/ Drupal. If you read through the issue I linked to that was the point Chx was making.
So my question is more is MariaDB supported and stable enough to make it the default DB for Pantheon? AFAIK, the benchmarks people have done show MariaDB is clearly faster than Innodb so switching to MariaDB clearly supports Pantheon's goal to make Drupal as fast as possible.
Kyle Mathews
how make the switch?
Can I just uninstall mysql then install MariaDB? Will that mess with the BCFG stuff?
Kyle Mathews
re: how make the switch?
Unfortunately, we do have mysql hardcoded into the mercury config which means bcfg2 will re-install mysql if you run bcfg2 -vq. It's on our long-term list to change this.
Greg
--
Greg Coit
Systems Administrator
http://www.chapterthree.com
k, will just wait to use MariaDB w/ Pantheon
It's not critical at the moment. I can test MariaDB more on a non-pantheon setup.
Kyle Mathews