Transcript MySQL_Donahue

MySQL GUI Administration Tools
Rob Donahue
Manager, Distributed Systems Development
May 7th, 2001
Overview
• OCLC SiteSearch 4.1.2 includes MySQL as
a replacement for mSQL.
• MySQL was originally developed to handle
very large databases much faster than
existing solutions and has been
successfully used in highly demanding
production environments for several years.
• MySQL is a client/server system that
consists of a multi-threaded SQL server
that supports different backends, several
different client programs and libraries,
administrative tools, and several
programming interfaces.
• MySQL is open source software under the
GNU public license (GPL).
Many Tools
• There are literally dozens of tools
available
• Tools are available on a variety of
platforms, both graphical and
command line
• Each tool is different in look and feel
but overall features are common:
–
–
–
–
–
Execute SQL queries
Browse Tables
Edit structure
Import / Export
Remote administration of databases
GUI Administration
• Several graphical administrative tools are
available:
– Web-based tools
– Wintel tools
– Unix tools
– Java Tools
Benefits of GUI Tools
• Easy addition and deletion of
authos.
• Import of authorizations in many
formats, such as a comma-delimited
file from your OPAC.
• Some tools provide reports that
may be useful.
• Many tools allow remote
administration.
Web-based tools
phpMyAdmin
• Open-Source, Freely
available
• Allows complete webadministration of multiple
databases
• Allows for direct entry of
SQL queries.
• Allows batch imports into
tables from delimited files.
• Easy to use
• Requires php 3.0
Wintel Tools
MySQL Admin
• Doesn’t require installation of
any drivers.
• Support in multiple languages
(English, Croatian, Italian,
French... ).
• User interface has MS
Access look and feel.
• Auxiliary connection to other
databases/hosts.
• Visual query builder.
• Auto logging and e-mailing of
unhandled exceptions.
Unix Tools
MySQLGUI
• Open Source – Freely
available
• Graphical SQL client for
MySQL
• Available for many platforms
including Windows
• Remote administration
capabilities
Java Based Tools
Fredy’s Java Admin
• Open-Source – Freely
available
• Requires JDK 1.2.2 or 1.3
• Requires JDBC driver
• Allows for remote
administration
• Has batch import / export
ability
Summary
• Many free tools available on
many platforms. Some even
have source-code available.
• Graphical interface makes
database administration easy.
• Can manipulate many databases
from different servers from a
central interface.
• MySQL ships with SiteSearch
4.1.2 May 11, 2001.
Where to Get Clients
A listing of links to clients is available at:
www.mysql.com/downloads/contrib.html
Questions?