On Thu, Dec 13, 2012 at 8:28 AM, Ed Leafe <[email protected]> wrote:
> >> Even the creator of MySQL has been saying not to use it anymore, and > recommends MariaDB, which is his drop-in replacement for MySQL. > That can be a little confusing. "MySQL" the word is a registered trademark worldwide, which was once owned by MySQL AB, which was acquired by Sun MicroSystems, which in turn was acquired by the Red Menace, er, Oracle. All Oracle owns is a trademark and a few bits of accessory tools MySQL AB had developed which were not Open Source. The remainder of the code that makes up the MySQL database engine is Open Source, and several new Open Source projects have been created, including MariaDB [1] lead by Michael "Monty" Widenius, one of the original principals of MySQL AB, Drizzle, an attempt at a minimal, streamlined, fully-functional version, Percona, and others [2]. "M" in LAMP was originally MySQL, but MariaDB is a drop-in replacement for that, as it is essentially the same code, with trademarks removed, and a few bugs fixed. Both MariaDB and PostgreSQL are great databases, and can be installed in many facilities and run problem-free for a long time. A couple disclaimers, however: it is worthwhile learning a bit about the databases to ensure they are configured and maintained properly. MariaDB has several different table types, and you'll want to ensure you pick the right type for the job. Both databases have configuration files that need to be set up properly and are worth spending a little time tuning for your application needs. Both have security subsystems that may be a little too open or too closed for your needs. Both have some new datatypes you're not familiar with that could have performance (or accuracy) implications. I guess what I'm saying is that it is very beneficial to learn more of the details and figure out what works for you. Disclaimer: I'm a twice-certified MySQL guy; Certified MySQL Developer (CMDEV) in 2008 for MySQL 5.x and Core Certificate for MySQL 4.x. (I like certifications, I guess.) However, I have deployed solutions with both tools (MySQL and Postgres) as well as DBFs/DBC, SQL Server, Ingres and Oracle. I definitely prefer the first two to any of the other choices. [1] https://mariadb.org/ [2] https://en.wikipedia.org/wiki/MySQL#Related_projects -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4vG=1YoiprJaJiQpy3wd483ANkZQ3UZsABZ=k5a8o0...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
