Providing educational resources and monetary grants to IT professionals.

OurSQL Episode 181: MariaDB Goodies


24:33 minutes (11.39 MB)

This week we discuss more features of MariaDB 10. Ear Candy is how to avoid downtime when switching to GTIDs and At the Movies is Managing Hundreds of MySQL Servers Efficiently.

News
MySQL Community Awards 2014: the Winners

MariaDB 10
MariaDB 10.0.1 features
Other MariaDB podcasts:
OurSQL Episode 89, where we talk about an overview of MariaDB

OurSQL Episode 180: Sharing the Load


24:43 minutes (11.47 MB)

This week we talk to Justin Swanhart about Shard-Query, a massively parallel processing query engine for MySQL. Ear candy is about mydumper, and At the Movies is "Common Deadly MySQL Development Mistakes."

Events
Percona Live
DB Hangops - every other Wednesay at noon Pacific time
Upcoming MySQL events

Training
SkySQL Trainings

OurSQL Episode 179: MySQL's Materialized Views


25:20 minutes (11.76 MB)

This week, we interviewed longtime community member and Percona principal support engineer Justin Swanhart about Flexviews, a tool for Materialized Views in MySQL. Ear Candy is about the EXPLAIN analyzer, and At the Movies is about "Advanced MySQL Replication Architectures and Latest Developments".

Flexviews
Justin Swanhart's open source tools
ABOUT Flexviews - "Flexviews is a unique toolkit for the creation and upkeep of MATERIALIZED VIEWS for MySQL."

OurSQL Episode 178: License to Use


26:07 minutes (12.11 MB)

This week we discuss more software licenses, concluding our 3-part series on licenses. Ear Candy is what happens when ALTER TABLE crashes, and At the Movies is Jon Day of SkySQL presenting MaxScale.

Events
Percona Live

DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

Training
SkySQL Trainings
Tungsten University trainings

OurSQL Episode 177: Artistic License


26:31 minutes (12.29 MB)

This week, we sat down with Luis Villa about non-software licenses. Ear Candy is and At the Movies is Sheeri talking about Percona Replication Manager at the Boston MySQL User Group a few years ago.

Non-software Licenses
Luis Villa's Wikipedia page.

Back in episode 146, we talked about the GPL open source license, and its versions and derivatives.

Database directive at Wikipedia. In the EU, you can license a database.

OurSQL Episode 176: Replication Everywhere


21:04 minutes (9.8 MB)

This week we talk about replication features in MariaDB 10. Ear Candy is a gotcha about PIVOT tables in MariaDB, and At the Movies is about the viability of transactions.

Percona Live
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

Training
SkySQL Trainings
Tungsten University trainings

OurSQL Episode 175: Interesting CONNECtions


25:00 minutes (11.6 MB)

This week, we talk about the awesome ways to use MariaDB's CONNECT storage engine that go above and beyond merely connecting to remote tables.

MariaDB CONNECT Engine
Episode 174, where we talked about setting up the CONNECT storage engine and some simple examples.

Pivot Tables
MariaDB documentation page about pivot tables with CONNECT

Wikipedia entry about pivot tables

Creating the pivot table example:

OurSQL Episode 174: CONNECT the world


25:30 minutes (11.83 MB)

This week we discuss MariaDB's CONNECT storage engine. Ear Candy is inconsistent behavior with dates, NULLs and collations. At the Movies is a talk about the history and future of MySQL and its variants.

Sheeri:
The 2014 MySQL Community Awards are open for nominations until Sunday, 23 February 2014

Events
DB Hangops - every other Wednesay at noon Pacific time. Upcoming dates are Wednesday February 19th, March 5th and March 19th.

Upcoming MySQL events

OurSQL Episode 173: Time for Percona Live


38:19 minutes (17.7 MB)

This week, we talk about the new and innovative talks appearing at Percona Live. Ear Candy is about warming up the innodb buffer pool cache, and At the Movies talks about zero-cost joins.

Pecona Live
Percona Live 2014 is Tuesady April 1st through Friday April 5th at the Santa Clara Convention Center in Santa Clara, California.

Percona Live 2014 conference site

Register for Percona Live - save $100 if you register on or before March 2nd!

OurSQL Episode 172: A New Proxy


31:47 minutes (14.71 MB)

This week, we talk with Ivan Zoratti of SkySQL about MaxScale, a new MySQL proxy. Ear Candy is about accidentally removing a dependent package, and At the Movies is a DB Hangops recording of MaxScale, replication saturation and monitoring.

Events
DB Hangops - every other Wednesay at noon Pacific time
Upcoming MySQL events, including Tech Tours

Training
SkySQL Trainings
Tungsten University trainings