Sun released a document that describes the installation of MySQL 5.1 cluster software for the Sun Fire X4100 M2 servers which can run the Solaris 10 Operating System as x64 platforms. For two scenarios in which data is loaded and manipulated, the adjustment of the MySQL configuration necessary to execute these tasks is described in the article, including the installation which was performed with the Release Candidate Development Release of the MySQL 5.1 Community Edition software distribution. The contents of the 25pg. PDF are as follows:

The MySQL Software

• MySQL Cluster Software
• Node Types
• High Availability Concept
• Partitioning
• Availability of the MySQL Cluster Software

Scope and Limitations

• Audience
• Installation
• Prerequisites
• Compilation of the Source
• Installation of the MySQL Server Software

Configuration of a MySQL Cluster

• Overview
• MySQL Cluster Configuration Files
• Starting and Stopping Components of a MySQL Cluster
• Cluster Messages and Error Log Files
• User Accounts and File Ownership
• Storage Management in a MySQL Cluster

The MySQL Software MySQL software is the most popular relational database management system (RDBMS) software in the open source space and part of the LAMP stack, which is a collection of software for dynamic web pages. Among the features that differentiate MySQL software from other well-known RDBMS software are:

• Support for a broad variety of operating system platforms

• Choice of storage engines with different locking, indexing, and logging capabilities, enabling an optimal tailoring of the database with regards to hardware resources and requirements of the application on top.

"MySQL cluster software enables users to implement a MySQL database on commodity hardware using an approach for fault tolerance, which ensures that data remains available even in the event of a failure of a database server or storage component. The manner of clustering MySQL software described in this paper is accomplished on the application level with no resources being shared among the cluster members at all, in contrast to cluster concepts that operate on the operating system level, such as Sun Cluster software, where the cluster members share one or more storage resources," as said in the article.

"Implementing high availability for MySQL software using Sun Cluster software is described elsewhere. While a detailed technical description of the design principles of MySQL cluster software can be found on the MySQL web site, an exhaustive discussion about the benefits and caveats of such a high availability solution is beyond the scope of this paper. The following section provides a brief terminology of a MySQL cluster environment. It should be noted that, while the availability and integrity of data in the MySQL database can be shielded against hardware failures, existing client sessions, client connections, and active transactions are not protected by this MySQL clustering concept and might suffer from such failures."

More Information

Installation of MySQL 5.1 Cluster Software on the Solaris 10 OS for x64 Platforms

Setting Up MySQL Cluster Software Using Solaris Zones Partitioning Technology [...read more...]

fullsource

From the latest issue:

Recent Blog Entries as of March 22, 2010, 7:55 am
Oracle Works to Assuage the Anxieties of Its Customers SysAdmin News Bites Oracle Enterprise Manager Ops Center Released Suits and Their Countersuits A More Direct Channel Model Planned for Oracle-Sun	The Importance of Information Storage and Management Sun POJO Service Engine User's Guide Sun Storage 7000 2010.Q1 Quality and Features PSA Deploys GlassFish in the Manufacture of Peugeot, Citroën Vehicles Running VirtualBox VMs as Services in Windows
Blog RSS Feed