Hello,

Please join us on one of our upcoming webinars entitled "Designing, Evaluating and Benchmarking MySQL Cluster"...

North America
August 8 @ 10 AM PDT

EMEA
August 15 @ 3:00 PM CET

For registration details:

http://www.mysql.com/news-and-events/web-seminars/

In this webinar learn the fundamentals of how to design and select the proper components for a successful MySQL Cluster evaluation. We will explore hardware, networking and software requirements. Work through a basic installation, functional testing. Finally, we will close with an examination of the recent benchmark results performed in conjunction with Intel and Dolphin Interconnect Solutions.

In case you missed Johan's post earlier today, we've also put together an evaluation guide for MySQL Cluster which goes into more detail on the topics covered in the webinar. Look …

How can you evaluate if MySQL Cluster is a good fit for you or not?
Me myself and Jimmy Guerrero (Snr Product Manager) has written a whitepaper about it.

Of course, answering that question is not easy, but in the whitepaper we present ideas for how to make it easier and to increase your chances of success whether it is evaluating MySQL Cluster for a migration project or designing a new mission critical database application where high performance, scalability, and high availability are key requirements.

Jimmy will also have a Webex on the subject:
Wednesday, August 08, 2007, 10:00 am PDT, 1:00 pm EDT, 18:00 GMT
and you are very welcome to register here


Also, I want to mention my friend Jim Dowlings's work on a few scripts …

From OpenSuSE's MySQL 5.0.41-1 changelog:- renamed subpackages according to library packaging policy:
  mysql-shared -> libmysqlclient15, libmysqlclient_r15
  mysql-devel -> libmysqlclient-devel (pulls in both flavors)Thanks. It was time.

I’ve heard from the guys at MySQL that the configuration of Heartbeat communication paths in ha.cf seems to be confusing to some. So, here’s our best practice summary:

• Never configure fewer than two communication paths. And I mean, never. Never. If you do, that’s an accident (read: split brain) waiting to happen.
• On the device that you run your DRBD replication over, if it uses a direct back-to-back connection to the peer node (like it should), configure a bcast link. Simple and easy to configure, and since you’re not sharing that link with anything other than DRBD replication, those broadcast packets won’t harm or …

Here is my notes on setting up replication on MySQL. In a lot of cases, that is not good enough, because it replicates EVERYTHING from the master to slave(s), whereas you may just want one or two databases replicated.

At first I thought I could just add this to /etc/my.cnf on the slave:
[mysqld]
replicate-do-db=MyDb

That didn’t work very well for statements like this, assuming you are in a database other than MyDb:

insert into MyDb.TableInMyDb values (SomeValue)

Fine, I thought, let me add this to slave’s my.cnf:

replicate-wild-do-table=MyDb.%

It’s not enough. For the Sql statement above, it still couldn’t catch and execute that statement.

After some searching and testing, I found what I was looking for. As far as I can tell, it works beautifully. All you need to do is to modify my.cnf on slave. Just add the databases to ignore in the list. Below is a …

Lenovo and Novell announce deal to preload SUSE Linux. Linspire CEO resigns. Red Hat teams with Creative Commons on Fedora content. (and more)

Lenovo and Novell To Offer Linux Preload on ThinkPad Notebooks, Novell / Lenovo (Press Release)

Fedora and Creative Commons Team Up To Deliver LiveContent Distribution, Red Hat (Press Release)

HP Drives Customer Adoption of Open Source and Linux in the Data Center, HP (Press Release)

LiMo Foundation Announces Membership Surge, LiMo Foundation, (Press Release)

…

There was a problem with improper characters apprearing in the content of one of the feeds. This caused a tag mismatch error in the XML parsing of the feed files and thus weren't showing up in Firefox and Thunderbird (possibly others). The feed has been removed and this has solved the problem.

I worked out these rules from speaking at MySQLcon, and attending OScon this year.

• Speaking at geek conferences is fun.
• Don't put your talk on your slides!
• Don't put everything on the slides, don't put the outline on your slides, don't put a lot of stuff on the slides.
• Put questions on the slides, instead. Each question is the one you answer while that slide is up.
• You can occasionally have an answer, a good quote, or a graphic.
• If someone can't QUICKLY write down what is on the slide, it's too complex.
• Do write speaker notes. Make them as complete as possible. Try to memorize them, but don't just recite them. You can refer to them if you have to during your talk.
• Practice your talk at least once. Check time. You may feel silly talking to yourself in front of the wall, but you will feel dumb instead if you run way …

Event: Zmanda Management Console for MySQL Backup - presented by Zmanda on Wednesday, August 22, 2007.

One of the simplest performance and load tests that can be performed on any web server is to measure the response time of a static HTTP GET request. If you measure how this response time degrades as more parallel connections issue the same request, you can get a basic understanding of the performance and scalability of a web server.

Anyone who's worked with Apache long enough is probably familiar with ab, the  load generator/benchmarking tool which is so wide-spread. This is a sad state of affairs as 'ab' is extremely flawed. I don't want to repeat it's flaws here, as Scott Oaks has done an excellent job of summarizing them. 

Another tool that is also popular is http_load, …