|
This week we talk to Giuseppe Maxia about MySQL Sandbox. Ear Candy is about table_open_cache, Open_tables and Opened_tables, and At the Movies features MariaDB.
MySQL Sandbox
MySQL Sandbox
Examples:
MariaDB slave of a master:
make sandbox mysql-tarball --master
make sandbox mariadb-tarball --slaveof master-port=fooExporting:
./my sqldump instancenameRemote mysql sandbox deploy:
deploy remote sandboxes -m MySQLVer -l list,of,serversThis week we discuss different filesystems and how they work. Ear Candy talks about the "-bibyte" suffix, and At the Movies presents an indexing webinar.
Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd.
OSCON 2013 will take place in Portland, OR from Monday July 22nd through Friday July 26th. The call for Speakers closes at midnight Pacific Time on Monday, February 4th.
LinuxFest Northwest will take place on Sat Apr 27th and Sun Apr 28th. The call for papers is open and you can submit proposals through Thursday Feb 28th.
This podcast would not achieve its goal if there were no listeners to learn about MySQL. This week we play a bunch of bloopers as our year-end gift to you. We hope these make you laugh!
This week, we finish our series on the Operations Report Card as it applies to database administrators. In Ear Candy, we discuss one problem with setting table_open_cache higher than needed., and At the Movies is Tools and Techniques of Index Design by Bill Karwin.
News
MariaDB 10.0.0 alpha is out, including the SHOW EXPLAIN FOR thread_id feature for running an EXPLAIN on a running query, and multi-source replication.
This week, we continue our series going through the Operations Report Card as it applies to database administrators. This week in Ear Candy, we talk about a hidden client value for max_allowed_packet (separate from the session variable). In At the Movies, we present Karen Tegan Padir of Enterprise DB presenting The More Things Change, the More They Stay the Same.
Events
Oracle's "Scale with MySQL" seminars:
Madrid, Tuesday 27 November
This week we continue part 3 of the Operations Report Card and how it relates to database administration. This week we talk about the section on "Operational Practices", and it covers how operations are run. In Ear Candy we present different tools for finding a machine's external IP address, and in At the Movies we present a video about MySQL Security from when Sheeri was touring Latin America in July.
Feedback
Webyog's blog noted that the OurSQL blog/podcast was among the Top MySQL Blogs You Should Be Reading. Thanks for your support!
This week, we go through the "Modern Team Practices" part of the Operations Report Card, and how it applies to DBAs.
Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October
Bucharest Romania, Tuesday 13 November
Madrid, Tuesday 27 November
This is part one of a series where we will explore the Operations Report Card and explain how it applies to DBAs. Listen and grade your own organization, this is a great opportunity to get some new ideas on how to organize your department and make your job more efficient and streamlined.
News
Alaska Airlines system crash
Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October
This week we present part 2 of our interview with XKCD's Randall Munroe, where we finish talking about data privacy and security, and talk about Randall's real-life ball pit in his apartment, and his thoughts on fanny packs.
Defending your Life - romantic comedy movie
The ball pit - the blog post with pictures and notes.
This week we present the 100th episode (yes, we started at episode 0), which is part 1 of a 2 part interview with XKCD's Randall Munroe.
OurSQL Podcast history
Episode 0 was on November 26, 2006.
Episode 26 on December 16, 2010 added Sarah Novotny as the first co-host and we hired our audio engineer and producer, Rich Goyette, due to the support of Justin Kestelyn and the Oracle Technology Network.
This week we talk about numeric data types in MySQL.
News/Events/Feedback
OurSQL Listener Jesper Hansen was nice enough to take a screen shot of episode 0 of the ourSQL podcast hitting 12,345 downloads.
Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!
In this episode we talk about string data types, comparing them to the ISO:2003 SQL standard.
Gerry has joined Tokutek - Congrats Gerry! We interviewed Martin from Tokutek in episode 86.
Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!
This week we present how to use pt-archiver and pt-find, two Percona Toolkit tools. We focus on the common usage of the tools and the gotchas we ran into using them.
News/Events/Feedback
Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!
This week we talk about MariaDB - explaining features, and comparing to Percona's patched MySQL and Oracle's MySQL. MariaDB is touted as "a better MySQL, not a different MySQL". MariaDB is the 2nd most popular open source database, even more popular than Postgres.
Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!
This week we talk about package and configuration management with MySQL.
News/Events:
Don't forget to send us questions to answer for future versions of Ear Candy, see the "Feedback" section below.
There are 2 free webcasts on Efficiently deploying new MySQL applications on Windows coming up: in French on Thursday April 5th and in German, on Thursday, April 19th.
