Learning

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 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 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 171: Another Round of Toolkit


26:33 minutes (12.31 MB)

This week we discuss more tools in the Percona Toolkit - pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTID replication for high availability.

Obscure Percona Tools
We have talked about Percona tools in many episodes:
Episode 76, Episode 77, Episode 79, Episode 80, Episode 81, Episode 85, Episode 90, Episode 116, Episode 127, Episode 133, Episode 155, Episode 158, Episode 167.

OurSQL Episode 170: Auto-failover, part 2


17:55 minutes (8.36 MB)

This week we discuss administering Percona Replication Manager. Ear Candy is about repository packages from MariaDB and Oracle, and At the Movies presents a Riak engineer talking about "convergent replicated data types" - data structures that tolerate eventual consistency.

Events
DB Hangops - every other Wednesay at noon Pacific time

FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events

The call for papers for OSCon 2014 is open until Thursday, January 30th

OurSQL Episode 165: Top Hat Cluster


28:20 minutes (13.12 MB)

This week we talk about how to install and set up Galera Cluster. Ear Candy talks about the new MySQL repos from Oracle and what to know about using them; At the Movies is Michael Stonebreaker talking about how to process today's big data transactional processing needs.

Galera Cluster
Codership documentation of Galera Cluster
Installing Percona XtraDB Cluster on Ubuntu documentation
MariaDB's Galera Cluster documentation

OurSQL Episode 163: Moving Along


25:33 minutes (11.86 MB)

This week we discuss MySQL's Migration Toolkit. Ear Candy is about the replication format as it propagates through multi-tier master and slaves; At the Movies is Distributed Data Analysis with Hadoop and R.

MySQL Migration Toolkit
Episode 161 where we talked about how MySQL Workbench is a replacement for the older MySQL GUI Tools, including the MySQL Migration Toolkit.

New Migration Toolkit in MySQL Workbench.
Installing ODBC Drivers for use with the Migration Toolkit.

OurSQL Episode 162: Exploring Workbench Further


22:17 minutes (10.36 MB)

This week we explore MySQL Workbench further. Ear Candy is Stewart Smith's 'libeatmydata' and At the Movies is a video to help folks familiar with SQL learn how to use Riak's MapReduce.

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

MySQL Tech Tour Tokyo Nov 27th 2013
MySQL and Linux tech event in Atlanta Dec 5, 2013

OurSQL Episode 161: The sharpest tool on the bench


22:27 minutes (10.43 MB)

This week we discuss the basics of MySQL Workbench. Ear Candy is using performance schema to find unused accounts, and At the Movies presents XtraDB Cluster.

News
Oracle announced that it is providing yum repositories for MySQL, including MySQL packages, MySQL workbench and MySQL connectors.

MySQL Workbench
features of MySQL Workbench - community vs. standard vs. enterprise

MySQL Workbench 6.0 interface changes with pictures.

OurSQL Episode 157: More Than One Master


27:57 minutes (12.95 MB)

This week we interview Luis Soares about multi-source replication. Ear Candy is about memory allocation with FEDERATED and FEDERATEDX storage engines, and At the Movies is about increasing performance by archiving data.

Download the multi-source replication MySQL server snapshot at labs.
Enabling MySQL multi-source replication on Luis' blog,
A quick introduction to multi-source replication, with an example

OurSQL Episode 155: Weaving with Fabric


24:05 minutes (11.18 MB)

Actually, this is episode 156, sorry about the error in the title!

This week we interview Mats Kindahl, a MySQL Senior Principal Software Engineer, about the open source Fabric framework for transaction-safe, semi-automatic sharding and high availability. Because we recorded this during the MySQL Connect conference there is no Ear Candy, nor At the Movies.

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

MySQL Tech Day in Paris Thursday Oct 10th

OurSQL Episode 155: Tooling Around, Part 5


27:05 minutes (12.56 MB)

In this episode, we finish our series about the MySQL Utilities. Ear Candy is pt-stalk, and At the Movies is a fast parallel query engine.

MySQL Utilities part 5

Part 1 of MySQL Utilities
Part 2 of MySQL Utilities
Part 3 of MySQL Utilities
Part 4 of MySQL Utilities

mysqlrplcheck

[bugzilla2]$ mysqlrplcheck --master=root:PASS@bugzilla1 --slave=root:PASS@localhost:/var/lib/mysql/mysql.sock