Learn how to build rich, multi-tier applications in the cloud using PHP and MySQL, taking advantage of new Windows Azure features. This session will cover using PHP, MySQL, and memcached in Windows Azure.
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. [youtube sv1vhahDwo8]
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 …
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), …
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 …
Sheeri K. Cabral of the Pythian Group goes through the meanings of INNER, LEFT/RIGHT OUTER, CROSS, NATURAL joins, how to do a FULL OUTER JOIN in MySQL, and what STRAIGHT_JOIN means. She also goes through how to recognize when you want those types of joins, and best practices for the …
