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

Extending MySQL Capabilities with UDFs, Plugins and Components

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 For the purposes of this post I will be using the current LTS version MySQL 8.

Producing One-Sample Z-Test statistics with SQL

The one-sample Z-test determines whether a sample mean differs significantly from a known population mean when the population standard deviation is also known. It is the appropriate test when the population parameters are established — quality control benchmarks, national averages, long-run process measurements — and you want to evaluate whether a new sample is consistent with them.

Switching to JSON Error Logging in MySQL

You no longer need to manually parse the MySQL Error log via scripting and RegEx pattern matching. Using the component_log_sink_json component you can obtain JSON error logging for easier parsing.