MySQL

State of MariaDB

Monty, the co-founder of MySQL and now project lead of MariaDB, discusses what MariaDB is all about. MariaDB is a database server that offers drop-in replacement functionality for MySQL1. He presents an overview of the future of this community developed branch of the MySQL database.

Migration From Oracle to MySQL

This talk will cover what a few Oracle experts (but MySQL newbies) learned in a recent migration at NPR.org. It discusses how we separated our previously monolithic database into smaller, more functionally cohesive databases and some of the criteria we used to decide what tables ended up where. This architecture allowed for better load balancing …

Migration From Oracle to MySQL Read More »

MariaDB, the Backward Compatible Branch of MySQL(R) Database Server

MariaDB is a community developed, backward compatible, drop-in replacement branch of the MySQL(R) Database Server. What is MariaDB all about, and what is its future? What can you do with new features added in the first GA release of MariaDB 5.1, such as additional Storage Engines (Maria, PBXT, XtraDB, FederatedX), faster complex queries, pools of …

MariaDB, the Backward Compatible Branch of MySQL(R) Database Server Read More »

An Overview of the MySQL Engine and its Latest Features

The first part of this talk describes the main principles behind MySQL’s query optimizer and execution engine, how the optimizer transforms queries into executable query plans, what these plans look like, and how they are executed. The second part of the talk describes the major improvements in the query engine of MySQL 5.0, and how …

An Overview of the MySQL Engine and its Latest Features Read More »