Ideas, releases, practical guides, and perspectives from the people building with MySQL.
OK... This is my second entry on this blog. And it is about something I want every mysql/php newbie to know at the starting gate:
DON'T USE CHAR(15) FOR IP Address fields in mysql!
Well... what about the periods in ip addresses, you say?
Well... mysql has a FANTASTIC way of solving this issue! Convert the standard ip address into an unsigned integer!
ok... at first it sounds a little
Hello everyone, I think this will be a great log buffer. Dave has been sick these past two days and as a result, we do not have a comprehensive log buffer ready the way we or a volunteer usually do. This was bound to happen to log buffer at some point and today it has happened. So I [...]
How fast do you want your installation? Check this.
$ time ./express_install.pl ~/downloads/mysql-5.0.45-osx10.4-i686.tar.gz --no_confirm unpacking /Users/gmax/downloads/mysql-5.0.45-osx10.4-i686.tar.gz Executing ./install.pl --basedir=/Users/gmax/downloads/5.0.45 \ [...] Installing MySQL system tables... OK Filling help tables... OK [...] loading grants sandbox server started installation options saved to current_options.conf. To repeat this installation with the same options, use ./install.pl --conf_file=current_options.conf ---------------------------------------- Your sandbox server was installed in /Users/gmax/msb_5_0_45 real 0m6.773s user 0m0.245s sys 0m0.235s
Old times
MySQL has a long established rule of going from downloading to up and running in less than 15 minutes, as stated in various sources, like this interview …
[Read more]Local MySQL offices have hosted country-specific user or customer conferences in a number of countries this autumn:
Could Microsoft acquire an open source software vendor? Yes, is the answer, according to Steve Ballmer’s comments from the Web 2.0 Summit. However, I think there’s some reading between the lines to be done here. Microsoft could certainly buy an open source user, but at this stage an open source software vendor might be a step too far.
Here’s what Ballmer had to say, according to CNET:
“We will buy smaller companies. We will buy smaller companies that make some use of open source software,” he said. “We don’t want to discourage people who would talk with us just because they do some open source.”
It’s worth considering that Ballmer was speaking at a Web 2.0 event. As CRN points out, his comment is “a tacit acknowledgment of how thoroughly open-source …
[Read more]
This is quite a milestone for me! At last it possible to actually
do some practical work with the BLOB streaming engine
(MyBS)!
For this release I have completed changes to the MySQL
Connector/J 5.0.7, to allow BLOB data to be transparently stored
and retrieved from the MyBS BLOB repository. The new version of
the driver is called MySQL Connector/J SE (streaming
enabled).
Uploading a BLOB is as simple as using setBinaryStream() or
setBlob() on INSERT or UPDATE. By using getBinaryStream() or
getBlob() after a SELECT you get direct access to the data stream
coming from the repository. More information and some examples
are provided in the documentation at: http://www.blobstreaming.org/documentation.
To try this out you need to install the latest versions of PBXT
and MyBS. Both are available from: …
So, once again, I was listening to the Pro::PHP Podcast (or is it Newscast? guys?). They were talking about putting files in to a database table. Now, most people will say you should never do this. And lots of time they are right. And once upon a time I agreed with them without question. Then I started living in the real world where sometimes you have to do things you never thought you would. Here are the two places where I stores files in a database.
Phorum
Ever wrote software that has to be installed on n + infinity environments. It really sucks. Phorum version 3.3 or 3.4 was the first to allow attachments. We put them on disk. The instructions for setting up a spot on disk for attachments was longer than all the rest of the install document. The support …
[Read more]Continuing in the tradition, which I hope has been as helpful to you as it has been to me, I'm opening the floor for suggestions on chapter 9 of the upcoming High Performance MySQL, Second Edition. Unlike the other chapters for which I've listed outlines, this one isn't substantially written yet. It's in detailed outline form at this point (a tactic that has worked very well for us so far -- I'll write about that someday).
I'm trying to get feedback much earlier in this chapter's lifecycle, for several reasons. Two of the most important are that this is one of the first chapters I've had a chance to really take from scratch, and the chapters I haven't written from scratch have been harder to organize, as you've probably seen from the last few outlines I posted. There's a lot of value in working top-down on this deep encyclopedia-style material.
Read on for the outline and more thoughts I just can't keep to myself.
Note: This one comes in a bit late and it might not be as relevant as it could have been three weeks ago. But it also gives me the chance to take a more distanced look at the meeting. It might turn out that this post is more about working for MySQL than about the actual day.
It is about communication
I mentioned it a number of times, MySQL AB is a company with a very special structure. Its employees mostly work from home and home in this case is all over the world. By this time, most continents are covered as well as an impressive number of countries. It is obvious that solving communication issues is key to MySQL AB’s success. Different communication channels have all their merits and drawbacks and they are good at picking the right channel for the communication at hand.
MySQL is, of course, Open Source Software and MySQL AB has been an Open Company from the very beginning in terms of …
[Read more]I see we‘ve put up a QuickPoll where you can vote on what language you use when implementing applications that use MySQL. I know there are a lot of you out there using Java with MySQL, so go ahead and vote at http://dev.mysql.com/