MySQL Overview

Transcript

1. 1 @RonaldBradford Helsinki 20 Aug Stockholm 21 Aug Riga 26 Aug Tallinn 27 Aug Ronald Bradford August 2014 MySQL Overview
2. EffectiveMySQL.com #mysql #emea2014 MySQL Overview MySQL Overview What is MySQL? Who choose MySQL? 2
3. EffectiveMySQL.com #mysql #emea2014 MySQL Overview What is MySQL? Started as a RDBMS (1995) Today, a suite of products 3
4. EffectiveMySQL.com #mysql #emea2014 MySQL Overview MySQL Features Standard RDBMS Features Schemas,Tables,Views,Constraints,Indexes, Triggers,Stored Procedures, Partitioning ACID Referential Integrity Varying Locking/concurrency strategies 4
5. EffectiveMySQL.com #mysql #emea2014 MySQL Overview MySQL Popularity LAMP Linux, Apache, MySQL, PHP Included in Linux distributions 5
6. EffectiveMySQL.com #mysql #emea2014 MySQL Overview MySQL Benefits Small footprint Easy configuration Ease with common programming languages FREE 6
7. EffectiveMySQL.com #mysql #emea2014 MySQL Overview MySQL Products MySQL Community Edition MySQL Cluster MySQL Connectors MySQL Workbench MySQL Fabric MySQL Utilities Windows/Mac Install Repositories (Yum/Apt) http://dev.mysql.com/downloads/ 7 Open Source
8. http://www.mysql.com/downloads/ EffectiveMySQL.com #mysql #emea2014 MySQL Overview MySQL Enterprise MySQL Enterprise Edition MySQL Enterprise Backup MySQL Enterprise Monitor MySQL Enterprise HA MySQL Enterprise Audit MySQL Workbench Enterprise 8 Commercial
9. EffectiveMySQL.com #mysql #emea2014 MySQL Overview Release Cycle Labs - Experimental features DMR - Development Milestone Release Version 5.7.4 GA - General Availability Version 5.6 (3/2013) Version 5.5 (12/2010) EOL - End of Life Version 5.1, 5.0, 4.1, 4.0, 3.23 DOA - Never Released Version 5.4, 6.0 9
10. EffectiveMySQL.com #mysql #emea2014 MySQL Overview 10 https://en.wikipedia.org/wiki/MySQL
11. EffectiveMySQL.com #mysql #emea2014 MySQL Overview 3rd party ReferenceS OurSQL Podcasts http://www.oursql.com/ Planet MySQL http://planet.mysql.com/ MySQL Sandbox http://mysqlsandbox.net/ Percona Toolkit http://www.percona.com/software/percona-toolkit 11 Many More
12. EffectiveMySQL.com #mysql #emea2014 MySQL Overview mysql ecosystem Oracle MySQL Percona Server MariaDB Galera Cluster Tokutek WebScaleSQL ... 12 Oracle Support From Dual Severalnines SkySQL/Monty Program Pythian Percona ... Products Services
13. EffectiveMySQL.com #mysql #emea2014 MySQL Overview Conclusion Copies of these slides can be found at http://effectiveMySQL.com ronald@EffectiveMySQL.com 13