Monthly Archives: August 2017

OurSQL Episode 199: Make It Fast

This week, we discuss common MySQL performance tips.
Continue reading

Posted in Performance, Podcasts, Query Optimization, Server Tuning | Comments Off on OurSQL Episode 199: Make It Fast

OurSQL Episode 200: Information Security and Privacy

For our 200th episode, we interview security expert Bruce Schneier. We talk about plenty of topics including airport security and the TSA, PRISM and the NSA, wholesale surveillance, surveillance backwards in time, finding people who have disposable cel… Continue reading

Posted in Podcasts, Security | Comments Off on OurSQL Episode 200: Information Security and Privacy

OurSQL Episode 201: What are you doing?

This week we discuss user statistics in the MariaDB and Percona forks of MySQL. Continue reading

Posted in Learning, Performance, Podcasts | Comments Off on OurSQL Episode 201: What are you doing?

OurSQL Episode 202: Scaling by Proxy

This episode we start a 2-part series on MaxScale, a scaling proxy for MySQL. Ear Candy is OS Query and At the Movies is about MaxScale.
Continue reading

Posted in Learning, Performance, Podcasts | Comments Off on OurSQL Episode 202: Scaling by Proxy

OurSQL Episode 203: Scaling by Proxy Part 2

In this episode we finish our series on MaxScale. Ear candy is about using MySQL and Galera for geographic replication, and at the Movies uses MySQL to build big data applications.
Continue reading

Posted in Learning, Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 203: Scaling by Proxy Part 2

OurSQL Episode 204: Just For Laughs

When we went monthly at the end of 2014, did you worry that we would forget our blooper show? This month’s podcast is a blooper reel just for you – about 35 minutes of put-a-smile-on-your-face fun with insight as to how things work – or don’t work – be… Continue reading

Posted in General, Podcasts | Comments Off on OurSQL Episode 204: Just For Laughs

OurSQL Episode 205: How to Learn About MySQL

In this episode, we discuss resources available for learning more about MySQL and its forks.
Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 205: How to Learn About MySQL

OurSQL Episode 206: Pieces of Fabric

In this episode we discuss sharding and high availability with MySQL Fabric, including installation and configuration. Ear Candy is rolling out GTIDs with no restarting, and At the Movies is putting MySQL Fabric to use, including a live demo.
Continue reading

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 206: Pieces of Fabric

OurSQL Episode 207: Looking Forward

In this penultimate episode, we talk about what’s coming in MySQL 5.7 and MariaDB 10.1. Ear Candy is about a new MySQL 5.7 utility to generate the SSL RSA keys to encrypt MySQL communications, and At the Movies is about MySQL’s new features.
Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 207: Looking Forward

OurSQL Episode 208: Looking Back

In this episode we discuss our timeless podcasts. For those who are new and listening for the first time – welcome! This podcast is a great jumping off point to learn about specific topics we’ve covered. If you have been with us for some or all of the … Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 208: Looking Back