Learning

OurSQL Episode 71: Table Manners, part 2

This week, we continue our discussion about MySQL and its forks. We discuss the Percona server and MariaDB.

Percona Live comes to Washington, DC on Wednesday, January 11th, 2012 at the Walter E. Washington Convention Center. There is a 50% discount for students, faculty and staff of educational organizations, and a 35% discount for government employees. http://www.percona.com/live/dc-2012/

Percona Server
Percona software

OurSQL Episode 70: Table Manners, part 1

We called this podcast table manners because we are often asked what MySQL fork to use. This is part 1 of a 2-part series. This week we delve into Oracle's MySQL and Drizzle.

News:
There will be a "MySQL and Friends" devroom at FOSDEM 2012 in Brussels, Belgium on Sunday, February 5th, 2012. If you are interested in giving a talk, please submit it before December 26th through the submission form. There will also be a dinner on Saturday February 4th, for anyone making travel plans.

Last week we talked about the debian packages available for MySQL 5.5. We went looking for the packages and could not find the Debian drop-down for downloading MySQL 5.5, but we’re happy to report that the drop-down menu item is there now. http://dev.mysql.com/downloads/mysql/

OurSQL Episode 69: Replication Secret Agent

In this episode we talk about the MySQL Master High Availability Agent, aka MHA.

News

There will be a "MySQL and Friends" devroom at FOSDEM 2012. The dev room is scheduled for Sunday 5th February 2012, whole day. If you are interested to give a talk, please submit it before December 26th through the submission form. You can read the original announcement by Frédéric Descamps.

Meet the MySQL Experts Podcast

OurSQL Episode 67: HA and Replication

This week, we talk about mysql ha and replication.

News/Feedback
Last week we talked about how we learn and keep up to date with changes to MySQL. Mark Grennan of mysqlfanboy.com posted his own list of MySQL resources.

Call for papers for Percona Live: MySQL Conference & Expo 2012 is open until Monday, December 5th. To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

OurSQL Episode 66: Breaking the News Reels

In this podcast we talk about how to keep up with the MySQL ecosystem, and introduce a new segment. We invite you to let us know how you keep up, too. And we've updated our theme song!

News
The Meet the MySQL Experts podcast is now on iTunes. So now you can subscribe to the feedburner feed or to the iTunes feed.

Call for papers for Percona Live: MySQL Conference & Expo 2012 is open until Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, April 12, 2012 in Santa Clara, CA. To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

OurSQL Episode 64: Are We Normal Yet?

This week, we talk about 2NF, 3NF and a bit about normalization vs. denormalization.

News
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open until Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, April 12, 2012 in Santa Clara, CA. To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

Normalization
Book: An Introduction to Database Systems by CJ Date

OurSQL Episode 63: Snowing Already?

This week, Gerry Narvaja guest hosts and we talk about star and snowflake schemas, as a follow-up to last week's podcast on Data Warehousing 101.

News
FOSDEM has a call for papers open until Sunday, November 6th. FOSDEM is one of the largest free and non-commercial open source events, taking place in Brussels, Belgium on February 4th and 5th. There will be a Developer’s room that's near and dear to our hearts called "MySQL, MariaDB and friends".

OurSQL Episode 62: Data Warehousing 101

Josh Berkus of PostgreSQL Experts spoke at OS Bridge this summer on Data Warehousing 101:
Everything you never wanted to know about big databases but were forced to find out anyway (http://it.toolbox.com/blogs/database-soup/data-warehousing-101-slides-video-up-47456 has video and slides)

News
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open! They opened it on Friday, September 15th and the call will close on Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, April 12, 2012 in Santa Clara, CA. To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

OurSQL Episode 61: Security Blankets, Part 2

We go over the open calls for papers, upcoming conferences, conversations with Oracle, and finish up our 2-part series on MySQL security.

Calls for papers:
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open! They opened it on Friday, September 15th and the call will close on Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, April 12, 2012 in Santa Clara, CA.

To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

OurSQL Episode 60: Charming Data

This week we talk with Giuseppe Maxia (pronouncing his name correctly!) about new features in Tungsten replicator, and go over a lot of news.

News:
There was a lot of news this week! There were three really big announcements at Oracle OpenWorld that relate to the MySQL community:

Oracle released a NoSQL database. http://www.oracle.com/technetwork/database/nosqldb/overview/index.html
It’s an ACID-compliant key-value data store, with a Java API for put, delete and get operations and includes replication. The data partitioning and distribution is automatic and based on a hash function.

Pages