MySQL Roadmap

Here are some notes from the MySQL Server Roadmap session at the MySQL Conference 2007.

MySQL: Past and Future

  • 2001: 3:23
  • 2003: 4.0 UNION query Cache Embedded
  • 2004: 41. Subqueries
  • 2005: 5.0 Stored Procedures, Triggers, Views
  • Now: 5.1.17 Partitioning, Events, Row-based replication
  • 2007?: 6.0 Falcon, Performance, Conflict detection
  • 2008?: 6.1 Online Backup, FK Constraints

2007 Timeline

  • Q1: 5.1 Beta, 5.1 Telco Production Ready, Monitoring Service 1.1, MySQL 6.0 Alpha, Community GA
  • Q2: MySQL 6.0 Beta, New Connectors GA
  • Q3: 5.1 RC, 6.0 Beta, MS 2.0, Enterprise Dashboard beta
  • Q4: 5.1 GA, 6.0 Beta

Where are we today?

  • We are by fare the most populate open source database
  • The Enterprise world is moving online and MySQL is well-positioned for that trend, But:
    • Transactional scalability
    • Manageability
    • Specific online features

MySQL Server Vision – The Future

  • Always Online — 24×7, Online backup,online analytics, online schema changes
  • Dynamic Scale-out — online partitioning, add node, replication aides,
  • Reliable — fault-tolerant, easy disagnosis, stable memory, ultimately self-healing
  • High-performance — Interactive web, real-time response, apps, 10,000-100,000 clients
  • Ease of use — Portable, Best for development, multiple connectors, easy tuning
  • Modularity and Ubiquity — Storage engines, plug ins

How can you help?

  • Bug finding and fixing — Community Quality Contributor
  • Feature/patch contribution
  • But, to expedite your patch

The goal: “Be the Best Online Database for Modern Applications”

Tagged with: Databases General MySQL MySQL Conference &Amp; Expo 2007

Producing IQR and Outlier statistics with SQL

The interquartile range (IQR) measures the spread of the middle 50% of a distribution — the distance between the first quartile (Q1) and the third quartile (Q3). Combined with Tukey’s 1.

Producing Mode statistics with SQL

The mode is the value or values that appear most frequently in a dataset. Unlike the mean or median, it applies naturally to categorical and ordinal data — star ratings, product codes, survey responses — and reveals what is most common, not what is average.

Extending MySQL Capabilies with UDFs, Plugins and Components - Part 2

MySQL offers three different approaches to extending the SQL capabilities with the default product you download and install. These are: User Defined Function (UDF) MySQL Manual MySQL Plugin MySQL Manual MySQL Component MySQL Manual In my prior post I provided a new uuidv function that accepted a numeric argument to return a string of the version of UUID specified.