Databases Archive

Linux Labs Releases Clustered PostgreSQL

Linux Labs announced a key stepping stone towards large-scale deployment of the Linux Operating System. Called Clusgres, this product has the ability to make standalone applications run in parallel across a group of computers and act as one, including the Open Source database system PostgreSQL. To date there has been no capability to either increase speed of free database servers for Linux or to allow them to scale past the limitations of a single server. Despite advances in clustered supercomputing, there has been no capability for a server program running on a single machine, let alone the PostgreSQL database, to transparently operate across linked computers and to operate as if a single large program.

Firebird V1.5 RC-8; SAP/DB2 on Sun Cluster 3.X

Firebird 1.5 Linux CS RC8 released. This RC has many small enhancements in install procedure made by Mark O'Donohue and it should install more "smoothly". Additionally, this is the first RC built with external debug info which you can download separately.

Installing Apache, MySQL, and PHP on Linux

Apache, MySQL, and PHP have become one of the most utilized combinations for developing content driven websites. That being said, lets get to building a web server. This tutorial is designed to guide you through the initial steps of setting up Apache, MySQL, and PHP on Linux. The Linux distribution being utilized for this tutorial is Fedora Core 1, however the steps should be very similar across most distros.

Generating Database Server-Side Cross Tabulations

If you are a DBA or a database programmer, your manager may have asked you to prepare a breakdown of employees by location and department, or a breakdown of products by category and provider. If your boss is a techie, instead of a breakdown she might have mentioned a pivot table, or, if she likes to use "the right words," a cross-tabulation, Giuseppe Maxia writes. Elsewhere on another article advises on "Quick and Dirty RDBMS Tuning".

PostgreSQL 7.4 Released

The new PostgreSQL version, 7.4, includes a host of new features which make PostgreSQL a more powerful and scalable database for large enterprises. These include AMD Opteron optimization, improved index maintenance tools, and enhanced support of full text indexing which adds ranked result sets. Combined with the recent contribution of the eRServer replication solution, these advances fulfill PostgreSQL's potential to run high-availability, large-scale data centers. Press release here.

On Database News: Oracle, DB2, MySQL, FireBird, SAP

A new production version of the MySQL database, version 4.0.15, has been released. Additionally, MySQL Studio 4.2.5 is out: a set of MySQL GUI tools for database management, import/export, backup and monitoring tools for OSX and Windows. Firebird-SQL 1.5 RC-6 is out too, release notes. In the meantime, SAP unveils GUI Machine, a set of dev RAD tools, while an Oracle executive says the company is building a consortium of industry players to help create standards for commercial use of grid computing. Interesting results of the recent TPC-H benchmark performance testing on Clustered and non-Clustered 100GB and 300GB configurations.

Ellison on Grid Computing: It’s Invincible, It’s Inevitable

Speaking to thousands of attendees at Oracle's customer and partner conference, Chairman and CEO Larry Ellison launched Oracle's Grid Computing initiative, but to explain its significance, he dialed back the clock to 1964, to the advent of mainframe computing. Also, beta customers tap into Oracle Grid Computing while Red Hat Enterprise Linux 3 achieves record-breaking benchmark with Oracle and HP.

Oracle’s Infrastructure Now Fully Linux-ized

"Oracle is aggressively adopting Linux both internally and for its products, despite SCO Group's threats earlier this week that it may sue those who don't pay licensing fees to the company. Chuck Rozwat, an Oracle executive VP, says the company has moved its IT infrastructure to Linux, a year after CEO Larry Ellis issued the mandate." Read more at InfomationWeek.