Category Archives: Learning

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

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

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 189: Syncing Both Ways

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

Posted in Learning, Podcasts, Software | Comments Off on OurSQL Episode 188: Back in Sync

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

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 187: Hanging Out

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