Many CMDBA (Certified MySQL Database Administrator) candidates
give away points on their exams that could be remedied with a
half hour of exploration. This is not an easy set of exams but
there is something you can do to add points to your score. The
way to do this is to install MySQL on a Windows system.
Many in the FOSS world may never actually touch a Windows system.
But if you look around, you may be able to find an older, unused
system sitting around for this exercise. Many folks have older
windows systems gathering dust that you can borrow.
Once you have the Windows box, here is a three part exercise to
help boost your exam scores.
One: Download and install the Windows binaries. The install
features a wizard to guide you through installation. You will now
have an instance of MySQL on your system.
Two: Track down the configuration files and add a second
instance.
Three: …
Sun completes acquisition of MySQL. Adobe launches open source site, new version of Flex. Bluenog obtains $4m in new funding. (and more)
Sun Microsystems Announces Completion of MySQL Acquisition; Paves Way for Secure, Open Source Platform to Power the Network Economy, Sun Microsystems (Press Release)
Adobe Technology Platform for RIAs Propels Innovation on the Web, Adobe Systems (Press Release)
NewSpring Capital Leads $4mm Investment in Bluenog, Bluenog (Press Release)
[Read more]
For the MySQL users who are still unfamiliar with the new
features of MySQL Enterprise (2007 Fall Edition), I will present
a webinar on this topic on Monday 3rd of March @ 3pm CET. The
webinar will be in Italian, but the slides are rigourously in
English, so if you are interested, just wait approx one week and
you will be able to download slides and recording of this
event.
The latest version of MySQL Enterprise is powered with an
improved version of the Enterprise Monitor, which has a new set
of Replication advisors and new set of cool graphs, to instantly
control your servers. There is also a big improvement in the
overall scalability of the Enterprise Monitor.
During the presentation we will discuss these new features and we
will see the latest improvements in the Enterprise
binaries.
If you are interested in any specific detail associated to this
topic, feel free to comment on this blog or to drop me …
chyrp is a nice
looking piece of blog software. individual posts can have
different styles, something it borrowed from the hosted tumblr service. i was
interested to read about “the sql query massacre of january 19th, 2008”
but the numbers gave me pause — 21 queries to generate the
index page? that is down from an astounding 116, but that still
seems ridiculous to me.
the number of queries to generate the index of this site? two.
one of them is SET NAMES utf8. i could see boosting
that to three or four if i moved some things like the list of
links in the sidebar into the database, or added archive links.
call it five if i had user accounts.
but right now, the number of queries used to load the index page …
Yes, that's correct, it's not a typo. Who needs XML over
RDBMS?
So far, there has been a relatively small group of users who were
demanding more XML features within or combined with MySQL.
Perhaps it's because XML is not a big deal in the classic LAMP
implementation of web-based services, but the more we penetrate
the Enterprise market, the more XML is becoming an interesting
topic. I am quite sure that we will move from the classic "nice
to have" to the typical "commodity feature" in quite a short
time, especially if we will improve our presence as the back end
DB for J2EE apps and web services.
Let's be honest, the new nice XML features in 5.1 are still away
from a good and proper XML coverage. They are great if we are
going to store XML elements within columns of a table, but they
are not really helpful if we need to use an XML interface to
interact with our DB.
For what it's worth, although the fat 4 (Oracle, …
There is a big event for the London Meetup Group coming up next week. We will
all meet on Wednesday 5 March @ 7pm
The location: The Lamb
4 Lambs Conduit St
Bloomsbury
London
WC1N 3LZ
We will have a very special guest: Marten Mickos, CEO of MySQL
(now in his new role, due to the Sun acquisition). Marten will
join us and he will be happy to answer to questions, to share
opinions and spend some good time with MySQL Brits users in front
of a nice drink (no surprise which one will be the best seller :)
).
From a technical point of you, I have prepared a short
presentation on MySQL Proxy, with a basic intro on the project
and with some ideas on how to use it and what to expect from a
production version. The slides will be uploaded after the
venue.
As usual, I am open to suggestions and topics to …
The only thing worse than being talked about is not being talked
about --Oscar Wilde
The table below shows the popularity of the data warehousing tools as determined by the
number of the Google search results. There are only a few
surprises, and you can easily arrive at your own conclusions.
Just keep in mind that popular does not necessarily translate
into good1.
| Search phrase | Result count |
|
| "SQL Server" BI | 2,200,000 | ||||||||||||||||||||||||||| |
| Excel BI | 771,000 | ||||||||| |
| Oracle BI | 403,000 | …
At $WORK we typically use Redhat Cluster to make MySQL highly available. We have a number of 2-node clusters (active/passive) and it works nicely, for the most part. One thing I find very annoying is RHCS has no notification framework to notify you when a service is relocated to another node (because of failure or otherwise.)
In a perfect world, the only reason MySQL would pass between nodes is for server maintenance, under the control of a human. In reality, crap happens. Redhat Cluster manages all this, but I still want to know that a failover happened (is hardware going bad? did a software bug cause a failure? etc.)
Most monitoring tools weren’t designed to report on a clustered service. I can add a check that connects to MySQL using the cluster-managed IP - but that only tells me if MySQL has failed completely. The failover between nodes generally takes under a minute so it’s easy for that type of monitoring check to miss a …
[Read more]Alfresco's CEO, John Powell, wants and expects Alfresco to IPO. He thinks it will show the world that open source offers long-term staying power. John Roberts at SugarCRM is disappointed that MySQL didn't go public to provide evidence that open source is a viable business phenomenon.
Good points. ...