Slide 1

Slide 1 text

1 @RonaldBradford Helsinki 20 Aug Stockholm 21 Aug Riga 26 Aug Tallinn 27 Aug Ronald Bradford August 2014 MySQL Overview

Slide 2

Slide 2 text

EffectiveMySQL.com #mysql #emea2014 MySQL Overview MySQL Overview What is MySQL? Who choose MySQL? 2

Slide 3

Slide 3 text

EffectiveMySQL.com #mysql #emea2014 MySQL Overview What is MySQL? Started as a RDBMS (1995) Today, a suite of products 3

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

EffectiveMySQL.com #mysql #emea2014 MySQL Overview MySQL Popularity LAMP Linux, Apache, MySQL, PHP Included in Linux distributions 5

Slide 6

Slide 6 text

EffectiveMySQL.com #mysql #emea2014 MySQL Overview MySQL Benefits Small footprint Easy configuration Ease with common programming languages FREE 6

Slide 7

Slide 7 text

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

Slide 8

Slide 8 text

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

Slide 9

Slide 9 text

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

Slide 10

Slide 10 text

EffectiveMySQL.com #mysql #emea2014 MySQL Overview 10 https://en.wikipedia.org/wiki/MySQL

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

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

Slide 13

Slide 13 text

EffectiveMySQL.com #mysql #emea2014 MySQL Overview Conclusion Copies of these slides can be found at http://effectiveMySQL.com [email protected] 13