Report

1. What is MySQL?
MySQL is a popular Open Source SQL relatational database management system, is
developed, distributed, and supported by Oracle Corporation. The MySQL Database Server
is very fast, reliable, and easy to use. It works in client/server or embedded systems.

2. Who develops and who maintains MySQL?

MySQL was first developed by David Axmark, Allan Larsson and Michael "Monty"
Widenius. The official MySQL Workbench is mantained by MySQL AB and Oracle Corp.

3. How do you compare it to other DBMS? is it similar to Acces?

First, i have to say that MySQL and Access there aren't the same type of software. Access is
part of a Suite-Office and offers to store datas. In easy words, its a database but it can's be a
DBMS.
In grosso modo a DNMS have to offer this services:

-Abstraction of physical storage of information. Access does not comply.

-Consistency. Access does not comply.
-Security. Access does not comply.
-Backup and recovery. Access will meet both as a regular file, or anything.
-Control of the crowd. Concept to Access.

And more.
4. Visit the website of MySQL and find out about the different versions, create a table
with the different versions. Which one should we install?

Edition Information includes Price

MySQL Classic MySQL Classic Edition • Supports over 20 platforms and NS/NC
Edition is the ideal embedded operating systems including Linux,
database for ISVs, Unix, Mac and Windows so you
OEMs and VARs have ultimate flexibility in
developing read- development and deployment
intensive applications options.
using the MyISAM
storage engine. It is
proven as a high
performance and zero
administration database.
MySQL Standard MySQL Standard • MySQL Standard Edition includes 2000 $
Edition Edition enables you to InnoDB, making it a fully
deliver high- integrated transaction-safe, ACID
performance and compliant database. In addition,
scalable Online MySQL Replication allows you to
Transaction Processing deliver high performance and
(OLTP) applications. It scalable applications.
provides the ease of use
that has made MySQL
famous along with
industrial strength
performance and
reliability.
MySQL Enterprise MySQL Enterprise
Edition Edition enables you to • MySQL Enterprise Backup 5000 $
deliver high
performance, scalable
Online Transaction • MySQL Enterprise Monitor
Processing (OLTP)
database applications. It • MySQL Query Analyzer
is a fully integrated
transaction-safe, ACID
compliant database. It • MySQL Workbench
includes full commit,
rollback, crash recovery
and row level locking
capabilities. Database
Partitioning allows you
to improve performance
and management of
very large database
environments.
MySQL Community Pluggable Storage Engine Architecture
MySQL Community Edition is the freely Free
Edition downloadable version of • Multiple Storage Engines:
the world's most popular • InnoDB
open source database. It • MyISAM
is available under the • NDB (MySQL Cluster)
GPL license and is • Memory
supported by a huge and • Merge
active community of • Archive
open source developers. • CSV
• and more
• MySQL Replication to improve
 application performance and
scalability
• MySQL Partitioning to improve
performance and management of
large database applications
• Stored Procedures to improve
developer productivity
• Triggers to enforce complex
business rules at the database level
• Views to ensure sensitive
information is not compromised
• Information Schema to provide easy
access to metadata
• MySQL Connectors (ODBC,
JDBC, .NET, etc) for building
applications in multiple languages
• MySQL Workbench for visual
modeling, SQL development and
administration

5. For what platforms can we install MySQL?

MySQL works with this plataforms: AIX, BSD, FreeBSD, HP-UX, GNU/Linux, Mac OS X,
NetBSD, Novell Netware, OpenBSD, OS/2 Warp, QNX, SGI IRIX, Solaris, SunOS, SCO
OpenServer, SCO UnixWare, Tru64, eBD, Windows 95, Windows 98, Windows NT,
Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server (2000, 2003
and 2008),OpenVMS...

6. Download the official MySQL 5.5 reference guide and any other interesting tutorial.
http://dev.mysql.com/doc/refman/5.5/en/

7. Follow the appropiate instructions for your system and install MySQL. Create a small
HOW-TO with a step by step guide. Poner que e puesto xamp y como se enciende
server, porque es automatico (carpeta bin se metio todo)
-Go to “Administración” and click in “Paquetes Synaptics”
- Search for Mysql 5.1 client and Server.
-Select them and click in “aplicar”.
-Now Mysql is being installed in your computer.
-Open a console and go to the folder of mysql: cd /bin/share/mysql
-The go to /etc and open with sudo nano my.cnf
-You have to edit this with this code: --default-storage-engine=innodb to the /etc/mysql/my.cnf
-The save the file and enjoy of Mysql.

The first HOW-TO didn't work. So i had to install Xammp. When a get installed i looked for the
direct access form the folder opt/lammp/lammp and i pasted it in the folder bin. Then putted in the
console to start mysql server when the computer starts. So now i only have to put “mysql” to run it.
8. What are the programs "mysql" and "mysqld"? what is the architecture of MySQL?
“mysql” is the process who indicates that MySQL Server in running on the pc.
“mysqld”, also known as MySQL Server, is the main program that does most of the work in
a MySQL installation. MySQL Server manages access to the MySQL data directory that
contains databases and tables. The data directory is also the default location for other
information such as log files and status files.
9. How do you start MySQL?
I have to put in console “mysql” or “mysql -u root ”

10.Log on the MySQL and write "show tables;"? what do we get? what is this?

mysql> show schemas;

+--------------------+
| Database |
+--------------------+
| information_schema |
| cdcol |
| mysql |
| performance_schema |
| phpmyadmin |
| test |
+--------------------+
6 rows in set (0,02 sec)
mysql> use test;
Database changed
mysql> show tables;
Empty set (0,00 sec)

11.How would we create a small database with 2 tables. You don't need to do it, just
explain the general process.

CREATE DATABASE primera_base_datos ----> First we have to create de database

USE primera_base_datos ----> The we have to say: we are going to use the table.
CREATE TABLE primer_atributo ---> Finally we create the atributs
CREATE TABLE segundo_atributo

12.What or who is Sakila?

The name of the logo (the dolphin)

13.What standards does MySQL follows?

MySQL is a SQL (Structured Query Language) database server. SQL is the most popular
database language in the world. MySQL is a client server implementation that consists of a
server daemon mysqld and many different client programs/libraries. It support the full
ANSI/ISO SQL standard, but without making concessions to speed and quality of the code.

14.What is SQL and what standards does it have?

Structured Query Language, is a database computer language designed for managing data in
relational database management systems (RDBMS), and originally based upon relational
algebra and calculus. Its scope includes data insert, query, update and delete, schema
creation and modification, and data access control.
Although SQL is an ANSI (American National Standards Institute) standard, there are many
different versions of the SQL language.However, to be compliant with the ANSI standard,
they all support at least the major commands (such as SELECT, UPDATE, DELETE,
INSERT, WHERE) in a similar manner.
15.What are MyISAM and InnoDB? Do a small comparation of them.
MyISAM was the default storage engine for the MySQL relational database management
system versions prior to 5.5. It is based on the older ISAM code but has many useful
extensions. The major deficiency of MyISAM is the absence of transactions support.
Versions of MySQL 5.5 and greater have switched to the InnoDB engine to ensure
referential integrity constraints, and higher concurrency.

InnoDB is the default storage engine for MySQL as of MySQL 5.5, included as standard in
most binaries distributed by MySQL AB, the exception being some OEM versions. It
provides the standard ACID-compliant transaction features, along with foreign key support
(Declarative Referential Integrity).

Comparison:

*InnoDB recovers from a crash or other unexpected shutdown by replaying its logs.
MyISAM must fully scan and repair or rebuild any indexes or possibly tables which had
been updated but not fully flushed to disk. S
*MyISAM relies on the operating system for caching reads and writes to the data rows while
InnoDB does this within the engine itself, combining the row caches with the index caches.
Dirty (changed) database pages are not immediately sent to the operating system to be
written by InnoDB, which can make it substantially faster than *InnoDB stores data rows
physically in pages in primary key order while MyISAM typically stores them mostly in the
order in which they are added. When the primary key is selected to match the needs of
common queries this can give a substantial performance benefit.
*InnoDB provides page compression that allows updating of the compressed pages, unlike
compressed MyISAM tables.
*When operating in fully ACID-compliant modes, InnoDB must do a flush to disk at least
once per transaction, though it will combine flushes for inserts from multiple connections.

16.Is MySQL opensource? what license does it have? can we use it for commercial use?
MySQL offers MySQL 5.1 and 5.5 in two different variants: the open source MySQL
Community Server and the commercial Enterprise Server. The source code is available
under the terms of the GNU General Public License, as well as under a variety of proprietary
agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish
company MySQL AB, now owned by Oracle Corporation.

17.What is ACID?
The ACID model is one of the oldest and most important concepts of database theory. It sets
forward four goals that every database management system must strive to achieve:
atomicity, consistency, isolation and durability. No database that fails to meet any of these
four goals can be considered reliable.
 18. Find information about any possible GUI to manage MySQL and compare them.
Which one will you choose for our practice.

Top 10: Manufacturer Website Price License Supported Information

platforms
Sun Systems/ http://dev. FREE GPL Microsoft MySQL Workbench is a visual
Workbench Oracle mysql.com License Windows, database design tool that
/download Mac OS X integrates SQL development,
s/workben and Linux administration, database design,
ch/ creation and maintenance into a
single development environment
PremiumSoft http://ww 30 Available Microsoft Navicat for MySQL is both a
Navicat ™ CyberTech w.navicat. DAYS under Windows, database administration and
Ltd. com/en/pr Trial, Commercial Mac OS X development tool.
oducts/nav MORE or Non- and Linux
icat_mysql THAN commercial
/mysql_ov 100 € licenses.
erview.htm
l
The Sequel http://ww FREE GNU GPL Mac OS X Sequel Pro is an application used
Sequel Pro Pro Project w.sequelpr 2.0 Tiger to manage MySQL databases
o.com/ Universal (locally or over the Internet).
Build
Ansgar Becker http://www FREE GNU Windows To manage databases with
HeidiSQL .heidisql.c General 2000, XP, HeidiSQL, users must login to a
om/ Public Vista, 7 local or remote MySQL server with
License acceptable credentials, creating a
session. Within this session, users
may manage MySQL Databases
within the connected MySQL
server, disconnecting from the
server when done. Its feature set
is sufficient for most common and
advanced database, table and
data record operations but
remains in active development to
move towards the full
functionality expected in a MySQL
Frontend.
The http://www FREE GNU Microsoft PhpMyAdmin is a FREE software
phpMyAdmi phpMyAdmin .phpmyad General Windows, tool written in PHP intended to
n Project min.net/ho Public Mac OS X handle the administration of
me_page/ License, and Linux, MySQL over the Internet.
version 2 PHP 4 - 5 PhpMyAdmin supports a wide
and MySQL 3 range of operations with MySQL,
-5 the most frequently used being
the managing of databases,
tables, fields, relations, indexes,
users, permissions. You still have
the ability to execute SQL
statements directly as well.

Nerocode http://ww $99.00 shareware Windows Nerocode SQLWave is a MySQL

SQLWave w.nerocod 2000, XP, GUI Client tool designed to
e.com/ Vista, 7 automate and simplify the
database development process. It
also provides an easier way to
explore and maintain existing
databases, design compound SQL
statements, query and manipulate
data in different ways. MySQL
4.x - 6.x compliant.
 devart http://ww FREE Commercial Windows DbForge Studio for MySQL
dbForge w.devart.c for and non- 2000, XP, offers visual MySQL
Studio om/dbforg express commercial Vista, 7 development and administration.
e/mysql/st edition, licenses
udio/ $49.95 available
(non-
commerc
ial
standard
edition),
$99.99
(non-
commerc
ial
professio
nal
edition)
DBTools http://ww Standard Standard Windows Specially designed for personal
DBTools Software w.dbtools. Edition Edition is 2000, XP, use, it has a minimum set of
Manager com.br/EN is FREE. licensed Vista, 7 features that makes it ideal for
/dbmanage Enterpris under new database users to perform
rpro/ e is standard basic database management. You
$69.90 freeware can use this edition for FREE for
USD for conditions. non commercial use. For
a single commercial use, you can purchase
license. a license which will provide
additional features.
H2LSoft, Inc. http://ww FREE freeware Windows Developers will appreciate its
MyDB Studio w.mydb- 2000, XP, ability to create/edit/drop database
studio.com Vista, 7 objects, DB synchronization, and
data export/import. DBAs can
also use MyDB Studio to perform
database migration, as well as
backups and restores. It supports
SSH tunneling to secure your
connections, which allows you to
connect even if your host doesn't
allow you remote access
connection, user and privilege
management, and PHP script
creation.