-
Recent Posts
Recent Comments
Archives
- August 2017
- June 2015
- April 2015
- March 2015
- February 2015
- December 2014
- November 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- February 2009
- January 2008
- October 2007
- August 2007
- July 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
Categories
Meta
Author Archives: podcast
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
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
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
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
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
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