Category Archives: Podcasts

OurSQL Episode 172: A New Proxy

This week, we talk with Ivan Zoratti of SkySQL about MaxScale, a new MySQL proxy. Ear Candy is about accidentally removing a dependent package, and At the Movies is a DB Hangops recording of MaxScale, replication saturation and monitoring.
Events
DB Ha… Continue reading

Posted in Podcasts, Server Tuning | Comments Off on OurSQL Episode 172: A New Proxy

OurSQL Episode 171: Another Round of Toolkit

This week we discuss more tools in the Percona Toolkit – pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTI… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 171: Another Round of Toolkit

OurSQL Episode 170: Auto-failover, part 2

This week we discuss administering Percona Replication Manager. Ear Candy is about repository packages from MariaDB and Oracle, and At the Movies presents a Riak engineer talking about “convergent replicated data types” – data structures that tolerate … Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 170: Auto-failover, part 2

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 167: Data, Data Everywhere

This week we discuss test data sets. Ear Candy is errata from Episode 165 on Galera Cluster, and At the Movies is “Runaway Complexity in Big Data”
Test Data Sets
Episode 81, where we talked about different benchmark tools
Sysbench – general version
Per… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 167: Data, Data Everywhere

OurSQL Episode 166: Top Hat Options

This week we discuss fine-tuning Galera Cluster. In this week’s ear candy we talk about recent changes to mysqldump and locking; At the Movies presents “Using Amazon Web Services for MySQL at Scale”.
Events
DB Hangops – every other Wednesay at noon Pac… Continue reading

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 166: Top Hat Options

OurSQL Episode 165: Top Hat Cluster

This week we talk about how to install and set up Galera Cluster. Ear Candy talks about the new MySQL repos from Oracle and what to know about using them; At the Movies is Michael Stonebreaker talking about how to process today’s big data transactional… Continue reading

Posted in Learning, Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 165: Top Hat Cluster

OurSQL Episode 164: Who’s Doing What?

This week we talk about how to install and use the MariaDB Audit plugin, and what the audit log looks like. Ear Candy presents a gotcha with MySQL and temporary directories, and At the Movies is about using Dynamo for more than just a data store.
Event… Continue reading

Posted in Podcasts, Security | Comments Off on OurSQL Episode 164: Who’s Doing What?

OurSQL Episode 163: Moving Along

This week we discuss MySQL’s Migration Toolkit. Ear Candy is about the replication format as it propagates through multi-tier master and slaves; At the Movies is Distributed Data Analysis with Hadoop and R.
MySQL Migration Toolkit
Episode 161 where we … Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 163: Moving Along