Transcript MySQL - asyrani.com

MySQL
An Introduction
www.asyrani.com
Databases 101
What is SQL
• SQL (Structured Query
Language is a specialpurpose programming
language designed for
managing data held in
a relational database
management
system (RDBMS).
What is MySQL ?
•
MySQL is an open source relational database
management system.
•
It includes the SQL server and client programs for
accessing the server.
•
Widely used by web application developers, together
with PHP and APACHE
•
A database is a structured collection of data. It may be
anything from a simple shopping list to a picture gallery
or the vast amounts of information in a corporate
network. To add, access, and process data stored in a
computer database, you need a database
management system such as MySQL Server. Since
computers are very good at handling large amounts of
data, database management systems play a central
role in computing, as standalone utilities, or as parts of
other applications.
Fact Sheet
• Most popular open source database
(2nd afer SQLite)
• Over hundreds million copies
downloaded or distributed
• More than 6 million active installations
• Hundred Thousand downloads a day
• Certified for all SAP applications
• Elite client list—Yahoo!, NASA,
Google
• Proven track record
Why learn MySQL?
•
•
•
•
•
•
•
•
•
Leading open source RDBMS
Ease of use – No frills
Fast
Robust
Security
Multiple OS support
Free
Technical support
Support large database– up to 50
million rows, file size limit up to 8
Million TB
The MySQL Value Proposition
IBM, ORACLE and Microsoft
“The top dogs”
The enterprise/SMB market
Market Strength, Brand Equity, Track Record and Feature Variety
MySQL “The underdog” – Disruptive technology, Commoditized Market
Performance, Reliability, Security, Performance
MySQL RDBMS SOURCE
Commercial License
Embedded Database
GPL open source License
Client-Server model
Standalone server
FREE
Service Support, training and Consulting
Which edition to use?
• MySQL Enterprise
– most comprehensive offering of MySQL database
software, services and support
• MySQL Cluster
– a fault tolerant database clustering architecture
for deploying highly available mission-critical
database applications
• MySQL Embedded Database
– most popular choice for OEMs/ISVs who want to
cost-effectively embed or bundle a reliable and
high-performance relational database
• MySQL community edition
MySQL Community vs. Enterprise
MySQL Enterprise
• MySQL Enterprise Monitor
– a "Virtual DBA Assistant" to enforce MySQL
recommended best practices
• MySQL Enterprise Server
• MySQL Production Support
– get your toughest technical questions
answered quickly
– advise you on how to properly design and
tune your MySQL servers, schema, queries,
and replication set-up
Platinum
$4995/server/Year
Gold
$2995/server/Year
Silver
$1995/server/Year
Basic
$595/server/Year
Where can I get MySQL ?
• http://www.mysql.com/downloads/
• Make sure you pick the correct version
for your OS
• Download MySQL 5.0 Community
Server GA
• Download MySQL Administrator
• Download MySQL Migration Toolkit
• Download MySQL Query Browser
Installing the server
• Follow the screenshots
Installing the server
Installing the server
Installing the server
Installing the server
Installing the server
Installing the server
Installing the server
Installing the server
• If you have firewall, remember
to unblock TCP port 3306
• If you prefer GUI operations,
install Administrator, Migration
Toolkit and Query Brower
• Configuration parameters
stored in “C:\Program
Files\MySQL\MySQL Server
5.0\my.ini”
• Change configuration by
“server instance configuration
wizard”
MySQL administrator
Query browser
A set of command line utilities
• mysqld, mysql, mysqladmin, mysqldump
(located in C:\Program Files\MySQL\MySQL
Server 5.0\bin)
• What is it ?
• Why do I want to use it ?
• For what all can I use it ?
• See handout later
About Data types …
• Detailed help in describing your
fields can be found online at the
MySQL user manual. These two
links are very helpful
http://dev.mysql.com/doc/refman/5.0/en
/string-types.html
http://dev.mysql.com/doc/refman/5.0/en
/numeric-types.html
In General:
Refer to chapter 11 of the user manual at
www.mysql.com/doc/en/Reference.html
Quick Example of data types
privileges
Storage engine and table types
• ISAM
– Indexed Sequential Access Method
– Fastest table type in MySQL
– Originally used in mSQL by TcX (the
predecessor of MySQL AB)
– Do not support transactions and
foreign key
– No longer supported after version 5.1
• InnoDB
– Purchased by MySQL later
– Large data volume, heavy-load
production system
– Support transactions and foreign key
Word of advice ..
•
•
•
•
•
•
Describe your fields correctly
Describe your data tightly
Secure your server well
Understand the mechanics
Use the manual
Use the mailing list
Conclusion
• MySQL is a database system used on
the web
• MySQL is a database system that runs
on a server
• MySQL is ideal for both small and
large applications
• MySQL is very fast, reliable, and easy
to use
• MySQL supports standard SQL
• MySQL compiles on a number of
platforms
• MySQL is free to download and use
• MySQL is developed, distributed, and
supported by Oracle Corporation
• MySQL is named after co-founder
Monty Widenius's daughter: My
Questions ?