Today I was contacted by MySQL, they wanted to know If I mind when the MySQL category of my personal weblog would be added to Planet MySQL. Of course I didn't mind, so here I am...
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
OK, I am not getting too much people feedback on what would they like to hear about on MySQL Users Conference, so I went ahead and submitted few presentation ideas.
I do not expect all of them would be accepted, furthermore it would be hard to prepare so many good presentations if they are so please let me know if anything of this is of special interest for you. When I would be able to show that to organizers to help with decision.
Also let me know if you have submitted similar talk as in this case there may be way to work together to produce better talk instead.
Hidden Innodb Tuning Options Innodb Storage Engine has a lot of tuning options hardcoded as constants. We investigate if current values are truly optimal for modern systems and if you can get any …
[Read more]About three months ago I announced ClickAider to become available to general public. And I think it is about the time to write about the progress we have with this project for those who interested.
The project generates decent interest and we have about 3000 sites Registered over this time, which I consider decent number especially as we did not do much of advertisement and PR keeping it low profile and working out few bugs which we might have.
We use GeoIP DNS based load balancing between "gathering" servers in Europe and US which seems to work very well both providing level of HA if one of the servers goes down and allowing to increase accuracy by reducing round trip. Over time we are planning to get more locations with pair of servers in each so we do not …
[Read more]
Cool, it appears I've been nominated for the 2007 Queensland Pearcey State Award - that's
quite an honour!
The Pearcey Foundation takes its name from Dr
Trevor Pearcey who in 1949 led the team that designed and
built Australia?s first digital computer, CSIRAC, and which was
in fact the world?s fourth digital computer ever to be
built.
Now, coming from The Netherlands I lack a certain amount of
education in terms of Australian ICT history, but I was at the
Melbourne Museum the week before (for the AUUG 2007 conference),
and actually visited CSIRAC
which is (at least some parts) on display there. It features
nifty technology like …
Perhaps I was a little quick to congratulate Neelie Kroes on a job well done forcing Microsoft to extend its interoperability protocols to open source software vendors and developers. It now appears that the terms of the agreement mean that it is incompatible with the GPL.
?I told Microsoft that it had to make interoperability information available to open source developers. Microsoft will now do so, with licensing terms that allow every recipient of the resulting software to copy, modify and redistribute it in accordance with the open source business model,” noted Kroes.
Glynn Moody …
[Read more]
MySQL is listing a good overview of the bugs
they still have open in 5.1
This list comes very handy as I have on my todolist to figure out
which bugs they still have open in 5.1 Cluster to see if we are
impacted by one or more of them.
Now I don't have to manually go trough the lists anymore ..
thnx MySQL !
Perhaps it wasn't entirely clear what the last posting meant by "reentrant". It means that the external language stored procedure can issue a query within the same thread context that executed the stored procedure.
Thanks to the question posed by Bill Karwin, I have tested this scenarios to demonstrate:mysql> lock table mysql.proc write; Query OK, 0 rows affected (0.00 sec)
mysql> call test2('
Recently we have been doing some work with export and import of
data from and to MySql databases. Our customer wants to be able
to export configuration data from one MySql instance and import
it into another.
The obvious tool to use is mysqldump. But since we need to edit
the exported data (just replace some codes) before importing it
into the other instance we use the --tab option. This means that
instead of one big file (or actually redirected standard output)
we get two files per table, one with the CREATE TABLE command and
one with the data.
In the next step we run some scripts to modify the data. This is
quite easy, since data is in text files with one record per
row.
Finally we import the data into the new instance. While the
default mode of mysqldump creates a file you can run in the
command line client, mysqldump --tab does not. You have to create
that yourself, but it is not very complicated. …
Wouldn't it be fun to be able to embed web-service routines into
MySQL as if they are stored procedures?
CREATE FUNCTION xml_current_time() RETURNS DATETIME NO SQL
LANGUAGE XMLRPC
EXTERNAL NAME "xmlrpc://time.userland.com/RPC2;currentTime.getCurrentTime";
Perhaps not a completely useful example... but an interesting
goal to achieve. I have written up some code and pushed it to the
experimental repository. I haven't tested it yet but I may do
later today if I don't get too preoccupied catching up watching
NBC's "Heroes". Snapshots created automagically at midnight,
Pacific time.
Brian mentioned Gemini on his blog... As many
people remember, there was a stunned silence for a while when
Oracle purchased InnoBase OY only 2 years ago... Very similar to
the stunned silence about 6 years ago when the suits at NuSphere
tried to do a SCO. Back on to the topic at hand... Gemini. About
two years ago, Brian fed me a copy of the Gemini engine saying
that "Hey, you remember Gemini? Here's the code. Get it working.
Don't talk about it and call it 'Amira'.". Perhaps not exactly
his words but close enough.
So the Amira project had a shaky beginning... I ported the code
to work on MySQL 5.0 and started examining it, removing
platform-specific code, and improving the performance of it. From
the first working run to the last, I think performance improved
by about a factor of 10 but I don't remember specifics. The Amira
project was cancelled 2Q2006. I suppose …