280 likes | 290 Views
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.
E N D
MySQL Overview Is there a place for MySQL in an Oracle shop?
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
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
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
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
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
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
Total Cost of Ownership • MySQL is less expensive than proprietary databases • Basically only paying for support
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
TCO Comparison Source: mysql.com/tcosavings/ (Oracle and IBM removed from this list when Oracle bought MySQL from Sun.)
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
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
MySQL Scalability Scale out, not up MySQL Clusters/Replication Sharding
Ease of Use Dowload the software and use complete the installation in less than 15 minutes.
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
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
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
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
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
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
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
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
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
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.
Download the Software Download MySQL from the MySQL website. dev.mysql.com/downloads/ Takes about 15 minutes
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