Podcasts

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 147: It's Web Scale

This week we talk with Tim Callaghan of Tokutek about TokuMX, a take on MongoDB. Ear Candy is perror on Windows and At the Movies is a presentation from the SkySQL and MariaDB Solutions Day 2013 about Tokutek.

TokuMX

Replication between MySQL and MongoDB using Tungsten a couple of years ago at Open DB Camp in Sardinia (2011).

Previous interviews with Tokutek folks in:
Episode 39

OurSQL Episode 146: License to run

This week we discuss copyleft, GPL and related licenses. In Ear Candy we discuss INFORMATION_SCHEMA and permissions, and At the Movies is about a columnar database.

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.

Upcoming MySQL events

OurSQL Episode 145: Biblical Tools, part 3

This week we finish up talking about the Openark Kit for MySQL. Ear Candy is using both --master-data and --tab with mysqldump, and At the Movies features Robert Hodges of Continuent presenting Scalable MySQL Operation in the Cloud with Continuent Tungsten.

Openark Kit series:
Part 1
Part 2

Openark Kit


oak-purge-master-logs


PURGE BINARY LOGS at the MySQL manual page.

OurSQL Episode 144: Biblical Tools, part 2

This week we continue talking about the Openark Kit. Ear candy is the Percona Configuration Wizard, and At the Movies is a keynote from the SkySQL and MariaDB Solutions Day about the SkySQL and MariaDB merger and the MariaDB Foundation.

Openark Kit series:
Part 1
Part 3

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

Training
SkySQL Trainings

OurSQL Episode 143: Biblical Tools

This week we start to discuss the Openark Toolkit. Ear Candy talks about how to estimate the size of MySQL's working set, and At the Movies is a backup presentation from Open Database Camp.

Openark Kit series:
Part 2
Part 3

Openark Kit
Openark Kit

Episode 80, discussing the Percona Toolkit

OurSQL Episode 142: Great Views

This week we discuss MySQL Views. Ear Candy is GRANTs and replication and At the Movies is a presentation by Giuseppe Maxia talking about "Creating Multi-Master clusters with Tungsten Replicator".

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

Training
SkySQL Trainings

Tungsten University trainings

OurSQL Episode 141: Performance Enhancements

This week we talk about server and status variables relating to the performance schema and the ps_helper tool. Ear Candy is an sql_mode bug, and At the Movies is a performance_schema and ps_helper webinar.

Performance Schema Variables
MySQL 5.5 performance schema variables
MySQL 5.6 performance schema variables - many options are auto-sized


SHOW GLOBAL VARIABLES LIKE 'performance_schema%';

OurSQL Episode 140: More Performance

This week we explain performance_schema a bit deeper. In Ear Candy, we talk about max_binlog_cache_size and At the Movies presents Max Mether of SkySQL talking about "High Availability Solutions for MySQL".

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

Training
SkySQL Trainings
Tungsten University trainings

OurSQL Episode 139: Starting to Perform

This week we discuss the basics of using the performance schema in MySQL 5.5 and 5.6. Ear Candy is about a temporal gotcha when using dates and times that do not exist, and At the Movies is David Stokes giving some useful for System Administrators who also are in a DBA role.

News
Continuent's Tungsten Replicator is now completely open source
TokuDB is now open source

Pages