Download - Let's Start MySQL
![Page 1: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/1.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Let’s Start MySQL …
Okcan Yasin Saygılı
![Page 2: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/2.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 2
Agenda
1.Mysql Fundementals
2.What’s LAMP ?
3.Who use Mysql ?
![Page 3: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/3.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 3
MySql Fundementals
MySQL is the world’s most popular open source database,
Why we use this ?
1. Enabling the cost-effective delivery of reliable
2. High-performance and scalable
3. Embedded database applications,
The top five websites and so on .
![Page 4: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/4.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 4
MySql Fundementals
It is an integrated, transaction safe, ACID−compliant database with full commit, rollback, crash recovery, and row-level locking capabilities.
MySQL delivers the ease of use, scalability, and high performance, as well as a full suite of database drivers and visual tools to help developers and DBAs build and manage their MySQL applications.
![Page 5: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/5.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 5
MySql Fundementals
High Performance & Scalability to meet the demands of exponentially growing data loads and users.
• Self-healing Replication Clusters to improve scalability, performance and availability.
• Online Schema Changes to meet changing business requirements.
• Performance Schema for monitoring user & application level performance and resource consumption.
![Page 6: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/6.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 6
MySql Fundementals
• SQL & NoSQL Access for performing complex queries and simple, fast Key Value operations.
• Platform Independence giving you flexibility to develop and deploy on multiple operating systems.
• Big Data Interoperability using MySQL as the operational data store for Hadoop and Cassandra.
![Page 7: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/7.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 7
MySql
• Full ACID compliant (with InnoDB)
• Stored routines, views, triggers
• Built-in replication
• Built-in partitioning
• Plugin architecture
• MySQL Cluster
![Page 8: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/8.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 8
Enterprise Manager and MySql
![Page 9: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/9.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 9
Support
Community always near you . Please Click http://dev.mysql.com/community/
![Page 10: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/10.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 10
Agenda
1.Mysql Fundementals
2.What’s LAMP ?
3.Who use Mysql ?
![Page 11: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/11.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 11
LAMP
LAMP is web-system architecture tools for developers , These are linux operating system , apache HTTP server , unique MySql server and PHP language.
![Page 12: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/12.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 12
LAMP
![Page 13: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/13.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 13
Agenda
1.Mysql Fundementals
2.What’s LAMP ?
3.Who use Mysql ?
![Page 14: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/14.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 14
![Page 15: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/15.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 15
![Page 16: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/16.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 16
References1. https://upload.wikimedia.org/wikipedia/en/thumb/6/62/MySQL.svg/1280px-MySQL.svg.png2. https://en.wikipedia.org/wiki/LAMP_(software_bundle)3. http://212.47.227.9/wp-content/uploads/2015/09/lamp-stack.jpg4. https://upload.wikimedia.org/wikipedia/commons/thumb/8/82/LAMP_software_bundle.svg/2000px-LAMP_so
ftware_bundle.svg.png5. https://g.twimg.com/Twitter_logo_blue.png6. https://www.mysql.com/common/images/products/EM_performancereport_querycache.png7. http://www.mysql.com/products/enterprise/mysql-datasheet.en.pdf8. http://www.oracle.com/us/products/mysql/overview/index.html9. http://www.slideshare.net/datacharmer/introduction-to-mysql-378958510. https://www.facebook.com/images/fb_icon_325x325.png11. https://en.wikipedia.org/wiki/MySQL12. http://www.slideshare.net/gkodinov/bgoug15-json-support-in-mysql-57?qid
=9b2e3622-09f5-405f-b22d-cdce724da0a7&v=default&b=&from_search=1
![Page 17: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/17.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 17
Questions ?
![Page 18: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/18.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 18
Safe Harbor StatementThe preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
![Page 19: Let's Start MySQL](https://reader035.vdocuments.us/reader035/viewer/2022070511/58a3cb911a28ab98588b5783/html5/thumbnails/19.jpg)
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 19