DBAs Guide to Databases Under Linux

Preface

Chapter 1. The Linux Operating System

A Brief History of Linux

The Linux Kernel

The Future of Linux Development

Linux Distributions

The Difference between Linux and Other Operating Systems

Feature Rich

Multitasking

Why Choose Linux

When to Use Linux

Servers and Workstations

Recommended Hardware

Migrating to Linux Workstations

Distributions of Linux

Quick Distribution Reviews

Considerations Before Upgrading or Migrating

Hardware Compatibility

Upgrading

Migrating from Another OS

Choosing a Distribution

How to Begin the Process

How to Get Your People Started

Summary

FAQs

Chapter 2. A Basic Red Hat Linux Installation

Introduction

Separate Physical Machine

Choosing a Distribution of Linux

Preliminary Installation Decisions

Hardware

Multiple CPUs

RAM

Disks

RAID

Network Interface(s)

Backup Issues

Support Issues

Installation Preliminaries

Installing Red Hat

A Quick Installation Run-Through

Choosing an Installation Type

Custom (Manual) Installation

Creating the Partitions to Your Specifications

Network Setup

Time Zone Selection

root Account Configuration

Authentication

Package Selection

X Window Installation (Optional)

Package Installation

Linux Loader (LILO) and Boot Disk

Installation Done

Configuring the Server to Run a Database

Things to Watch Out For

Other Flavors of Linux

Summary

FAQs

Chapter 3. Installing and Running Oracle on Linux

Introduction

Concepts

System Global Area

Program Global Area

Tablespace

Datafile

Extent

Segment

Control Files

Redo Logs

Rollback Segments

Parameter Files

Version Identifiers

PL/SQL

Schema

Installation

Pre-Installation

Installing Oracle8

Installing Oracle8i

Post-Installation

Using Oracle8/8i

Startup and Shutdown

Background Processes

Creating an Account

SQL*Plus

Data Dictionary

Import/Export

Third-Party Software

Orasoft

Orac

Perl/DBI

Summary

FAQs

Chapter 4. An Informix Installation on Linux

Introduction

Installation

Part I: Acquisition and Server Placement of the Software

Part II : Installation and Branding

Part III: Disk Setup and Server Operation

Setting Up Data Files for Informer

About Disks

Disks and Directories

Space Considerations

Configuration

$INFORMIXDIR/etc/$ONCONFIG

$INFORMIXDIR/etc/sglhosts

/etc/services

/opt/data/rootdbs

Starting Your Engine with oninit

Stopping Your Engine

Final Configuration

Review

Physdbs

Create a physdbs File

Logsdbs

Create logsdbs

Create New Logical Logs

Tempdbs

Final $ONCONFIG Configuration Settings

Restart Your Engine

Other Tools

Dbaccess

Onmonitor

Resources

Informix Technical Support

Informix Web Site

Usenet News Group comp .databases.informix

International Informix User Group (IIUG)

Informix Press

Informix Training

Summary

FAQ

Chapter 5. Installing and Utilizing Sybase on Linux

Introduction

Installation

Installing SQL Server 11.0.3

Installing Optional Client Software

Configuration

Configuring Sybase Database Server

Configuring Sybase Backup Server

Configuring Sybase Client/Server Libraries

Starting the Database Server and Backup Server on Boot

Setting the System Administrator's Password

Configuring Database Devices and Databases

Creating User Logins and Permissions

Testing the Database

Database Design

Issues

Identity Columns (Auto Increment)

SQL Conformance

Run Environment

Summary

FAQs

Chapter 6: Installing DB2 Universal Database Version 6.1 on Red Hat Linux

Introduction

Preparing Your Red Hat Workstation for a DB2 Installation

Preparing Red Hat Version 5 .2 and Version 6 .0 for a DB2 Installation

Preparing Red Hat Version 6 .1 for a DB2 Installation

Installing DB2

Performing the Installation

Verifying the Installation

Configuring the Control Center

Installing a DB2 Client

Configuring a DB2 Client to Communicate with a DB2 Server

Troubleshooting the Connection

Summary

FAQs

Chapter 7. MySQL on Linux

Introduction

Installation

Naming Conventions

Installation of Binary Distribution

Installation of RPM Distribution

Installation of Source Distribution

Configuration

Security

Privileges

Access Control

System Setup

Performance

Issues

Threads

Run Environment

Summary

FAQs

Chapter 8. Installing and Managing Progress on Linux

Introduction

Installation

Install from Media

Kernel Parameters

Environment Setup

Configuration

Directory Structure

Disk Space versus I/O Throughput

Creating a New Database

Sizing the Buffer Pool

Running Progress

Managing the Database

Troubleshooting

Hung Users, Runaways, and Other Psychos

Strengths and Weaknesses

Summary

FAQs

Chapter 9. PostgreSQL on Linux

Introduction

Internet Power Drives PostgreSQL

Getting PostgreSQL

PostgreSQL Quick-Install Instructions

Detailed Installation

Installation of the Source Distribution

Before You Start

Step-by-Step Procedure

PostgreSQL Examples RPM

Testing Tcl/Tk Interface

Testing Python Interface—PyGreSQL

Testing the Perl Interface

Testing the libpq and libpq++ Interfaces

Testing Java Interfaces

Testing the ecpg Interface

Testing the ODBC Interface

Testing MPSQL Motif-Worksheet Interface

Testing SQL Examples—User-Defined Types and Functions

Verification of PostgreSQL Install

Emergency Bug Fixes

How Can I Trust PostgreSQL

System Layout

Kerberos Authentication

Availability

Installation

Operation

Runtime Environment—Using Postgres from UNIX/LINUX

Starting Postmaster

Using pg_options

Recognized Options

Security

User Authentication

Host-Based Access Control

Authentication Methods

Creating Users

Creating Groups

Access Control

Functions and Rules

Functions

Rules

Caveats

Secure TCP/IP Connection

Adding and Deleting Users

Disk Management—Supporting Large Databases

Alternate Locations

Managing a Database

Creating a Database

Accessing a Database

Destroying a Database

Backup and Restore

Large Databases

Troubleshooting—Postmaster Startup Failures

Client Connection Problems

Debugging Messages

pg_options

Technical Support

Mailing Lists

E-mail Account for PostgreSQL

English Mailing List

Archive of Mailing List

Spanish Mailing List

GUI Front-End Tool for PostgreSQL

ODBC, JDBC, and UDBC Drivers

Perl and DBI Interfaces

Tutorial for PostgreSQL

Internet URL Pointers

PostgreSQL URL References

Summary

FAQs

Chapter 10. Developing a Web-Based Application

Introduction

Web Application Platforms

Active Server Pages

Cold Fusion

Java Server Pages

Zope

Scripting Languages

PHP

Apache

Getting Started

Design Goals

Designing the Schema

Data Flow

PHP, MySQL, and Apache: Installing the Sample Application

PHP Database Connectivity : Making the Connection

Summary

FAQ

Appendix A. PHP Script for Shopping Cart Application

Appendix B. Dump File for Shopping Cart Application

Index