Category Archives: Podcasts

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. W… Continue reading

Posted in General, Performance, Podcasts, Routines | Comments Off on OurSQL Episode 192: Common Schema, part 2

OurSQL Episode 191: Common Schema, part 1

This week we start talking about common schema by Shlomi Noach. Ear Candy is some caveats about GTIDs and replication, and At the Movies is using jQuery, AJAX and PHP to insert data into MySQL.
News
In the news, the OurSQL podcast will change to a mont… Continue reading

Posted in Podcasts, Routines | Comments Off on OurSQL Episode 191: Common Schema, part 1

OurSQL Episode 190: Server State Monitoring

This week we discuss pt-sift and pt-stalk. Ear Candy is about a new tool called Orchestrator, and At the Movies is about Trove on OpenStack to provide open source Database as a Service.
News
Gerry:
In the news, the OurSQL podcast will change to a month… Continue reading

Posted in Performance, Podcasts, Query Optimization | Comments Off on OurSQL Episode 190: Server State Monitoring

OurSQL Episode 189: Syncing Both Ways

This week we discuss advanced pt-table-sync, including bidirectional sync. Ear Candy is starting MySQL on low-memory virtual machines, and At the Movies is “What’s New With MySQL and MariaDB?”
pt-table-sync
Episode 188, where we talked about pt-table-s… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 189: Syncing Both Ways

OurSQL Episode 188: Back in Sync

This week we discuss pt-table-sync basics. Ear Candy is about how MyISAM can seem transaction-aware, and At the Movies is MySQL and NoSQL at Craigslist.
Events
DB Hangops – every other Wednesay at noon Pacific time
Upcoming SkySQL events
Upcoming MySQL… Continue reading

Posted in Learning, Podcasts, Software | Comments Off on OurSQL Episode 188: Back in Sync

OurSQL Episode 187: Hanging Out

This week, we discuss DB Hangops with special guest, Geoffrey Anderson. Ear Candy is that GTIDs in MariaDB and MySQL are different, and At the Movies is Jonathan Levin talking about deduplicating your data with MySQL.
DB Hangops
DB Hangops – blog and v… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 187: Hanging Out

OurSQL Episode 186: Data at OSCon

This week we talk with former co-host Sarah Novotny about Data at OSCon. Ear Candy is about SQL Courses, and At the Movies is a two and a half hour tutorial about MySQL Scaling Strategies for Developers.
Events
DB Hangops – every other Wednesay at noon… Continue reading

Posted in Conferences, Podcasts | Comments Off on OurSQL Episode 186: Data at OSCon

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
Episode 151, w… Continue reading

Posted in General, Learning, Podcasts | Comments Off on OurSQL Episode 185: Getting in 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… Continue reading

Posted in General, Learning, Performance, Podcasts | Comments Off on OurSQL Episode 184: Digging Through the Tool Chest

OurSQL Episode 183: Map Our Way Around

This week we discuss MySQL and Geographical Information Systems (GIS). Ear candy is how MVCC in InnoDB relates to undo logging and how you can write better queries based on this information. At the Movies is a demo of GIS.
MySQL and MariaDB geographic … Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 183: Map Our Way Around