Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Recently I had an interesting issue crop up. Due to an
unfortunate migration incident in which involved master/master
replication and not checking to see if replication was caught up,
we ended up with an infinite replication loop of a number of SQL
statements. awk helped immensely in the aftermath
cleanup.
The basics of the replication infinite loop were (more…)
Last month I went to the Sun Microsystems / MySQL Developer Conference in Riga Latvia. Along with about 250 other people. The majority were MySQL developers, but as usual we had several attendees from MySQL support and administration, and a few non-MySQL people came to talk about Google, Drizzle, and PBXT. This was one of our annual “internal” conferences, so lots of stuff that we talked about in Riga will only be publicly announced around, say, the time of the next MySQL User Conference . I’ll just talk about the stuff that’s already leaked, and about my own involvements.
First let me give my impression of ‘morale’. It’s up, way up, since two years ago. I attribute this to two causes: removal of a problem, and a better team.
Huh? Haven’t I read non-MySQLers’ blogs about people leaving the team? …
[Read more]I’m reading Intellectual Property and Open Source by Van Lindberg at the moment, and despite being about a relatively dry topic, I must admit that it’s a fascinating read.
Van Lindberg introduces the book by talking about the comments that end up on Slashdot.org, almost certainly prefixed by the expression IANAL (I Am Not A Lawyer) where people defend, discuss, and rip people up about the legalities of open source and the various licenses. Van Lindberg also talks about how he spends much of his time translating the contents of various legal documents into engineer speak and back again.
Despite being a proponent and long time user of free software and open source for the best part of my working life, I’ll admit to being completely ignorant of many of the issues. This isn’t through lack …
[Read more]A compilation of today's news of interest:
|
Marco had a small expedition tracking a bug in GlassFish v2 interacting with Syslogd. He found a solution and has Posted his Story and Patches. Still working on how the fix will migrate back to the main repository. OpenSSO now has a set of RESTful Web Services to access its functionality to do things like authenticate, authorize, validate, etc. And, on the same topic, the JCP just formally announced that JAX-RS … |
Dear Lazyweb, quick question: once I’ve USE-ed a database in MySQL, how can I un-USE it so I have no default database? Is it even possible?
It's no surprise that Oracle CEO Larry Ellison is on the prowl to acquire more companies, as reported by CNET, given that it gives him a chance to go shopping on the cheap.
.If times are tough, there are other opportunities...including making acquisitions that cost less... (A)cquisitions that we've been looking at for some time are less expensive for us.
I hope not, but there are plenty of good reasons for Oracle to be looking at acquiring an open-source company like Red Hat, or to be contributing significantly to various open-source projects. Open-source companies like Pentaho, Digium, and others should be attractive buys and open-source projects should be compelling strategies right now, for a few different reasons:
This is part knowledge share, part appeal: fellow bloggers, I’d comment a lot more on your blogs (and I want to!) if I could. Please, make it easy for me to comment — don’t make me log in (I won’t do it) or moderate me. I’ve found a solution that works really well [...]
In short, it really doesn’t matter. After watching a MySQL web conference by Jay Pipes, I was gutted when I found out that they are actually exactly the same. I know im not alone in thinking that it affected the size of the data field. An unsigned int has the max value of 4294967295 no matter if its INT(1) or int(10) and will use 4 bytes of data.
So, what does the number in the brackets mean? It pretty much comes down to display, its called the display-width. The display width is a number from 1 to 255. You can set the display width if you want all of your integer values to “appear”. If you enable zerofill on the row, the field will have a default value of 0 for int(1) and 0000000000 for int(10).
There are 5 main numeric data types, and you should …
[Read more]
Here are few tips if you are going to install the MySQL Coolstack
package on Sun Solaris.
First of all, let me say that, as usual, these tips are based on
my personal experience and they may not be applicable to your sw
version or environment. For this specific tip, I can't say if it
is applicable for all versions of Solaris - 9, 10, OpenSolaris,
X86, SPARC etc.
You can get the Coolstack from here - http://cooltools.sunsource.net/coolstack. Within
Coolstack you will find CSKmysql, a specific 64 bit package
prepared by Sun that provides some interesting performance
improvements. Coolstack has been built with Sun Studio from the
same source used to build the standard versions. Also, CSKmysql
provides Dtrace probes - I am sure some will find this feature a
great plus. The last available version, 1.3.1, is based on MySQL
5.1.25RC.
When …
Legacy of Blood is the fourth offering by Cinematic Titanic. For those not in the know, Cinematic Titanic is the new project by five cast members from Mystery Science 3000: Joel Hodgson, Trace Beaulieu, Frank Conniff, J. Elvis Weinstein and Mary Jo Pehl.
Cinematic Titanic follows the same concept as the original series, with the performers appearing in …
[Read more]