Podcasts

OurSQL Episode 48: Percona Live NYC 2011

This week we have feedback from Percona Live in NYC last Thursday. We talk with:

Chander Kant of Zmanda, talking about the fact that Zmanda Backup Recovery now officially supports the Percona patched binary of MySQL.
Barry Leung of CafeMom.com who talked about all the stuff he'd learned during the day, including "How to use MySQL and DTrace on Linux" and the new mk-tcp-model.

Patrick Galbraith of BlueGecko talked about his talk, "The Building Blocks of Scaling: Drizzle/MySQL, Memcached, Sphinx, and Gearman", backups, FLUSH ENGINE ____ LOGS, and covering indexes.

OurSQL Episode 47: Replication logs and objects

This week, we talk about replication logs and replication objects.

Feedback: Via Henrik Ingo
- Drizzle has microsecond granularity for timestamp. MariaDB just
developed a patch for that, in the 5.3 tree.

http://docs.drizzle.org/date_time_data_types.html
http://kb.askmonty.org/search/?q=microsecond
http://kb.askmonty.org/v/what-is-mariadb-53
editors note: updated with a specific link from Henrik

More Replication

Purging binary logs:
manual:
PURGE BINARY LOGS TO ‘mysql-bin.12345’;
PURGE BINARY LOGS BEFORE ‘datetime’; (can use string or date expression, like NOW()-interval 5 DAY)

OurSQL Episode 46: It's About Time

This week we talk about time formats and time zones in MySQL - including how changing the system time changes TIMESTAMP values but not DATETIME values. We also talk about how to handle and store microseconds in MySQL.

From the MySQL manual:
date and time types
TIMESTAMP properties and how it is stored in UTC transparently in the database
ALLOW_INVALID_DATES sql_mode

OurSQL Episode 45: Hackathon Success! (MySQL -> MongoDB replication)

At MongoDB. In only 2 hours and 45 minutes, a small group of hackers did it! This week I interview Flavio Percoco, the MongoDB guru on the team, who talked about getting replication from MySQL to MongoDB working via last week's podcast).

OurSQL Episode 44: Elemental Replication (Tungsten, that is)

Last week's podcast, containing an overview of replication

This week we have Robert Hodges, CEO of Continuent, talking about the Tungsten replicator, which has an open source component with global transaction id's and can be used for many features, including high availability and replication to systems other than MySQL. Tungsten Replicator won Application of the Year award at the 2011 O'Reilly MySQL Conference.

OurSQL Episode 43: Repli-cans and repli-can'ts

Note: We said this was episode 44, but it's really episode 43!

In this episode we give the basics of how replication works, giving knowledge about the fundamentals about replication to better understand why it has certain limitations and benefits.

Slave IO thread states in SHOW PROCESSLIST
mk-table-checksum
MIXED binary log format defaults to STATEMENT, unless certain conditions apply, which are listed at that link.

OurSQL Episode 42: The Buzz about MySQL 5.6

This week we talk about what's new in MySQL 5.6 and the return of labs.mysql.com. We also feature people's reactions to the 5.6 announcement and a special song by Solomon Chang (lyrics below).

Show notes:
If you want to see it for youreslf, there is a video from the O'Reilly Conference of Tomas Ulin's Keynote, "State of the Dolphin".

Olav Sandstå's blog post on index condition pushdown optimization.

OurSQL Episode 41: Zmanda [backup series #6]

Previously in the backup series:

Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)
Backup Series #4: Advanced Logical Export Features (advanced mysqldump)
Backup Series #5: Xtrabackup

This week we talk with Chander Kant, CEO of Zmanda, about how Zmanda Recovery Manager makes backup and recovery of MySQL backups very easy, whether you are using storage level snapshots, hot backup tools or even logical backups. Full and incremental backups (and restores!) are made simpler with the community (free) version and with the enterprise (commercial) version.

OurSQL Episode 40: TokuDB 5.0 part 2

This week we conclude the interview with Tokutek's co-founder and Chief Scientist, Martin Farach-Colton. Part 1 of the interview. TokuDB is a transactional, fully ACID-compliant storage engine that uses fractal trees for data and indexes, instead of MySQL's standard B-tree implementation. Combined with TokuDB's message-based architecture, TokuDB data and indexes do not fragment, have completely online column and index addition and removal and unlike InnoDB and XtraDB, do not fall apart when indexes no longer fit into memory.

OurSQL Episode 39: TokuDB 5.0 part 1

TokuDB is a transactional, fully ACID-compliant storage engine that uses fractal trees for data and indexes, instead of MySQL's standard B-tree implementation. Combined with TokuDB's message-based architecture, TokuDB data and indexes do not fragment, have completely online column and index addition and removal and unlike InnoDB and XtraDB, do not fall apart when indexes no longer fit into memory.

We spoke with Martin Farach-Colton, co-founder and Chief Scientist of Tokutek about the TokuDB storage engine, including the new features in TokuDB 5.0, which was announced on Tuesday.

Pages