General

OurSQL Episode 192: Common Schema, part 2

This week we continue our discussion of Common Schema by finishing up the routines and starting to look at the views it offers. Ear Candy is and At The Movies is

News
In the news, the OurSQL podcast will change to a monthly format after episode 200. We love doing the podcast, but it is very time consuming and production is expensive. We will still bring quality episodes, they will just be spaced further apart.

OurSQL Episode 185: Getting in Sync

This week we discuss pt-table-checksum for keeping data in sync. Ear Candy is a rational look at why one company chose MySQL; At the Movies is using MySQL in a practical way for Big Data.

pt-table-checksum
pt-table-checksum
pt-table-sync

OurSQL Episode 184: Digging Through the Tool Chest

This week we discuss more Percona tools: pt-online-schema-change and pt-slave-find. Ear Candy is using the CONNECT storage engine to read GPX files, and At the Movies is Performance at Scale with TokuDB.

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

OSCon 2014 at the Oregon Convention Center in Portland, Oregon from Sunday July 20th through Thursday July 24th.

The Science and Fiction of Petascale Analytics

At the 2008 MySQL Conference and Expo, the closing keynote was Jacek Becla speaking on The Science and Fiction of Petascale Analysis. See the slides on the O'Reilly Conference Site, and the Official Conference Description

OurSQL Episode 169: Having Fun

This week we present bloopers from the year 2013. We hope you enjoy this non-tech funny show, featuring mistakes and outtakes from us and the folks we have interviewed. Don't miss Tim Callaghan singing our theme song!

OurSQL Episode 168: Autofailover, part 1

This week we discuss setting up Percona Replication Manager. Ear Candy is playing with Unicode to make seasonal pictures and At the Movies is about systems performance with lots of MySQL examples.

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 151: Tooling Around, Part 1

This week we start talking about the Python MySQL Utilities. Ear Candy is a pitfall when importing a mysqldump export and At the Movies is "Deploying MySQL in AWS and OpenStack" by Mark Riddoch of SkySQL.

Part 2 of MySQL Utilities
Part 3 of MySQL Utilities
Part 4 of MySQL Utilities
Part 5 of MySQL Utilities

MySQL Utilities
MySQL Utilities documentation

OurSQL Episode 149: Trolling

This week we continue our interview with Noam Kritzer of Bakos & Kritzer, talking about patent case law and patent trolls. Ear Candy is temporary table ghost files, and At the Movies is Manipulating JSON with MariaDB and MySQL.

defensive vs. offensive patents

Patent trolls

Trademarks and domain names

Copyright.gov, a resource written for lay people.

OurSQL Episode 148: Intellectual Property

This week we interview Noam Kritzer from the law firm of Bakos & Kritzer about copyright, patents and trademarks. Ear Candy is about SUBSTRING_INDEX and At the Movies is Colin Charles presenting a panel on MariaDB.

Events
DB Hangops - every other Wednesay at noon Pacific time

Oracle is having a MySQL OTN Virtual Developer Day August 31st.

FrOSCon - Aug 24-25th, 2013 in St. Augustin, Germany.

OurSQL Episode 137: Playing in the Sandbox

This week we talk to Giuseppe Maxia about MySQL Sandbox. Ear Candy is about table_open_cache, Open_tables and Opened_tables, and At the Movies features MariaDB.

MySQL Sandbox
MySQL Sandbox

Examples:
MariaDB slave of a master:

make sandbox mysql-tarball --master
make sandbox mariadb-tarball --slaveof master-port=foo

Exporting:

./my sqldump instancename

Remote mysql sandbox deploy:

deploy remote sandboxes -m MySQLVer -l list,of,servers

Get MySQL Sandbox on Launchpad

Pages