Monthly Archives: May 2011

OurSQL Episode 47: Replication logs and 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)
Can also say “PURGE MASTER LOGS”

read more

Continue reading

Posted in Podcasts | Comments Off on OurSQL Episode 47: Replication logs and objects

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 t… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 46: It’s About Time

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

At Open Database Camp in Sardinia last week, there was a hackfest to try to get replication working from MySQL to 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 … Continue reading

Posted in Conferences, Podcasts | Comments Off on OurSQL Episode 45: Hackathon Success! (MySQL -> MongoDB replication)

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, inc… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 44: Elemental Replication (Tungsten, that is)

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.
S… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 43: Repli-cans and repli-can’ts