Ideas, releases, practical guides, and perspectives from the people building with MySQL.
I’ve been working with a client recently who has SELinux on his servers. It has been quite a struggle sometimes.
My colleages tell me that SELinux has a pretty noticeable performance impact. I am not sure if we have benchmarks to support this; at any rate, the client said it’s OK, we’ll take the performance hit.
There [...]
I thought it might be interesting to list the books I use as
reference while programming for this project. In no particular
order:
SQL in a Nutshell - Kevin E. Kline - This book was not what I
thought it was, but it is a good reference for SQL and
distinguishes between various flavors: DB2, MySQL, Oracle, and
SQL Server mostly.
High Performance MySQL - Jeremy D. Zawodny & Derek J. Balling -
Good book on getting performance out of MySQL
Advanced Programming in the Unix Environment - W. Richard
Stevens
Unix Network Programming - W. Richard Stevens
The C Programming Language - Kernighan and Richie
Programming with Posix Threads - David R. Butenhof
I'm sure there's more, but that's all I can think of right
now.
Brian Aker delivers the keynote speech at OpenSQL Camp: State of the Open Source Databases.
The presentation begins with:
"There is no way I'm going to tell you exactly where the future
of databases go. We have way too many egos in the room to ever
even begin a discussion..."
and ends with Aker saying,
"What the hell does that mean?"
My summary: open source databases are already ubiquitous, we need to make them better/faster/consume fewer resources.
Brian's summary: What part of my keynote surprised people? How ubiquitous bot nets are, and how they act as a big decentralized data store.
I'm just done listening to a presentation on MySQL from my esteemed MySQL colleague Robin Schumacher. Robin is director of product management at Sun/MySQL. Not being a database expert, I thoroughly enjoyed Robin's whirlwind tour of MySQL. I want to note of a couple of highlights that caught my attention :
I'm just done listening to a presentation on MySQL from my esteemed MySQL colleague Robin Schumacher. Robin is director of product management at Sun/MySQL. Not being a database expert, I thoroughly enjoyed Robin's whirlwind tour of MySQL. I want to note of a couple of highlights that caught my attention :
so far little is happening in this area with MySQL Cluster.
would be interesting to get patches to cluster from a(ny)
(huge-web) company...
wonder if that will ever happen...
maybe we don't use enough buzz-words
---
it could also be that we add features in a high enough pace
ourselves,
preliminary benchmarks of our multi-threaded ndbmtd(4
threads)
shows up to 3.7 times better throughput than singled threaded
ndbd.
Going to LCA? We have two days of glory for what is known as The Open Source Databases MiniConf. We have a webpage on the wiki, the announcement went out a few days ago, and the call for participation is open!
Tasmania is a fabulous place to be in January. 19-20 January 2009 is when the OSDB-MiniConf happens… topics on MySQL, PostgreSQL, Derby/JavaDB, Drizzle, CouchDB and many more are to be accepted.
What are you waiting for, submit a talk already!
I’ve released version 1.1.1 of the MySQL Cacti templates I develop. The new templates work around more Cacti limitations, including the limitation on the length of the data returned from the poller script. There’s also a new graph and many other niceties since the last release.
Note that there are TWO incompatible changes with [...]
Build of MySQL 5.0.67.d6 for Debian Etch done and available,
simply click to the new Debian page for the info to set up your repo.
Thanks to Peter Lieverdink (cafuego on the #ourdelta IRC channel)
for the fast work!
Also, because sometimes instant banter is useful, there's now a
#ourdelta channel on Freenode. Naturally,
real discussion should just happen on the ourdelta-developers team and list. It's really
easy to join.
Your interest (from 53 different countries according to Google
Analytics!) and response has been great! Among the feedback, saw
a few bug reports on minor issues in the packaging, most of which
have already been addressed for the next build (bug handling
progress is all visible on Launchpad). And discussion about
various patches that are "around"; …
Build for Debian Etch done and available, simply click to the new Debian page for the info to set up your repo. Thanks to Peter Lieverdink (cafuego on the #ourdelta IRC channel) for the fast work!
Your interest (from 53 different countries according to Google Analytics!) and response has been great! Among the feedback, saw a few bug reports on minor issues in the packaging, most of which have already been addressed for the next build (bug handling progress is all visible on Launchpad). And discussion about various patches that are “around”; some mails came to people directly but we try to encourage using the oursql-developers team mailing list.