MariaDB - The Future of MySQL?
1 like873 views
For decades MySQL has been the rocksolid backbone of many CFML powered Web-Applications. But recently the development lost a bit traction, new cool kids appeared on the scene. The most promising one is called MariaDB, a MySQL Fork by Monty Widenius, the original MySQL founder. MariaDB grow rapidly over the last 2 years and overpaced MySQL feature- and performancewise. In this talk, we compare MySQL and MariaDB, explain what to consider when using it with CFML and share our experience in an Enterprise Infrastructure with the build-in Galera Cluster and ColdFusion 11.
More Related Content
What's hot (20)
Viewers also liked (18)
Similar to MariaDB - The Future of MySQL? (20)
More from Bokowsky + Laymann GmbH (20)
Recently uploaded (20)
MariaDB - The Future of MySQL?
- 1. MariaDB - The Future of MySQL? CFCamp 2015 MariaDB - The Future of MySQL? © photoart.com
- 3. • Developed by Monty Widenius and David Axmark • Named after Montys daughter My • First release was v3.1 in 1997 • Acquired by Sun Microsystems in 2008 • Oracle acquired Sun Microsystems in January 2010 • v5.6 released in Febuary 2013 MySQL
- 5. • Forked by Monty Widenius • Named after Montys younger daughter Maria • First release v5.1 in October 2010 • MariaDB Foundation announced in December 2012 by Monty Widenius and David Axmark • v10.1 released in June 2014 MariaDB
- 6. • Starts with v5.1 • v5.2 and v5.3 were service releases • v5.5 ist the last version that ist officially binary compatible • After 5.5 MariaDB continued with v10+ • v10+ not guaranteed to be binary compatible • v10.1 application level compatible MariaDB
- 7. Companies supporting MariaDB • Google • Wikipedia • Mozilla • booking.com MariaDB
- 8. Linux Distributions with MariaDB as default Database • Fedora • Gentoo • openSUSE (from 12.3) • Red Hat Enterprise Linux (from 7) • CentOS 7 • Oracle Linux (from 7) MariaDB
- 9. Why MariaDB
- 10. • Founded by the original MySQL team • Only DB software by this Foundation • Faster development • Open development (look at github) • Quick and transparent security releases • More storage engines MariaDB
- 11. • Better Performance • Easy migration • Master - Master Replication (with Galera Cluster) • Compatible with default MySQL JDBC Connector in CF10 / 11 • MySQL future unclear MariaDB
- 13. Galera Cluster
- 14. Galera Cluster
- 15. • Multi Master Replication • Client can connect to any node • Read and write access to any node • Synchronous Replication Galera Cluster
- 16. Galera Cluster commit Galera Replication ok Transaction processed on node upon commit Transaction replicated to cluster Client gets ok Transaction applied to slaves
- 17. • Distributed with MariaDB since v10.19 • Works in LAN and WAN • No Impact on reads / transactions • Commits slower • Needs odd number of nodes (quorum) • Will be slower with high numer of nodes Galera Cluster
- 18. Galera Cluster Cluster Partitioning: • Majority partition has quorum • Minority cannot commit and will try to reconnect
- 19. Galera Cluster Cluster Partitioning: • Majority partition has quorum • Minority cannot commit and will try to reconnect
- 20. Galera Cluster Moving to galera cluster in live environment MySQL Master MySQL Slave
- 21. Galera Cluster Moving to galera cluster in live environment MySQL Master MySQL Slave Galera Node 1
- 22. Galera Cluster Moving to galera cluster in live environment MySQL Master MySQL Slave Galera Node 1 Galera Node 2 Galera Node 3
- 23. Galera Cluster Moving to galera cluster in live environment MySQL Master MySQL Slave Galera Node 1 Galera Node 2 Galera Node 3
- 24. Galera Cluster Moving to galera cluster in live environment Galera Node 1 Galera Node 2 Galera Node 3
- 25. Galera Cluster Moving to galera cluster in live environment Galera Node 1 Galera Node 2 Galera Node 3
- 26. • Can be mixed with standard replication • Galera node can act as MySQL Master or Slave • Offers high availability • Slightly slower on commits • Can be used with MaxScale as Loadbalancer Galera Cluster
- 27. MaxScale
- 28. • Loadbalancer for MySQL and MariaDB offers: • Support for different Client and backend protocols • Request filtering • Routing and load balancing • Authentication and Monitoring • Nagios Plugin MaxScale Features
- 29. • Support for MySQL / MariaDB connectors • Works with CF10/11 MySQL or MariaDB JDBC Connector • Support for MySQL/MariaDB replication • Support for Galera Cluster MaxScale Cl/ent and Backend
- 30. • Offers routing and load balancing • Connection (port) based routing: doesn’t examine requests • Statement based Routing: examines requests based on given statements • Rewrite SQL queries based on regular expressions • Query duplication (second database) MaxScale Rout/ng and Loadbalanc/ng
- 31. MaxScale Galera Node 1 Galera Node 2 Galera Node 3 Galera Node 4 Galera Node 5 MaxScale CF Server read/write r/w r/w r/w r/w r/w Loadbalanc/ng
- 32. MaxScale Galera Node 1 Galera Node 2 Galera Node 3 Galera Node 4 Galera Node 5 MaxScale CF Server read/write w r r r r Read / Wr/te
- 33. MaxScale Galera Node 1 Galera Node 2 Galera Node 3 Galera Node 4 Galera Node 5 MaxScale CF Backend r/w w r r r r CF Front A CF Front B r/wr/w ww rr dd some colors…
- 34. MaxScale Shard 1 Shard 2 Shard 3 Shard 4 Shard 5 MaxScale CF Server Shard/ng
- 35. • Rewrite Queries: e.g. replace „engine“ with „type“ for CREATE statements • Block Queries: e.g. block queries with „OR“ operators on table „users“ MaxScale F/rewall and rewr/te
- 36. • Separates Database and application logic • Allows simple scaling of database without influencing application logic • Allows high availability / failover configuration • Easy maintenance MaxScale
- 37. • Visible as one MariaDB Server to CF • Easy to use for Developers as DB clustering / scaling doesn't have to be integrated in applications • Change in cluster doesn't influence application logic • Focus on Application, not DB MaxScale
- 39. • ColdFusion / Lucee are compatible to MariaDB without restrictions • Use standard MySQL driver • No change in application logic needed • Some restrictions to MaxScale (check User Permissions, Stored Procedures) • When using MaxScale, try to separate Read/Write requests to DB ColdFusion
- 40. Conclusion(at least for us…)
- 41. • Faster development and more features • Galera cluster and Maxscale load- balancer „out of the box“ • Easy migration • Compatible with ColdFusion / Lucee, again out of the box • …and somehow it just feels „smarter“ MariaDB
- 42. Find these slides and much more stuff at www.bokowsky.net/de/knowledge-base/
- 43. Thank you Matthias Proske proske@bokowsky.de Bokowsky + Laymann GmbH www.bokowsky.de @BokowskyLaymann also on Facebook, Slideshare, YouTube, Flickr P.S: Bokowsky + Laymann is looking for ColdFusion Developers jobs@bokowsky.de - or any social network of your choice