Our third keynote at MySQL Conference 2007 was titled Building the Ultimate Database Container with RHEL, MySQL, and Virtualization by Michael Evans. The presentation was on Red Hat & One Laptop Per Child.

Another great keynote at the 2007 MySQL User Conference is Michael Evans form RedHat talking about the One Laptop Per Child project. Pretty incredible the things they are doing.

Michael makes a lot of great points, I think this video sums it up nicely:

I get this question a lot. Why does a slave report that it's trying to replicate from an impossible position? 9 times out of 10 it's because the master crashed and when it came back online a new binlog file was made.

mySQL caches binlog events in the binlog cache, basically events are stored in memory and flushed to disk when the dirty buffer fills up. I believe the variable is called binlog_cache_size.

Here are some steps to recover from this:
Go onto the master execute

SHOW MASTER STATUS

Look at the output and find the log that the slave is pointing to. Look at the File size field.


Next look at the slave output from the slave reporting the issue. Look at Exec_Master_Log_Pos, is that value greater then the File Size on the master if so issue


CHANGE MASTER TO MASTER_LOG_FILE=[NEXT FILE], MASTER_LOG_POS=4;
slave start;
…

Without missing a beat at MySQL Conference 2007, we moved from Marten’s keynote to The Art of Innovation by Guy Kawasaki.

Extremely fun and entertaining. His 10 points.

1. Make Meaning

• “To change the world”
• To a VC, do not say “you want to make money”, that is understood. You will attract the wrong team.

2. Make Mantra

• Not a Mission statement (50-60 words long), but 2 or 3 words.
  • Wendy’s - “Healthy fast food”
  • Mike - “Authentic Athletic Performance”
  • FedEx - “Peace of Mind”
  • eBay - “Democratize commerce”
• Create a mantra — Why do you exist?

If you get stuck try the …

Without missing a beat at MySQL Conference 2007, we moved from Marten’s keynote to The Art of Innovation by Guy Kawasaki. Extremely fun and entertaining. His 10 points. 1. Make Meaning

As I mentioned in MySQL Conference – Rewarding the Community , Paul McCullagh, the creator of the Community Transactional Storage Engine PBXT won the Community Code Contributor of the Year award.

As I mentioned in MySQL Conference - Rewarding the Community, Paul McCullagh, the creator of the Community Transactional Storage Engine PBXT won the Community Code Contributor of the Year award.

A photo for Paul. Great work.

It’s an early start this morning at 8:20am at MySQL Conference 2007 with CEO Mårten Mickos keynote talk Welcome and State of MySQL AB.

Here are some of the key points that impressed on me.

“The Participatory & Disruptive spirit of the Dolphin.”.

Open Source disrupts inefficient models and produces new wealth.

Architecture of Participation.

• GPL and FOSS licenses
• Google
• del.ico.us

MySQL Architecture of Participation
You have the forge, the planet, community contributer program and many more.

Production of Amateurs

• You Tube
• Second Life
• Wikipedia

Some really great Quotes:

“Fail often to succeed …

It’s an early start this morning at 8:20am at MySQL Conference 2007 with CEO Mårten Mickos keynote talk Welcome and State of MySQL AB. Here are some of the key points that impressed on me.

At MySQL Conference 2007, CEO Mårten Mickos in his opening keynote Welcome and State of MySQL AB rewarded the community. Those that contributed to “The best database in the world”.