C-JDBC Tutorial A quick start

Short Description
C-JDBC. To proceed with this tutorial you will only need a Java Virtual Machine compliant to J2SE 1.3 or greater. C-JDBC is a database cluster middleware …

Website: c-jdbc.objectweb.org | Filesize: 1324kb

Content
C-JDBC Tutorial - A quick start
Version 0.4
Date 04/11/05
Authors:
Nicolas Modrzyk (Nicolas.Modrzyk@inrialpes.fr)
Emmanuel Cecchet (Emmanuel.Cecchet@inrialpes.fr)
Table of Contents
Introduction………………………………………………………………………………………………………………………………………..3
Getting C-JDBC ………………………………………………………………………………………………………………………………..5
Installing C-JDBC components…………………………………………………………………………………………………………..6
A quick tour of the C-JDBC directory…………………………………………………………………………………………………..9
Description of the RAIDb1 Demo……………………………………………………………………………………………………….11
Description of the distributed-raidb1 Demo………………………………………………………………………………………….12
Start and play with the RAIDb1 demo………………………………………………………………………………………………….13
Starting the demo…………………………………………………………………………………………………………………………13
Playing with SquirrelSQL, the SQL console…………………………………………………………………………………….14
First steps with the Graphical Administration Console………………………………………………………………………..17
Starting the GUI…………………………………………………………………………………………………………………………..17
Disabling a backend……………………………………………………………………………………………………………………..19
Enabling a disabled backend………………………………………………………………………………………………………….19
Creating a backup of a backend………………………………………………………………………………………………………20
Adding a backend to the cluster………………………………………………………………………………………………………21
Monitoring C-JDBC components……………………………………………………………………………………………………….23
Generate a bug report………………………………………………………………………………………………………………………..26
Further readings………………………………………………………………………………………………………………………………..28
1Introduction
This is a document to help you learn the basics and get started with the database clustering software called
C-JDBC.
To proceed with this tutorial you will only need a Java Virtual Machine compliant to J2SE 1.3 or greater.
C-JDBC is a database cluster middleware that allows any Java application (standalone application, servlet
or EJB container, …) to transparently access a cluster of databases through JDBC(tm).
You do not have to modify client applications, application servers or database server software. You just
have to ensure that all database accesses are performed through JDBC.
C-JDBC provides a flexible architecture that allows you to achieve scalability, high availability and failover
with your database tiers. C-JDBC instantiates the concept of RAIDb : Redundant Array of Inexpensive
Databases. The database is distributed and replicated among several nodes and C-JDBC load balance the
queries between these nodes.
C-JDBC is a free, open source initiative.
C-JDBC provides a generic JDBC driver to be used by the clients. The client drivers forward the SQL
requests to the C-JDBC controller that balances them on a cluster of replicated databases (reads are load
balanced and writes are…