1 / 28

MySQL Overview

Explore the potential of MySQL in an Oracle shop, learn about MySQL's features, scalability, and use cases, and discover how it can be utilized as a replacement for Access and for data conveyance purposes.

yburkley
Download Presentation

MySQL Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MySQL Overview Is there a place for MySQL in an Oracle shop?

  2. Who is Brian Rawlings? • Data Architect @ Intermountain Healthcare • Database professional since 1994 • B.S. degree in Computer Science • MySQL experience includes • ETL processes at Intermountain Healthcare • Hobby programming • NOT an Oracle employee • NOT a MySQL consultant • NOT selling anything • twitter.com/BrianRawlings

  3. What is MySQL? False • Some common perceptions include: • Only a starter database • Not very powerful • Not scalable • No transaction support • No replication • Only popular with people who don’t know about Postgres or other open-source alternatives

  4. Who is using MySQL?

  5. Facebook 750 Million active users (last 30 days) 50% of Active users log in on any day Average user has 130 friends Average user has joined 80 community pages Average user creates 90 records monthly 30 Billion records served monthly Source: facebook.com/press/info.php?statistics

  6. Twitter 1 Billion tweets per week 140 Million tweets per day 1620 tweets per second 6939 record tweets per second 572,000 accounts in March 2011 1 Million Twitter apps Source: blog.twitter.com/2011/03/numbers.html

  7. YouTube About 3 billion views a day About 11,500 views per second 45 hours of video uploaded every minute Users upload the equivalent of 240,000 full-length films every week Millions of videos are favorited every day 100 million people take a social action on YouTube (likes, shares, comments, etc) every week Source: http://www.youtube.com/t/press_statistics

  8. Why use MySQL? “A lot of people using MySQL to create Web applications and online services choose to use MySQL because it enables them to scale up their environment in a fairly low-cost way,” says  Carl Olofson, research vice president of database management and data integration software research at International Data Corporation (IDC). “We’re also seeing a lot of companies using MySQL for reporting databases, databases for departmental servers, and databases for business-critical systems.” Source: oracle.com/technetwork/issue-archive/2011/11-jan/o11mysql-194109.html

  9. Total Cost of Ownership • MySQL is less expensive than proprietary databases • Basically only paying for support

  10. Total Cost of Ownership • MySQL Products • Community Edition - Free • Standard Edition – $2,000/server • Enterprise Edition - $5,000/server • Cluster Carrier Grade Edition - $10,000/server • ISV License also available

  11. TCO Comparison Source: mysql.com/tcosavings/ (Oracle and IBM removed from this list when Oracle bought MySQL from Sun.)

  12. Technical Standard heap tables and Btree indexes Partitioned tables ACID transaction support Row level locking ANSI SQL Server enforced referential integrity Standard datatypes like blob, varchar, numeric Built in replication Stored procedures Triggers Functions Cursors Updatable views Highly Available clusters Cost based query optimizer Backup with point in time recovery Capable of terabyte size dbs Column oriented data warehouse option Bonus: open source MySQL has the features you expect

  13. MySQL Versatility • Connections • Native C API, JDBC, ODBC, .NET, PHP, Python, Perl, VB • Pluggable Storage Engines • Memory, index & storage management • MyISAM, InnoDB, Cluster, Falcon, Archive, Federated, Merge, Memory… • Operating Systems • AIX, HP-UX, Linux, Mac OS X, Windows and others

  14. MySQL Scalability Scale out, not up MySQL Clusters/Replication Sharding

  15. Ease of Use Dowload the software and use complete the installation in less than 15 minutes.

  16. MySQLvs Oracle • Language differences • Dual • Sysdate • Decode() • Rownum • NVL • Join (+) syntax • Date functions • Data types • Case Sensitivity Source: mysqluc.com/presentations/mysql06/bradford_ronald.pdf

  17. MySQLvs Oracle • Language differences • Regular Expressions • Lacking count, substr, instr , replace • No WITH statement • No compiled packages • No sequences, only auto-number • By default transactions are auto-committed

  18. MySQL • Original Question: We’re an Oracle Shop. Is there any place for MySQL? • Replacement for Access • Data conveyance (ETL) • Parallel systems • Hybrid Systems • Replacement

  19. Access Replacement • Why do people use Access? • Already on their computer • Simple to use • Write SQL from drag-n-drop interface • Access databases can be bad • Multiple versions of the truth • No distribution • Limited security • Probably no backup, recovery, or version control plan

  20. Access Replacement • Keep Access as a front end, point to MySQL database as an external source • Single version of the truth • Manage Security • Use one of many MySQL GUI tools • MySQL Query Browser • MySQL Workbench • DB Forge Studio • Lots of others

  21. Data Conveyance • Vendors may provide you with MySQL databases • You might provide your data a subset of data with a MySQL database • Integrity Constraints • Easy to QA

  22. MySQL for Web Presence When it comes to databases and database applications, Olofson doesn’t necessarily think that there’s a one-size-fits-all solution. In fact, he often sees organizations using a combination of database solutions, such as MySQL and Oracle Database. “You’ll frequently see MySQL being used in specialized roles, such as for Web presence, while a company’s back-office systems might be driven by Oracle Database,” says Olofson. Source: oracle.com/technetwork/issue-archive/2011/11-jan/o11mysql-194109.html Oracle back end, MySQL Front end

  23. MySQL as Replacement “We moved from a commercial [non-Oracle] enterprise database to MySQL in 2003, and it was a great move for us,” says Jeff Freund, CEO and founding chief technology officer of San Francisco, California–based Clickability. “MySQL requires lower overhead to manage and a lower cost for team and support resources, and it just fit much better with our scaling architecture and need to run a SaaS [software-as-a-service] platform.” Source: oracle.com/technetwork/issue-archive/2011/11-jan/o11mysql-194109.html

  24. MySQL as Replacement • When could it be considered? • Two main factors • Thee larger the database the more complex it will be • How much reliance do you have on Oracle specific functionality that has no compliment in MySQL? • Bitmap indexes, packages, sequences, etc

  25. Summary MySQL is a robust database platform MySQL is the most popular DB on the web MySQL is a great solution for “The Access problem” MySQL could be considered for stand alone and hybrid applications, or as a replacement for current architecture.

  26. Download the Software Download MySQL from the MySQL website. dev.mysql.com/downloads/ Takes about 15 minutes

  27. More Resources • Mysql.com • Planet.mysql.com • "Migrating to MySQL – Is it Right For You" • mysql.com/news-and-events/on-demand-webinars/display-od-299.htm • mysql-dba-journey.blogspot.com • An Oracle DBA's experience running MySQL

  28. Questions

More Related