Subscribe to PHP Freaks RSS

Should you be using MariaDB or MySQL?

Print
by gizmola on Jan 24, 2018 3:58:30 PM - 31,345 views
Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser.class.php on line 982 Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser_bbcode.class.php on line 567 Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser_bbcode.class.php on line 1210 Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser_bbcode.class.php on line 1221 Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser_bbcode.class.php on line 1264 Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser_bbcode.class.php on line 1281 Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser_bbcode.class.php on line 1535

In a recent webinar by database consulting company and highly regarded MySQL experts Percona Colin Charles discussed the assertion that MariaDB is actually a "drop-in" replacement for MySQL at this juncture. His presentation outlines many places that MariaDB and MySQL have diverged, and particularly in the areas of data encryption, backup/restoration and replication, there are many significant interoperability issues.

He also points out that in the areas of performance and features, MySQL has taken a substantial step forward recently with the release of version 5.7 and the development 8.0x line. There is even a valid question as to whether the company behind MariaDB is actively interested in retaining its heritage as a MySQL alternative.

The presentation notes are available here and include references and source material links that anyone who regularly works with mysql or MariaDB will likely find to be valuable. It's a great primer for jump starting inquiry into recent MySQL and MariaDB features like GTID's, MySQL's new JSON datatype, and the MySQL X protocol.

Comments

No comments have been posted.

Add Comment

Login or register to post a comment.