Electing a slave as new master and aligning the other slaves to the new master

In a simple MySQL Replication set-up you have high-availability (HA) on the read side (r). But for the master which covers all the writes (w) and the time critical read (rt) there is no HA implemented. For some situations this can be OK. For example if you have rarely writes or if you can wait until a new Master is set up.

But in other cases you need a fast fail-over to a new master.

In the following article it is shown how to implement the election of a new master and how to align the slaves to the new master.

We can have two possible scenarios:

1. This scenario assumes, that every slave can become the new master.
2. This scenario assumes, that only one dedicated slave will become master.

The advantages and disadvantages of both scenarios:

Scenario 1
+ You …

As open-source vendors grow in strength, the value of source code diminishes as a guard against vendor lock-in. READ MORE

On monday I gave a presentation at MySQL user group meeting in Hamburg on the team I’m working for: the MySQL Connectors team. The presentation was given in german. Unfortunately about 99.99999% of all PlanetMySQL had no chance to join the meetup, but you can find the slides (german language) here for download (PDF). The slides give an overview on the team, its products and its activties. You will also find introduction material on those Connectors (drivers) I am working on: Connector/OpenOffice.org, Connector/C++ and all the PHP stuff.

(...)
Read the rest of Slides (german) from MySQL Connectors talk at the Hamburg MySQL Meetup (48 words)

On monday I gave a presentation at MySQL user group meeting in Hamburg on the team I’m working for: the MySQL Connectors team. The presentation was given in german. Unfortunately about 99.99999% of all PlanetMySQL had no chance to join the meetup, but you can find the slides (german language) here for download (PDF). The slides give an overview on the team, its products and its activties. You will also find introduction material on those Connectors (drivers) I am working on: Connector/OpenOffice.org, Connector/C++ and all the PHP stuff.

(...)
Read the rest of Slides (german) from MySQL Connectors talk at the Hamburg MySQL Meetup (48 words)

Valleywag is reporting that Michael ("Monty") Widenius, primary author of the original MySQL database and one of the company's founders, turned in his resignation to Sun yesterday. For those inside the MySQL team at Sun, this will likely prove bittersweet.

Bitter, because Monty has been such an important architect ...

Following the recent news rumours about Monty leaving MySQL, I just wanted to tell you that Brian Aker is giving a keynote speech about "To Drizzle MySQL" on this year's International PHP Conference at Mainz, Germany which is happening from October 27th to October 31st:

One of the most common databases to developers, MySQL, got forked again, to bring back the original spirit of Open Source to the MySQL Community. The International PHP Conference invited Brian Aker, one of the leading forces behind this move, to talk about how "to Drizzle" MySQL.

If you want to join Brian's keynote and all the …

On monday I gave a presentation at MySQL user group meeting in Hamburg on the team I’m working for: the MySQL Connectors team. The presentation was given in german. Unfortunately about 99.99999% of all PlanetMySQL had no chance to join the meetup, but you can find the slides (german language) here for download (PDF). The slides give an overview on the team, its products and its activties. You will also find introduction material on those Connectors (drivers) I am working on: Connector/OpenOffice.org, Connector/C++ and all the PHP stuff.

I have not been giving any Community presentations since 2003, be gentle… Credits to:

• Lenz for organizing the meeting
• Judith and Tobi for providing the meeting facilities at SinnerSchrader
• … and all listeners …

Kristian Köhntopp posted the following (German speaking) blog entry: "Monty on the run" stating that Monty quit his job at MySQL/Sun. He wonders where Monty's new job will be...

If you followed the last months, Brian Aker and some other people forked the MySQL codebase and created the Drizzle project. I'm wondering if Monty might spearhead the Drizzle project soon?! If yes, does this move harm the commercial database field? What might Enterprise customers think? Is Community everything or would this move make any harm to MySQL as an affordable OpenSource database itself? We'll see...

Sheery has more news...

UPDATE: Kaj Arnö, MySQL's VP …

ValleyWag reports that MySQL’s Monty Widenius is no longer “MySQL’s”. Some folks have known that Monty has not been happy in his current position; this leads me to believe the rumor is true (though of course an official announcement is the only confirmation).

So what does this mean for MySQL? Well, honestly, if a product falls apart because one out of 300 employees leaves, it was probably doomed anyway. There are plenty of capable employees left, and being owned by Sun means that there are many more resources they can tap as well.

What will the official company announcement be? My prediction is (more…)

Is it that time already? MySQL Conference & Expo 2009 has opened the CFP.

Submit (well) early and often. It’s always an exciting (and exhausting) conf. Good technical, relevant content is what makes it good. Getting to talk to people who do amazing things, people who use your software, people looking to use it, people who want to chat about how you can learn off each other.

Any suggestions for what you’d like to hear from me (Cluster, Drizzle et al) are welcome - either via private mail or comments here.