470 likes | 861 Vues
MySQL. An Introduction www.asyrani.com. Databases 101. What is SQL. SQL ( Structured Query Language is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). What is MySQL ?.
E N D
MySQL An Introduction www.asyrani.com
What is SQL • SQL(Structured Query Languageis a special-purpose 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 (2ndafer 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
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 GPL open source License Embedded Database 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 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 Gold Silver Basic $4995/server/Year $2995/server/Year $1995/server/Year $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 • 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”
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
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