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

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

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 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!
Continue reading

Posted in General, Podcasts | Comments Off on OurSQL Episode 169: Having Fun

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 Pacifi… Continue reading

Posted in General, Podcasts | Comments Off on OurSQL Episode 168: Autofailover, part 1

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 Utili… Continue reading

Posted in General, Podcasts | Comments Off on OurSQL Episode 151: Tooling Around, Part 1

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

Posted in General, Podcasts | Comments Off on OurSQL Episode 149: Trolling

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

Posted in General, Podcasts | Comments Off on OurSQL Episode 148: Intellectual Property

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

Posted in General, Podcasts | Comments Off on OurSQL Episode 137: Playing in the Sandbox

OurSQL Episode 123: Storing Bags of Bytes

This week we discuss different filesystems and how they work. Ear Candy talks about the “-bibyte” suffix, and At the Movies presents an indexing webinar.
Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 – Sun Feb 3rd.
OSCON 2013 will t… Continue reading

Posted in General, Podcasts, Server Tuning | Comments Off on OurSQL Episode 123: Storing Bags of Bytes