Home |  FAQ |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français
Showing entries 1 to 10 of 12416 Next 10 Older Entries
MySQL Slave Delay Explained And 7 Ways To Battle It

http://forge.mysql.com/w/images/1/1e/Dolphin_Laptop_cropped-386x222.jpgSlave delay can be a nightmare. I battle it every day and know plenty of people who curse the serialization problem of replication. For those who are not familiar with it, replication on MySQL slaves runs commands in series - one by one, while the master may run them in parallel. This fact usually causes bottlenecks. Consider these 2 examples:

  • Between 1 and 100 UPDATE queries are constantly running on the master in parallel. If the slave IO is only fast enough to handle 50 of them without lagging, as soon as 51 start running, the slaves starts to lag.

  [Read More...]
Log Buffer #113: A Carnival of the Vanities for DBAs

This is the 113th edition of Log Buffer, the weekly review of database blogs.

Sheeri Cabral gets things going this week with her coverage of this rumour: Monty Widenius Leaves Sun/MySQL. If it turns out to be true, that seems like bad–or at least sad–news for MySQL, but Sheeri’s take is mostly an optimistic one.

MySQL’s Kaj Arno responds to the rumours on Monty resigning: “First, it?s a rumour.  . . .  Second, Monty?s resignation has been a possible outcome

  [Read More...]
Employee Active/active fail over cluster with MySQL Replication
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


  [Read More...]
Employee Pimp My Workbench

Some weeks ago there was a request about adding a feature that keeps (or gets) datatypes of colums, which are connected via foreign keys, in sync. While we have added this to our ToDo list, I thought of doing some simple LUA exercises to give the user at least a funtion to check if the FKs in the model all have columns with matching datatypes.
As it turned out such tasks can be done quite easily using our GRT-shell. And by writing some functions you can add features to Workbenchs interface.

To get in touch with the shell/GRT environment inside Workbench click the tiny black prompt-window-icon in the top right area of workbench (or choose ‘View->Advanced->GRT Shell’ from the main menu).  Some items in the UI are swapped/added: the sidebar on the right side gets a new tab named ‘GRT Shell’ featuring some more tool-panes (GRT Tree, Modules, Inspector) and on the


  [Read More...]
Employee MySQL Workbench 5.0.25 coming next week

As you may have noticed we’re going for a major milestone on our Workbench 5.1 roadmap. So our resources are pretty much concentrated on this  task at the moment. But it’s just as important to keep improving our 5.0 GA version, so we will reserve the first days next week to make progress here as well. We will publish the next release of 5.0 mid-next-week. So stay tuned for a better 5.0 next week and the upcoming 5.1 alpha later this month.

Has MySQL founder and CTO resigned from Sun?

Valleywag reports that Monty Widenius has quit Sun. The Pythian Group reckons its true. Kaj Arno’s non-denial denial would appear to confirm it despite his protestations otherwise.

“Technically there is no resignation letter. However, I spoke to Monty yesterday, and yes, resignation is an option he considers,” writes Kaj before expanding on some of the reasons that Monty might consider leaving

  [Read More...]
Employee The rumours on Monty resigning

We have a rumour of MySQL co-founder Michael “Monty” Widenius resigning, as posted by Valleywag and expanded by Sheeri Kritzer Cabral.

Monty

Usually, I wouldn’t comment on rumours. But as I’ve been asked copious amounts of questions, let me make an exception today.

First, it’s a rumour. Technically there is no resignation letter. However, I spoke to Monty yesterday, and yes, resignation is an option he considers.

Second, Monty’s resignation has been a possible outcome already since years before the Sun

  [Read More...]
MySQL's Monty Widenius leaves Sun

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 ...

Employee LinkedIn's MySQL Certified Professionals Community
Mark Schoonover has asked me to take over the LinkedIn Group for MySQL Certified Professionals. We are still working out the details but I would like to ask the almost 200 members of that group and any potentially interested others what they would like to see this professional community become.

Personally, I am going to need a platoon of MySQL Exam beta test guinea pigs and this group looks like a great source for talent people.

But what do the members want?

Cisco gives accounts with CCIEs on staff a percentage discount on support contracts? They also get an escallated queue for any support calls. The logic behind that is that a CCIE would not call on something trival and would have triaged the problem. Is this something for this group?

Or do we need t-shirts? Mugs? A special room (rubber padded, drool absorbant carpet)







  [Read More...]
Access to source code doesn't trump vendor control
As open-source vendors grow in strength, the value of source code diminishes as a guard against vendor lock-in. READ MORE

Showing entries 1 to 10 of 12416 Next 10 Older Entries