Databases Archive

‘MySQL Runs Faster on Solaris 10 Than on Red Hat Linux’

"Sun today announced new benchmark results involving the performance of the open source MySQL database running online transaction processing workload on 8-way Sun Fire V40z servers. The testing, which measured the performance of both read/write and read-only operations, showed that MySQL 5.0.18 running on Solaris 10 executed the same functions up to 64 percent faster in read/write mode and up to 91 percent faster in read-only mode than when it ran on the Red Hat Enterprise Linux 4 Advanced Server Edition OS." Take a look at the item below, though.

Larry a Big Linux Fan, Says Oracle Exec

A senior Oracle executive has backed the reasoning behind the software vendor's mooted move into the operating system sphere and illustrated the depth of chief executive Larry Ellison's allegiance to Linux. Ellison recently told the Financial Times the company was "missing an operating system" and it would make sense to "look at distributing and supporting Linux" since ongoing maintenance and services fees were becoming an increasingly important part of Oracle's revenue stream.

How to Set up a Load-Balanced MySQL Cluster

"This tutorial shows how to configure a MySQL 5 cluster with three nodes: two storage nodes and one management node. This cluster is load-balanced by a high-availability load balancer that in fact has two nodes that use the Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster)."

SQL Server 2005 SP1 Released

"Microsoft announces the availability of SQL Server 2005 Service Pack 1 with Database Mirroring, SQL Server Management Studio Express, additional options for ISVs and normal feature fixes. The release of SQL Server 2005 SP1 follows the March 2006 Community Technology Preview and the initiation of a new customer collaboration model, which allowed active customer feedback to drive final updates and routine fixes delivered in this service pack."

Oracle Sews up Multiple Security Holes

As part of its quarterly patch cycle, Oracle on Tuesday released fixes for a long list of security vulnerabilities in many of its products. The Critical Patch Update delivers remedies for 14 flaws related to Oracle's Database products, five related to the Collaboration Suite, one in Application Server, 15 related to E-Business Suite and Applications, two in the Enterprise Manager, one in PeopleSoft's Enterprise portal and one in JD Edwards software.

Interview with Josh Berkus of PostgreSQL

The BSD family of operating systems isn't the only BSD licensed software whose roots originate from the University of California at Berkeley. While many are familiar with Berkeley's contributions to Unix, fewer are aware of the role it played in the formation of modern database systems. The PostgreSQL project has transformed that codebase into a database that is known for its rock-solid stabiity and advanced features. In this interview, Josh Berkus provides some insights into PostgreSQL from his perspective as a core developer.

Oracle Releases 10g for Solaris x86

Oracle has finally, after much delay, released 10g for the Solaris x86 platform. This should be a big boost for Sun's Galaxy class servers as well as other Solaris x86 users everywhere. You can get your copy at Oracle's download page. On a related note, "this article is a step by step guide for tuning and optimizing Red Hat Enterprise Linux on x86 and x86-64 platforms running Oracle 9i (32bit/64bit) and Oracle 10g (32bit/64bit) databases."

Five Reasons Why you Should Never Use PostgreSQL — Ever

"Within the past two years, Oracle, IBM and Microsoft have all released freely available versions of their flagship database servers, a move that would have been unheard of just a few years ago. While their respective representatives would argue the move was made in order to better accommodate the needs of all users, it's fairly clear that continued pressure from open source alternatives such as MySQL and PostgreSQL have caused these database juggernauts to rethink their strategies within this increasingly competitive market."

Business Factors in OSS Database Companies

After many years of slow and steady growth, open source software (OSS) has begun to make an impact on corporate culture. Online forums abound with discussions about how open source projects are changing the way businesses use software. Venture capital companies now look for open source projects to invest in and larger IT companies like IBM and Sun Microsystems are turning to open source to gain a competitive edge. OSS is a fast-growing influence and yet the topic of how business affects OSS companies has been rarely studied.

Jim Starkey Joins MySQL AB

Jim Starkey, the original creator of InterBase, which became Firebird, just made it publicly known that he now works for MySQL AB. "My company, Netfrastructure, Inc., has been acquired by MySQL, AB. As part of the agreement, I will be working full time for MySQL. I expect to lurk on the architecture list from time to time and may contribute the occasional wolf-o-gram, but I will not be taking an active part in Firebird development. Although Ann will work for MySQL, part time, translating from wolf to English, she will continue to be active in the Firebird project."

Oracle Tried to Buy Open-Source MySQL

Oracle tried to acquire open-source database maker MySQL, an indication of the profound changes the software giant is willing to make as it adapts to the increasingly significant collaborative programming philosophy. MySQL Chief Executive Marten Mickos confirmed the acquisition attempt in an interview at the Open Source Business Conference here but wouldn't provide details such as when the approach was made or how much money Oracle offered.

Running a MySQL-Based DNS Server: MyDNS

"In this tutorial I will describe how to install and configure MyDNS, a DNS server that uses a MySQL database as backend instead of configuration files like, for example, Bind or djbdns. This has the advantage that you can easily use web-based frontends to administrate your DNS records. MyDNS simply reads the records from the database, and it does not have to be restarted/reloaded when DNS records change or zones are created/edited/deleted! I will also show how to set up a secondary DNS server, but I will not use normal zone transfers to get the records from the primary to the secondary DNS server; instead, I will use MySQL database replication. I will simply replicate the data from the primary to the secondary server."

How to Set Up Database Replication In MySQL

"This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though."