Databases
StackOverflow2013
Postsdbo
POOracle's MySQL vs. MariaDB vs. Drizzle
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POOracle's MySQL vs. MariaDB vs. Drizzle
    primarykey
    data
    text
    <p>I've used MySQL in the past but I have not touched it since around when Oracle bought Sun. Now that Oracle has began pushing out their own MySQL updates on the 5.x branch I've pondered the following:</p> <p>There is the Oracle branch as well as two popular forks: Maria and Drizzle. I've been trying to find an objective comparison as to why I would consider one of the two forks instead of using the Oracle branch. I've also been trying to figure out what are the main proponents for each fork that make them differ from the Oracle branch.</p> <p>These are some specifics that I thought of while searching: </p> <ul> <li><p>Drizzle's website says that they have re-organized the code to make it more plugin-based - what is the benefit of that?</p></li> <li><p>Maria's website says that they have made some enhancements but I don't really understand what is so great about them.</p></li> <li><p>MariaDB is a drop-in replacement - that's pretty awesome as I don't have to make any major changes. But I'm trying to figure out why I would drop Maria in over the regular MySQL though.</p></li> <li><p>Are any of Oracle's updates relevant to the common developer who just uses common SQL functions? Since this is a relational DB question assume I would use JOIN.</p></li> </ul> <p>Sites that I have visited:<br> Drizzle: <a href="http://www.drizzle.org/">http://www.drizzle.org/</a><br> MariaDB: <a href="http://mariadb.org/">http://mariadb.org/</a><br> MySQL Community Version: <a href="http://www.mysql.com/products/community/">http://www.mysql.com/products/community/</a><br> Oracle press release on MySQL 5.6: <a href="http://www.oracle.com/us/corporate/press/1583744">http://www.oracle.com/us/corporate/press/1583744</a><br> MySQL is gone: <a href="http://zerolinesofcode.wordpress.com/2010/05/06/mysql-is-gone-here-comes-mariadb-and-drizzle/">http://zerolinesofcode.wordpress.com/2010/05/06/mysql-is-gone-here-comes-mariadb-and-drizzle/</a></p> <p>If you were going to build a web app that would probably serve between 1,000-10,000 users a day with 4-5 tables of data - what factors would you consider for each of these?</p> <p>I understand there are different variables that go into choosing a database; I understand that I have not mentioned hardware; I understand that you might think a NoSQL solution would be better, and I might agree with you. However, I am curious as to how one would approach this from a relational database standpoint.</p> <p>Has anyone tried each of these out before?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USChris Abrams
    1. USChris Abrams
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POOracle's MySQL vs. MariaDB vs. Drizzle
      1. USCorbin
      1. VTFavorite
    2. VO
      singulars
      1. POOracle's MySQL vs. MariaDB vs. Drizzle
      1. This table or related slice is empty.
      1. VTModeratorReview
    3. VO
      singulars
      1. POOracle's MySQL vs. MariaDB vs. Drizzle
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI think it would help your question if you summarized your findings so far and linked to relevant pages of the sites you mention. For example what enhancements does Maria's site list exactly?
      singulars
      1. POOracle's MySQL vs. MariaDB vs. Drizzle
      1. USPaul Bellora
    2. COIs this question beyond the intellectual capacity of SO cummunity ? If so please keep this question Open. I do not see any reason to close this question.
      singulars
      1. POOracle's MySQL vs. MariaDB vs. Drizzle
      1. USsakhunzai
    3. COthis link has some good feature level comparisions: http://database-management-systems.findthebest.com/saved_compare/Drizzle-vs-MySQL
      singulars
      1. POOracle's MySQL vs. MariaDB vs. Drizzle
      1. USsakhunzai
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload