Slide 1

Slide 1 text

Best Practices for Migrating to MySQL For existing Oracle/SQL Server environments Ronald Bradford Principal - 42SQL http://42sql.com Washington DC 18th Feb 2009 1. Reasons to Migrate to MySQL 1 Monday, February 16, 2009

Slide 2

Slide 2 text

Workshop Agenda 1. Reasons to migrate to MySQL 2. Ideal application candidates 3. Migration process overview 4. Migration assistance tools 5. Specific migration issues 6. Ideals for minimizing future migrations 7. Additional MySQL information 2 Monday, February 16, 2009

Slide 3

Slide 3 text

Session Agenda • Is migration possible? • MySQL in the workplace • MySQL Client examples • Where do I start with migration • Reasons to migration • Roadblocks to migration 3 Monday, February 16, 2009

Slide 4

Slide 4 text

Is Migration Possible? 4 Monday, February 16, 2009

Slide 5

Slide 5 text

The short answer is Yes 5 Monday, February 16, 2009

Slide 6

Slide 6 text

Is Migration Possible? • Short answer is Yes? • MySQL is enterprise ready • 14 year old product • Provides commercial support and indemnity • Well established to deliver success on web • Not just a web product You interact with MySQL supported systems every day 6 Monday, February 16, 2009

Slide 7

Slide 7 text

MySQL in the workplace • Web • Web 2.0 • Telecom • On Demand/SaaS • Hosting • Enterprise • OEM/Embedded • Gaming 7 Monday, February 16, 2009

Slide 8

Slide 8 text

Usual Suspects • Facebook • Wikipedia • Craigslist • Yahoo • YouTube • Omniture • Travelocity • Twitter • GoDaddy • Flickr • Fotolog • TicketMaster 8 Monday, February 16, 2009

Slide 9

Slide 9 text

Marketing Examples 9 Monday, February 16, 2009

Slide 10

Slide 10 text

NASA Application Informing the general public on contract opportunities, managing large acquisitions on line Key Business Benefit Saves NASA and its partners $4 million annually Catalyst to Migration Decision Previous database vendor restructured its license program, causing NASA to be faced with fees that were “more than twice the total annual budget” Post Migration Results - License fees were significantly lower - MySQL averaged 28% faster, compared to other databases - Running 3 years without any loss of data or down time - “The cost of the optional technical support for MySQL was a fraction of that for the product previously used” http://mysql.com/news-and-events/generate-article.php?type=ss&id=nasa 10 Monday, February 16, 2009

Slide 11

Slide 11 text

The Weather Channel • Software & Hardware overhaul • Reported • 30% increased capacity • 50% decreased cost • Sun Solaris to x86 commodity H/W & Linux • Websphere to Tomcat • Oracle to MySQL http://mysql.com/customers/customer.php?id=22 11 Monday, February 16, 2009

Slide 12

Slide 12 text

Google "Google runs critical business systems with InnoDB and MySQL. The systems require 24×7 operation with minimal downtime. The systems support large OLTP and reporting workloads. We are very happy with the scalability, reliability and manageability of this software." http://www.innodb.com/innodb/users/ 12 Monday, February 16, 2009

Slide 13

Slide 13 text

Embedded Deployment • Easy not to realize where MySQL is in use • e.g Support Systems • Documentation • Issue Tracking • Publication • Ad Tracking 13 Monday, February 16, 2009

Slide 14

Slide 14 text

MySQL and Wordpress • New York Times • CNN • Fox News • Wall Street Journal • Reuters • Time Inc • Financial Times • Rolling Stone Magazine http://wordpress.com/notable-users/ • Harvard • NASA • Xerox • Tech Crunch • Nancy Pelosi • Stephen Colbert 14 Monday, February 16, 2009

Slide 15

Slide 15 text

MySQL in the Enterprise • Dow Jones • NASDAQ • Reuters • ESPN • NBC/GE • New York Times • Comcast Embedded • Cisco • McAfee • Adobe 15 Monday, February 16, 2009

Slide 16

Slide 16 text

MySQL Marketplace 16 Monday, February 16, 2009

Slide 17

Slide 17 text

Where do I start with Migration? 17 Monday, February 16, 2009

Slide 18

Slide 18 text

MySQL Migration References http://mysql.com/why-mysql/migration/ • White Papers http://mysql.com/why-mysql/white- papers/mysql_wp_oracle2mysql.php http://dev.mysql.com/tech-resources/ articles/migrating-from-microsoft.html • Customer Migrations http://www.mysql.com/customers/?migration 18 Monday, February 16, 2009

Slide 19

Slide 19 text

MySQL Migration References • This workshop • Migration Overview • Migration Products • Migration Partners • Ideal Candidates • Roadblocks 19 Monday, February 16, 2009

Slide 20

Slide 20 text

Reasons 20 Monday, February 16, 2009

Slide 21

Slide 21 text

Reasons to Migrate • Cost / TCO • e.g. Subscription v License • EOL H/W & S/W • Integration into newer systems • Asked to • Forced to • Physical resources • Trend 21 Monday, February 16, 2009

Slide 22

Slide 22 text

Cost / TCO • Truly difficult to value • Software • Hardware • Support • Skills • Staff Can you state your $ per customer investment 22 Monday, February 16, 2009

Slide 23

Slide 23 text

Cost / TCO • Easy when starting a new project now • Open Source • Zero entry point - Licenses • Zero entry point - Subscription (if desired) • VC preferred But 23 Monday, February 16, 2009

Slide 24

Slide 24 text

Cost / TCO Less measurable incidentals • Staff skills / proficiency • Infrastructure • e.g. H/W • Integration points • Reference material / procedures 24 Monday, February 16, 2009

Slide 25

Slide 25 text

EOL • Newer H/W is significantly cheaper • More verses Larger • Growth, Redundancy, Co Location • Existing licensing may be prohibitive • Potential environmental impact 25 Monday, February 16, 2009

Slide 26

Slide 26 text

Going Green "We do worry about how to maximize page views for kilowatt hours" Jim Buckmaster, CEO Craigslist • Page views per kilowatt hour: The socially responsible benchmark? http://blogs.zdnet.com/BTL/?p=3434 26 Monday, February 16, 2009

Slide 27

Slide 27 text

Integration • Newer deployed systems for additional purposes • More efficient to retool old systems to integrate with new 27 Monday, February 16, 2009

Slide 28

Slide 28 text

Acquisition • Your company is acquired by another with different technology infrastructure • Not likely in Government situation 28 Monday, February 16, 2009

Slide 29

Slide 29 text

Forced to • Management Decision • e.g. "No new nett Oracle licenses" • New government initiative ? 29 Monday, February 16, 2009

Slide 30

Slide 30 text

Physical Resources • Newer languages being taught • Desire to update skills • New staff acquisition • Off shoring / Outsourcing options 30 Monday, February 16, 2009

Slide 31

Slide 31 text

Open Source - Gardner • By 2012, 80% of all commercial software will include elements of open-source technology. • By 2012, at least one-third of business application software spending will be as service subscription instead of as product license. • By 2011, early technology adopters will forgo capital expenditures and instead purchase 40 per cent of their IT infrastructure as a service. http://gartner.com/it/page.jsp?id=593207 31 Monday, February 16, 2009

Slide 32

Slide 32 text

Open Source • Sun releases Java • Microsoft releases .Net components • Adobe release Flex/Flash infrastructure • MySQL, the 'M' of LAMP • Be wary of different licensing agreements for software reuse 32 Monday, February 16, 2009

Slide 33

Slide 33 text

Road blocks 33 Monday, February 16, 2009

Slide 34

Slide 34 text

Barriers to success • Resource commitment • Set expectations • e.g. it works in Oracle it should work in MySQL • It may be cheaper to migrate but it takes a long time • Fear of change • Licensing/IP/Patents/Copyright 34 Monday, February 16, 2009

Slide 35

Slide 35 text

Actual Client Example • Management directs use of MySQL • Technical resources • Refuse to use optimal numeric datatypes (could be 25% disk saving) • Refuse to use covering indexes (improved performance in queries) • Fudge production simulation (3 full table scans in 15 sample SELECT's) • Place junior inexperienced staff (in company and technology) on evaluation process 35 Monday, February 16, 2009

Slide 36

Slide 36 text

Summary • MySQL can operate in the enterprise • There are justifiable reasons to consider MySQL • Migration to MySQL is possible • Opportunities, Technology and Time to Market becoming more viable 36 Monday, February 16, 2009