Category Archives: Learning

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

OurSQL Episode 162: Exploring Workbench Further

This week we explore MySQL Workbench further. Ear Candy is Stewart Smith’s ‘libeatmydata’ and At the Movies is a video to help folks familiar with SQL learn how to use Riak’s MapReduce.
Events
DB Hangops – every other Wednesay at noon Pacific time
Upco… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 162: Exploring Workbench Further

OurSQL Episode 161: The sharpest tool on the bench

This week we discuss the basics of MySQL Workbench. Ear Candy is using performance schema to find unused accounts, and At the Movies presents XtraDB Cluster.
News
Oracle announced that it is providing yum repositories for MySQL, including MySQL package… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 161: The sharpest tool on the bench

OurSQL Episode 157: More Than One Master

This week we interview Luis Soares about multi-source replication. Ear Candy is about memory allocation with FEDERATED and FEDERATEDX storage engines, and At the Movies is about increasing performance by archiving data.
Download the multi-source replic… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 157: More Than One Master

OurSQL Episode 155: Weaving with Fabric

Actually, this is episode 156, sorry about the error in the title!
This week we interview Mats Kindahl, a MySQL Senior Principal Software Engineer, about the open source Fabric framework for transaction-safe, semi-automatic sharding and high availabili… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 155: Weaving with Fabric

OurSQL Episode 155: Tooling Around, Part 5

In this episode, we finish our series about the MySQL Utilities. Ear Candy is pt-stalk, and At the Movies is a fast parallel query engine.
MySQL Utilities part 5
Part 1 of MySQL Utilities
Part 2 of MySQL Utilities
Part 3 of MySQL Utilities
Part 4 of My… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 155: Tooling Around, Part 5

OurSQL Episode 154: Tooling Around, Part 4

This week we continue our series exploring the MySQL Utilities. Ear Candy is using the performance schema to find out which accounts fail to properly close connections, and At the Movies has a video about databases and determinism.
Part 1 of MySQL Util… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 154: Tooling Around, Part 4

OurSQL Episode 153: Tooling Around, Part 3

This week we continue our series on MySQL Utilities, talking about replication and failover tools. Ear Candy is a gotcha with poor GRANT syntax that MySQL does not give warnings about, and At the Movies is an open forum from the SkySQL Solutions Day a … Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 153: Tooling Around, Part 3

OurSQL Episode 152: Tooling Around, Part 2

This week we continue our series on the MySQL Utilities. In this week’s Ear Candy, we talk about a path problem installing MySQL Utilities on Ubuntu, and At the Movies is a preview of the SkySQL data suite.
Part 1 of MySQL Utilities
Part 3 of MySQL Uti… Continue reading

Posted in Learning, Podcasts, Software | Comments Off on OurSQL Episode 152: Tooling Around, Part 2