Upgrade to Pro — share decks privately, control downloads, hide ads and more …

MySQL Overview

MySQL Overview

Ronald Bradford

August 09, 2014
Tweet

More Decks by Ronald Bradford

Other Decks in Technology

Transcript

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  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

    View full-size slide

  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

    View full-size slide

  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

    View full-size slide

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

    View full-size slide

  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

    View full-size slide

  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

    View full-size slide

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

    View full-size slide