While it took some time to get things sorta out with building
MySQL 5.1 with the right
parameters to get partitioning support working, I finally was
able to get a working install and had some time to play around
with this new intriguing MySQL 5.1 feature hands on. The results
were mixed I think. For an initial release, things are pretty
solid, save for a few non-trivial oddities.
One of the problems I was trying to tackle was splitting up a
logs table up by a date range. It seems like this would be a
popular use for partitions since it replicates some of the
functionality of the MERGE storage engine, only in most cases,
does so better. The problem, however, I ran into was that it did
not seem quite as trivial as I thought to partition by year and
month. Partitioning by year seems easy - just use the year()
function, but partitioning by year and month is far less …
Setting Up Master-Master Replication On Four Nodes With MySQL 5 On Debian Etch
This tutorial explains how you can set up MySQL master-master replication on four MySQL nodes (running on Debian Etch). The difference to a two node master-master replication is that if you have more than two nodes, the replication goes in a circle, i.e., with four nodes, the replication goes from node1 to node2, from node2 to node3, from node3 to node4, and from node4 to node1.
NetBeans 6.5
is soon to be released. After 10 years of
NetBeans that's the first version of Sun's OpenSource IDE
featuring PHP
support. While 6.5 is waiting to be packaged the development
didn't stop and the first features for the successor,
NetBeans.next, are already being developed. David Van Couvering just showed a preview of a
cool new feature: SQL completion in PHP strings, if it does what
the screenshot promises that's a damn great addition in my
opinion....
Hello, there! With another Ubuntu release, it has come the time to update our series of posts on how to install Oracle 11g on Ubuntu. If you’ve been following, we’ve been publishing updated howtos since Ubuntu 7.04:
- Installing Oracle 11g on Ubuntu 8.04 Hardy Heron LTS
- Installing Oracle 11g on Ubuntu 7.10 Gutsy Gibbon
- Installing Oracle 11g on Ubuntu 7.04 Feisty Fawn
In fact, in this article I refer several times to previous posts regarding some configuration aspects and why I chose particular values. Also, note that this series of posts is a work in progress and we were able to improve this series with your help. So please do post comment below as …
[Read more]Red Hat’s chairman wins enterprising award. Sun updates StarOffice. Barracuda Networks acquires 3SP. Reaction to Sun’s reorganization. Barack Obama’s laptop. And more.
Press releases
Red Hat, Inc.’s Matthew Szulik Named Ernst & Young
Entrepreneur Of The Year 2008 Overall National Winner Ernst &
Young
Ingres Launches Ingres Database 9.2 Ingres
Sun Microsystems Unveils StarOffice 9 Software Sun Microsystems
Red Hat Increases Authorization to Repurchase Common Stock Red Hat
…[Read more]
Open SQL Camp was a success.
It was hosted by Baron "Xaprb" Schwartz, who I learned is one of
the few people I don't have to look down to look in the
eye.
There were maybe 100 people over the whole the weekend, including
the upper echalon of MySQL and other open source database
hackers, as well as technical people from Infobright and Tokutek
and PBXT.
There were people who quite literally flew in from the other side
of the planet and from Europe.
It was good to see Monty Widenius, and to introduce him to the
pleasure that is well made matcha.
Vadim Tkachenko's and Peter Zaitsev's presentation on the Percona
patches was interesting and eye opening. The following random
roundtable discussion between them, Brian Aker of Drizzle, and
Arjen Lentz about the open source future of InnoDB was
productive, in that it let to Percona moving their patch set
development to Launchpad …
Thanks to Andrei (before he moved on to bigger and better
things), we now have this in the nightly builds.
Take a look - yes, you're getting column names in the completion
list when working with a string literal in PHP. And notice how it
works with aliases...
It's a prototype, but it's a good start, and we expect to have
something like this working for you in NetBeans.next
Great news! NetBeans PHP team just added SFTP support. Note this is in the development build, which you can get here
Sheeri has already commented on this, but I want to stress that MySQL 5.1.30 will be GA by December 6th, 2008.
Submit a session, panel topic, or lightning talk for CommunityOne
2009. READ MORE