Ubuntu 7.10 Linux Unleashed, Third Edition

Chapter 21. Administering Database Services

<feature><title>In This Chapter</title>

• A Brief Review of Database Basics

• Choosing a Database: MySQL Versus PostgreSQL

• Configuring MySQL

• Configuring PostgreSQL

• Database Clients

• Reference

</feature>

This chapter is an introduction to MySQL and PostgreSQL, two database systems that are included with Ubuntu. You will learn what these systems do, how the two programs compare, and how to consider their advantages and disadvantages. This information can help you choose and deploy which one to use for your organization’s database needs.

The database administrator (DBA) for an organization has several responsibilities, which vary according to the size and operations of the organization, supporting staff, and so on. ...