OurSQL Episode 173: Time for Percona Live

This week, we talk about the new and innovative talks appearing at Percona Live. Ear Candy is about warming up the innodb buffer pool cache, and At the Movies talks about zero-cost joins.

Pecona Live
Percona Live 2014 is Tuesady April 1st through Friday April 5th at the Santa Clara Convention Center in Santa Clara, California.

Percona Live 2014 conference site

Register for Percona Live - save $100 if you register on or before March 2nd!

read more

Posted in Conferences, Podcasts | Comments Off

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 Hangops - every other Wednesay at noon Pacific time
Upcoming MySQL events, including Tech Tours

Training
SkySQL Trainings
Tungsten University trainings

read more

Posted in Podcasts, Server Tuning | Comments Off

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 GTID replication for high availability.

Obscure Percona Tools
We have talked about Percona tools in many episodes:
Episode 76, Episode 77, Episode 79, Episode 80, Episode 81, Episode 85, Episode 90, Episode 116, Episode 127, Episode 133, Episode 155, Episode 158, Episode 167.

read more

Posted in Learning, Podcasts | Comments Off

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 eventual consistency.

Events
DB Hangops - every other Wednesay at noon Pacific time

FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events

The call for papers for OSCon 2014 is open until Thursday, January 30th

read more

Posted in Learning, Podcasts | Comments Off

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!

Posted in General, Podcasts | Comments Off

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 Pacific time

FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events

The call for papers for OSCon 2014 is open until Thursday, January 30th

read more

Posted in General, Podcasts | Comments Off

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
Percona's sysbench tests

Factors: # tables, concurrency, data set size

Episode 143, where we did an ear candy featuring Morgan Tocker's article on estimating MySQL's working set with INFORMATION_SCHEMA

read more

Posted in Performance, Podcasts | Comments Off

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 Pacific time
FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events

Training
SkySQL Trainings

read more

Posted in Performance, Podcasts, Server Tuning | Comments Off

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 processing needs.

Galera Cluster
Codership documentation of Galera Cluster
Installing Percona XtraDB Cluster on Ubuntu documentation
MariaDB's Galera Cluster documentation

read more

Posted in Learning, Performance, Podcasts, Server Tuning | Comments Off

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.

Events
DB Hangops - every other Wednesday at noon Pacific time

Upcoming MySQL events

Training
SkySQL Trainings
Tungsten University trainings

read more

Posted in Podcasts, Security | Comments Off