Showing entries 36371 to 36380 of 44869
« 10 Newer Entries | 10 Older Entries »
Multi-dimensional vs. aggregate awareness

Ambition is the last refuge of failure --Oscar Wilde

The star schemas along with aggregates support the full scope of the data warehouse, the multi-dimensional database (MDB) can be used to support a limited scope where query performance is paramount:



Star schema aggregate awareness
MDB

Database
Oracle Materialized Views,
[Read more]
MySQL Toolkit version 1254 released

This release fixes several bugs introduced in the last release as I replaced untested code with tested code – how ironic! Actually, I knew that was virtually guaranteed to happen. Anyway, all the bugs you’ve helped me find are now fixed. I also fixed a long-standing bug in MySQL Table Sync, which I am otherwise trying to touch as little as possible for the time being. (Remember to contribute to the bounty, and get your employer to contribute as well, so I can do some real work on it in the next month or so!

Open-source Sunday School: Milk before meat

Greta and Lily Asay

Whom shall he teach knowledge? and whom shall he make to understand doctrine? them that are weaned from the milk, and drawn from the breasts.

For precept must be upon precept, precept upon precept; line upon line, line upon line; here a little, and there a little:

For with stammering lips and another tongue will he speak to this people. (Isaiah 28:9-11)

Anyone that has tried to ramrod open source into an organization will appreciate this counsel from Isaiah. As a market phenomenon, open source - be it Linux, Apache, MySQL, SugarCRM, MuleSource, or another project - almost always has begun on the fringes of IT. With Linux it was the edge-of-the-network server at first, until it eventually claimed the data center. With many commercial open-source projects, the first entree into an enterprise is at the departmental level …

[Read more]
Progress report on High Performance MySQL, Second Edition

It's been a while since I've written about progress on the book. I actually stopped working on it as much at the beginning of the month, because on October 31(st) I managed to finish a first draft of the last big chapter! Now I'm back to full-time work at my employer, and I'm working on the book in the evenings and weekends only. Read on for details of what I've been working on and what's next in the pipeline.

Thought... (at Saturday Day house)

"Projectors are the essence of Communication"

Sums up how to communication between tech types.

Spending my Saturday at "Saturday House" (http://www.saturdayhouse.org/). So far I have explained how the new "skeleton-library" framework I put together works.

(obligatory link: http://hg.tangent.org/skeleton_library/)

Next is teaching people how to write storage engines (and talking about the memcached engine for MySQL).

10 Minute HOW-TO

This question seems to crop up again and again... In the words of one comment to my blog: "I've downloaded your External Language Stored Procedures package and am interested in trying out the JAVA part. Would appreciate if you could explain how use the downloaded stuff."Ok, on my download page, I have provided 2 different downloads which are automatically created from our source repository. A

MySQL in Debian and Binary Logging

The next upload of the MySQL packages to Debian (both branches, 5.0 in unstable and 5.1 in experimental) will disable binary logging in the default configuration file. I think most users of the MySQL packages in Debian don't really need it, and otherwise (e.g. on a replication master, or for point-in-time recovery) they know how to enable it.

This change only affects you when you're doing a fresh installation of the mysql-server package, or if you're still running the default configuration file shipped with the package. If you modified the configuration file in the past already (which should be the case when using replication, because the server_id line is disabled by default), the change will not be applied during an upgrade without explicit confirmation.

Scaling Drupal

John Quinn writes about Scaling Drupal he is taking a one step at a time approach and is still writing his 4th and 5 stages.

His first step obviously is separating the drupal from a separate database server, and he chooses mysql for this purpose, moving your DB to a different machine is a good thing to do.

However then he gets this crazy idea of using NFS to share his his drupal shared files :(
(he even dares to mention that the setup ease is good) Folks, we abandonned NFS in the late nineties. NFS is still a recipe for disaster, it has performance issues , it as stability issues (stale locks), and no security admin in his right mind will tolerate portmap to be running in his DMZ.
(Also think about the IO path that …

[Read more]
Release Criteria: Aligning official documentation with reality

First of all: Thank you for your positive feedback on the MySQL 5.1 Errata Sheet!

While I never doubted that publishing the 5.1 Errata Sheet was the right thing to do, I had expected a more mixed feedback. It turned out the feedback was very grateful. So thank you for your encouragement

  • Kevin Burton for commenting in Jay’s blog

    “This was a big win guys. Good work.We were going to deploy 5.1.x in out or production slave configurations just to test the reliability but this give us a lot more confidence in this release.”

  • Baron Schwartz for commenting in …
[Read more]
DPM Release-4

DPM homepage

http://consoleninja.net/code/dpm/rel/dpm-r4.tar.gz - tarball of r4
git clone http://consoleninja.net/code/dpm/dpm.git - to get the latest code, always
http://consoleninja.net/code/dpm/dpm-export.tar.gz - a tarball of the latest code, for those unwilling to git it.

It's been a long time. I suck. One of these days I'll be productive enough to pop out releases.

Unfortunately I've been sitting on this one for a long time. There are significant API updates in this one, but I've cut it just short of being really good. Impatient :)

Notable API changes:

- All …

[Read more]
Showing entries 36371 to 36380 of 44869
« 10 Newer Entries | 10 Older Entries »