-
Posted: December 20th, 2008, 12:41am CET
Phoebe (my 3 1/2 year old daughter) and I are travelling to Europe tomorrow, for three weeks - should be a grand adventure! (so now you know what Open Query profits get spent on ;-)br /a href=http://pics.livejournal.com/arjen_lentz/pic/0000aarf/img src=http://pics.livejournal.com/arjen_lentz/pic/0000aarf width=200 height=150 border=0 //abr /Of course were there to see my family, friends, and expose the Phoebster to a bit more Dutch lingo and culture; she understands it quite well but generally doesnt want to speak it (although she has done it ;-) so perhaps being surrounded by Dutchies em(whove received specific instructions to not flip to English - Dutchies are useless for people trying to practice Dutch, any hint of foreignness and they switch to English or another common language)/em will help. Language = culture = heritage. And knowing a 2nd language is important for development; it doesnt matter much which language but might as well do one that has a connection for us.br /br /While in NL, we might also visit my friend and former MySQL colleague Roland Bouwman; see if our respective kids can play together ;-)br /br /OQ operations will continue as normal while Im away, the systems are in place and others are round to handle client issues - although I probably wont be able to resist to occasionally check my email and such. Bad Arjen. Or perhaps just a sensible thing to do in a small growing company. Thats my current angle. Well see.br /Merry xmas happy new year to all!
-
Posted: December 19th, 2008, 2:28am CET
In the a href=http://www.joltawards.com/finalists.html19th Jolt Product Excellence Awards/a, our High Performance MySQL book is listed under the emTechnical Books/em category. That is so cool!br /br /How I found out: I dont think OReilly or any of the authors were notified of this, but I got a Google alert because someone else referred to it (interesting that the Jolt Awards site itself didnt trigger an alert).br /br /I have to admit that Im actually caffeine free at the moment, but I hope Jolt will forgive me for that ;-)br /br /Peter noted that MySQL itself is not one of the database category finalists. It doesnt have to be, but traditionally MySQL tends to always be a strong contender in these things. So I agree that its absence is somewhat noteworthy (in as far as the absence of something can be regarded as news).
-
Posted: December 19th, 2008, 12:13am CET
Just listened to the a href=http://twit.tv/natn79Net@Night #79/a netcast (during my morning walk); this episode has a emvery/em interesting interview with Don Tapscott who is the author of Grown up Digital (follow-up from Growing up Digital) and many other insightful books about the online world and its humans. I was going to list some keywords of particular interest, but theres just too much - the whole interview is excellent, go and listen to it already!br /br /My first exposure to Don Tapscott was years ago (mustve been around 2003), and quite accidental. I was teaching a MySQL training course at the University of Queensland, and walked past the uni bookstore which had a crate outside with old textbooks and other assorted stuff. I grabbed some useful resources on accounting and marketing, as well as one of Dons books (Digital Capital).br /br /Don has been writing about things since the late 70s. An early observation then was that executives didnt want to learn to type, that was beneath them (they had secretaries for that, right?) and how this would hinder the uptake of computer use beyond secretaries (word processing and the like) and programmers. Well, now we know eh, todays executives Blueberry has a keyboard, even ;-)
-
Posted: December 17th, 2008, 8:38am CET
a href=http://www.news.com.au/technology/story/0,28348,24801456-5014239,00.htmlMessy gift-wrapping service Crapwrap launched by gadget retailer Firebox/abr /br /I reckon this is quite brilliant, and I think a nice example of a disruptive offering whereby the existing market is actually overservering the needs of a group of clients. So these guys take good enough to a whole other level, and it doesnt even have to be cheaper. Very cool.br /br /And on that note...blockquoteDear Santa,br /Can I please please have USB pencil sharpener for xmas?br /Many of my training students and conference attendees have one of the illustrious Open Query emtransactional writing implements (with rollback)/em, made from recycled newspaper (tightly rolled up, you can read it while sharpening!) but I actually havent got a proper USB sharpener for it yet. I would take it with me while travelling, but the main problem has been availability - apparently theyre really popular. Perhaps some Santa magic will help?br /Thanks!br /br /P.S. Ive been really good this year, Ive only made fun of MySQL Enterprise a few times./blockquote
-
Posted: December 17th, 2008, 2:48am CET
Apart from lots of interactivity, I tend to use anecdotes and humour when teaching a a href=http://openquery.com.au/trainingMySQL training course/a, as it really helps people to remember.br /br /a href=http://openquery.com.au/trainingimg src=http://openquery.com.au/files/oq-training-arjen.jpg border=0 //abr /br /Sometimes I call something evil (no Im not religious), and attach a little story to it. One example the NATURAL join. Its not a join type (like inner, left outer, right outer), its a modifier keyword that can be used with any join type, and it directs the way the join is resolved.br /br /Instead of specifying a join condition through ON, USING or a WHERE clause, the NATURAL keyword tells the server to match up any column names between the two tables, and automatically use those columns to resolve the join. For example, if two tables that youre doing a natural join on have a column foo_id, the server would automatically use that column. But of course a server has no idea about context, so its indiscriminate. There can be multiple columns that have a name which is also used in the other table, they will ALL be used for the join (like codea.id=b.id AND a.name=b.name/code)br /br /I like explicit join syntax, I try to steer people away from comma/WHERE constructs. But NATURAL is a whole other level of evil, because its dangerously implicit: you cant tell by looking at the query what columns are going to be used! If, at any point, a column name is changed, or a column added in one table, or a column is removed (or normalised away to another table again), the join can (equally magical) break by either including fewer, or more, columns.br /br /Thus I reckon that NATURAL joins are just nasty beyond belief, and Ive been putting this to my students: if you ever find a dev using this, a) fire them on the spot and b) tell me about it! Of course theres an aspect of humour in there, but it gets the point across. bHave emyou/em ever seen NATURAL join used anywhere? Please do tell in a comment!/b
-
Posted: December 15th, 2008, 6:20am CET
Late last week Open Query quietly launched its new a href=http://openquery.com.au/services/mysql target=_blanksubscription offering/a for MySQL support. Essentially, you commit to a number of hours per month for a number of months, and Open Query delivers appropriate resourcing. You can sign up for a minimum of 2 hours per month, and the cost per hour is quite low because a) we prefer to build a long-term relationship with our clients and b) the cost structure of Open Query enables this and were proud of it!br /br /Weve designed this offering to provide an equal arrangement between Open Query and its clients, and to be in line with our vision of education and optimisation by design rather than simply trouble-shooting. Years ago, Monty used to describe MySQL Support in terms of insurance, and that seemed reasonable at the time. Its useful to have insurance, but when building a new house or renovating an existing one youd be mindful of designing things well.br /br /So for MySQL, you can get appropriate a href=http://openquery.com.au/trainingtraining/a, and engage an external expert to assist with this ongoing process, both through Open Query. Of course we can still help in case of trouble, but I think we can all agree that prevention is best (and cheaper!); another positive aspect of the subscription arrangement is that Open Query engineers will already be more familiar with your application and systems as they regularly look at them anyway - so if there are problems, the resolution process can become much simpler and quicker!br /br /What do you do with your monthly hours, as obviously your needs will vary? Well, youre allowed some shuffling of hours between months, and hours can also be used to sign up for Open Query training days and even on-site consulting. We encourage clients to make optimal use of their hours either with these extra options, or simply by utilising the available expertise. For instance, there is no hindrance for a developer or DBA to shoot us a question while theyre working on something, as it wont cost you anything extra! You can also have us do a periodic health-check and tune-up, as well as slow query analysis with recommendations, or more serious DBA-type tasks like setting up or extending replication, backup arrangements, upgrades, and server monitoring. Theres a myriad of possibilities, so the hours tend to not go to waste but rather improve your overall business process!br /br /In a nutshell, the whole arrangement is geared to give you proactive assistance. In terms of scope, anything related to MySQL is fine and we frequently deal with most of the LAMP stack anyway. We dont mind if you have lots more servers, use replication, or need advice with queries or schema design for performance purposes. We even have expertise on MySQL 3.23 or 4.0 if you happen to still have those deployed; we know about the old optimiser quirks!br /br /Open Query is self funding, debt-free, organically growing, and profitable since its inception. The business and services are designed to scale out in a fairly linear fashion.
-
Posted: December 14th, 2008, 2:31pm CET
It started with Arjen doing the last lightning talk at OSDC 2008… a quick show of hands on who else had dealt with (or was dealing with) depression. Everybody had a look around, and thus knew that they weren’t alone. Afterwards, there was more positive feedback which continued over email in the days that followed. Someone suggested starting a group, and the same day a href=http://bluehackers.orgbluehackers.org/a was born.br /br /The objective of this initiative is to make visible that there are many fellow geeks among us who are intimately familiar with depression, anxiety, or bipolar disorder. It helps to know you’re not alone. And it’s not because we’re geeks, but because we’re human. The Australian a href=http://www.beyondblue.org.auBeyondblue/a site is of course an excellent resource, but, because geeks have a specific work environment, there are also particular challenges in dealing with these issues, and that’s where we feel our group can help with additional insights, tips, and posts from others with experience.br /br /Using the logo, we can also make the topic visible at meetings and conferences around the world, ensuring that indeed no geek need feel alone in this, or feel unsupported. They can simply look around and see. Anybody will be able to show their support and understanding, in a kind and non-intrusive manner.
-
Posted: December 8th, 2008, 12:09am CET
At the recent Barcamp Gold Coast 2, my friend a href=http://refactor.com.au/Steve Dalton/a showed off a href=http://www.balsamiq.com/products/mockupsBalsamiq Mockups/a. Cool and useful. The a href=http://twit.tv/natn75Net@Night #75/a netcast (with Amber MacArthur) has an interview with the author, Giacomo Peldi Guilizzoni.
-
Posted: December 7th, 2008, 2:35am CET
See a href=http://www.telegraph.co.uk/news/newstopics/debates/3394545/Oxford-compiles-list-of-top-ten-irritating-phrases.htmlhttp://www.telegraph.co.uk/news/newstopics/debates/3394545/Oxford-compiles-list-of-top-ten-irritating-phrases.html/aolliAt the end of the day em(its a great song though, from Les Miserables)/emliFairly uniqueliI personallyliAt this moment in timeliWith all due respect em(usually insults follow)/emliAbsolutelyliIts a nightmareliShouldnt ofli24/7 em(not uncommon in database-speak either ;-)/emliIts not rocket science/olWe all use some of those phrases... go on, admit it already! And because we need to get it out of our system, your challenge for today is: use them all in a single grammatically correct sentence...
-
Posted: December 6th, 2008, 11:20pm CET
What I forgot to mention in my lightning talk about depression, theres an excellent Australian website a href=http://www.beyondblue.org.aubeyondblue/a which has a wealth of information and resources.br /br /And for all of you who stuck their hand(s) up, well done and thanks again! One never knows what the response will be with experiments like this, but you did good! Chances are that with that simple act, you helped at least one other person in the room, if not more. Going by the responses I received afterwards, it was a worthwhile exercise.br /br /As I mentioned (and really it was a spontaneous unprepared gem ;-) its not about being geeks, but about being human.
-
Posted: November 27th, 2008, 10:32pm CET
So, MySQL 5.1.30 (no longer RC) is here. Very good.br /br /Question, Sun/MySQL, since this is 5.1.30 (an even number, traditionally reserved for enterprise builds)... are there still going to be separate enterprise builds for 5.1 ? I think it would be emreally great/em if you were to trust your subscription offering with query analyser and the trusted support gang, and so on...br /br /Go on, make us proud!
-
Posted: November 27th, 2008, 2:15pm CET
I like to say it that way ;-) but to clarify Im doing in-house training days in MySQL related topics for staff members of various UQ departments. Nice people, interesting backgrounds and ongoing projects, and it is of course in my home town Brisbane so nice and easy after all the recent travels far wide.br /br /Were covering everything from SQL Fundamentals to DBA and performance tuning foo, spread out over many days in the coming months. Some of the days are newly developed, such as the SQL Fundamentals module. So now it can be added to OQs range of available course topics!br /br /People have asked me why I started out with intermediate and somewhat advanced course days, and then extended that mainly sideways and backwards (down to beginner level), and only a little bit upward.br /Theres some very practical reasons for this. A beginner obviously wont have been involved with MySQL before, and that means they havent been around in the MySQL (or even OSS) ecosystem. How would they find Open Query, or how would I find them? Of course it happens, and Google is great too, but relying on this is possibly not the best way for a startup.br /br /MySQL users with at least some experience are much easier to catch, and thus are a better place to start; at least, thats what I figured, and its proven effective. Then, the rest is expansion from there. And as it turned out, I now get lots of beginner-level requests also, and SQL Fundamental is the absolute genesis.br /br /Then the advanced foo... of course we need to deal with topics like nifty replication and failover techniques, and server performance analysis and tuning. So OQ has course days for those topics, and offers remote and on-site consulting services as well. But when it comes to scaling, we know that getting the schema and queries right is much more effective than fancy hardware. Even experienced MySQL developers and DBAs tend to have plenty of gaps in their knowledge, and its exactly those gaps (well, the filler ;-) that can make the biggest difference. We really do need to deal with all that before indulging in for instance sharding techniques.br /br /The tricky bit is to convince someone that they dont actually know as much as they need on the level they reckon they are - but its not a battle, or about putting people down, the purpose is to help them find those little bits that theyve been missing, so that they can truly do magic in their realm. Heck, I dont know everything either, and I learn more new things all the time!br /br /So how emdo/em we sell the youre advanced but you still need to learn some more more stuff also story? Look, let that be my little marketing secret... and there too theres plenty more to figure out along the way. A key advantage for OQ is that we have a low overhead infrastructure, we can explore something and not end up in deep trouble if it doesnt work out, and we never spend money we dont have. All those handy things are not something I invented, its basic Bootstrapping stuff (see the book by the same title by Greg Gianforte of RightNow Technologies, another very successful MySQL user), aka starting a business with almost no money.br /It works, its exciting and IMHO a more enjoyable way for building a business, and it also makes for great conference talk topics!br /br /The bank still reckons Open Query and its founder are a bit weird just bringing them money (in general terms) and in any case not wanting or needing to borrow anything, but by now theyve noticed that its going alright with the incomings and outgoings. That gives me a lot of good karma with the bank, and thats just a nice feeling to have. Try it! And when I want to buy a house again some time, having that good history will come in handy, although fundamentally I just dislike borrowing and would love to just be able to buy a place outright; might not quite happen that way though ;-)br /I am with a fairly big bank, but one where you can actually know the bank manager and even have their mobile number. When I walk in to the branch I can just walk up to his office and then its hi Arjen, do come in. He does that with heaps of people so thats not just me and not really about the way Ive set up my business - but its great anyway, and sometimes extremely useful.
-
Posted: November 27th, 2008, 6:22am CET
Preparing for the a href=http://osdc.com.au/Open Source Developers Conference/a in Sydney next week. Of course Im curious how itll develop further this year, since I was the lead organiser last year... in any case it should be a great event, with an interesting bunch of people gathering, and a good a href=http://osdc.com.au/2008/papers/index.htmlprogram/a.br /br /Somehow I got cajoled into doing three talks:br / - Architecting for Success - Just in Case (30m)br / - Optimisation by Design (30m)br / - Scaling your Business: Approach Defines Outcome (2h)br /The first one is not MySQL specific, and the last one is about business and development strategy.br /br /Open Querys PHP expert trainer a href=http://sebastian-bergmann.de/Sebastian Bergmann/a has been scheduled in parallel with my last session - pity, I wouldve liked to listen to that one.br /br /a href=http://openquery.com.au/Open Query/a is also sponsoring the OSDC event together with our partner a href=http://www.pythian.com/The Pythian Group/a. Why do we bother, since most companies dont sponsor anything? Sponsorship tends to not provide direct benefits; speaking at a conf provides the best exposure, and opportunity to meet with people. So...br /br /Well, first of all OSDC is affordable. And its important to support good conferences, to prevent them from either going too expensive for attendees, or just stop happening. I think its essential to participate fully in the community that we operate in on a daily basis, and since were a functional business, sometimes a financial contribution is the most suitable and appropriate way to help - at least for a conference, it tends to be. Im not just going on about money blah to impress, who cares. Its a nudge to other companies to consider doing the same, surely they have a little spare in their budget for valuable events?br /br /Somewhat related, people have been asking concerned questions about how business is going. And actually, its going well, youve seen the a href=http://openquery.com.au/company/jobsjob ad/a. Our friends at Pythian are also looking for more people in this region; if youre interested Id be happy to introduce you. Or just catch us in Sydney during the OSDC conference!br /br /Jonathan Schwartz recently wrote in a blog entry that he expects the OSS-related marketplace to actually do well in tougher economic times, since obviously people are looking to saving on their budget - and I think hes quite right. Some OSS-using companies will have a tough time, but thats an entirely separate issue often related to their business/revenue model (such as advetising). The old ways tend to dont apply now, and that is true for database and application architecture, but I reckon just as much for the design of a business.
-
Posted: November 26th, 2008, 4:14pm CET
In a nutshell, there is some code for doing delayed replication from inside the server, as an optional parameter to the CHANGE MASTER TO syntax. Maatkit has a script for doing this functionally externally, but an internal solution might be preferred.br /br /If you have an urgent interest in this feature, in either MySQL 5.0 or MySQL 5.1, please a href=http://openquery.com.au/contactcontact me/a to discuss.br /br /See a href=https://bugs.launchpad.net/ourdelta/+bug/288898https://bugs.launchpad.net/ourdelta/+bug/288898/a for more details and current code status (link to relevant a href=http://ourdelta.org/OurDelta/a branch that has the work-in-progress patches).
-
Posted: November 25th, 2008, 11:30am CET
If youre in Australia, at least... see a href=http://www.petrolmonkey.com/PetrolMonkey/a.br /Very cool. Simple yet functional and useful.br /br /You can register your car there, and by entering how much you filled up with at each petrol station visit, and your odometer reading, the system works out how what your petrol consumption is like. Not rocket science, but handy nevertheless - Ive been tracking my fuel purchases for a while but hadnt yet got round to setting up a spreadsheet to do the math - so now I dont have to! If I had though, the site would have also catered for that as it allows importing of some historical data. Handy.br /br /Now for the extra... since its online, it also allows you to compare with other cars of the same year/make. Again, not perfect as theres many variables, but still... once you track this stuff, you probably become more fuel-use aware also, which is good as well. Plus there may be some peer-pressure effects. Who knows how these things develop, usually in directions that noone envisaged.br /br /Anyway, I think the site shows what can be done these days with Agile development and appropriate web technologies. Something very functional in a short time, simply fit for its intended purpose. The PetrolMonkey site was built by a href=http://refactor.com.au/Refactor/a which is based on the Queensland Gold Coast.
-
Posted: November 23rd, 2008, 3:00pm CET
Augmenting a href=http://www.xaprb.com/blog/2008/11/20/an-alternative-to-the-mysql-query-analyzer/Baron/as excellent post about existing monitoring/analysis info available through the enhanced builds by Percona and OurDelta... developing these capabilities further is a matter of strongwhat/strong as well as stronghow/strong.br /br /So lets discuss the emwhat/em: let us know what kind of information you would like to get out of the server, and why. Please be as specific, detailed and descriptive as possible, so we get the best possible overview of your needs. To discuss publicly, simple comment on this post - but you may also a href=http://openquery.com.au/contactcontact me/a directly to discuss if you wish. Thanks for your input!
-
Posted: November 21st, 2008, 5:48am CET
I know the architect of the new Sun/MySQL query analyser, Mark Matthews, very well. Even though the tool is not OSS (and thus does not benefit from an OSS development model with early feedback in the design/development cycle, from many eyes) I know that Mark organises his designs and team in such a way that the resulting quality (barring interference) will always be very good. Anyone who uses Connector/J will surely attest to that. So Id personally trust the result, based on my knowledge of the person who led the team. Thats still a form of semi-blind trust though, OSS development makes that unnecessary which is why Id say an OSS dev model is preferred for most things. And the new tool is, of course, bundled with the MySQL Enterprise subscription model. You have to subscribe to that service to have access to the tool. br /br /But back to the query analyser itself. Im really fairly pleased with Sun/MySQL launching this, because it does appear to provide actual value for clients, without weird arrangements that make people cringe. Well done, Mark MySQL!br /br /br /Now we can make an interesting observation... as Baron already noted, there are some things that only the server knows. No proxy, packet sniffing, processlist or even show status can reveal all details in the required context. And running things like SHOW SESSION STATUS just adds extra overhead (an extra round trip to the server) after each query, so while that would provide many of the otherwise missing insights, its not really a desirable approach.br /This is why I too regard extra instrumentation inside the server as vital. Yet:br /br / - Sun/MySQL, owner of the MySQL codebase (which is GPL), makes tools that are independent from the server.br / - Others (Percona, OurDelta) add extra instrumentation into the server, to enable better monitoring and tuning.br /br /Most intriguing!
-
Posted: November 16th, 2008, 2:11pm CET
Yes, I too am at OpenSQLCamp... others are great at the live blog-reporting and instantly putting photos online.br /I am taking some photos, but Ive kept my laptop in the bag for much of the day as really emails, IRC and IM can wait and its just great to actually have full focus on the talks that are going on and walk around and chat with people.br /br /Today is hackathon day so the laptop will definitely be out for coding.br /br /Also looking at a href=http://tokutek.com/contest.phpTokutek/as challenge for inserting 1 billion rows. Chatted with someone from the company at the camp about that. Ive got some code lying around that can serve as a good base for tackling this. Well see.
-
Posted: November 14th, 2008, 7:27pm CET
Sitting at LAX waiting for my onward flight. Breaking with LAX tradition, there werent huge long waits at the passport or customs checks, I was not harassed, abused, or barked at. Impressive change!br /br /Walking through a corridor, theres a welcome to USA above, with photos of the US president and vice president (currently the talking gloating bush and his evil brains Cheney), but thinking about the fact that soon someone will get a stepladder and put Baracks picture up there just made me smile ;-)
-
Posted: November 13th, 2008, 4:56pm CET
Packing for a href=http://www.opensqlcamp.org/index.php?title=Events/2008/OpenSQL Camp 2008/a... dropping Phoebe off at daycare in the morning, and straight on to the airport. No worries, her mum emwill/em pick her up in the afternoon ;-)br /br /Decided on a lightweight approach, handluggage only. Got a little suitcase that satisfies the requirements and actually used it earlier this week for a Melbourne trip.... then realised that I actually have a a href=http://www.tombihn.com/Tom Bihn/a professional laptop backpack from about a decade ago, and its actually also within the size specifications. Just need to make sure it stays light enough, but the backpack should be lighter than the suitcase.br /br /If youre coming to OpenSQL Camp too, see you there!br /br /Brisbane Australia - LAX - Washington DC - Charlottesville VA. The flights will be a joy and a pleasure, Im sure. 26 hours travel time in total (with airport waits included). If I appear incoherent on arrival, please add chocolate + water and I should be ok ;-)