Migrating Between Proprietary and Open Source Database Technologies - Calculating Your ROI

Wednesday 2:55 PM - 3:55 PM

@ Hill Country D

Open Source Databases

50 minutes conference

Beginner

Tracks:
Migration

Modern relational databases are all tied together by a well-defined standard for SQL, the latest version published in 2016. But not all SQL implementations follow the standard and even when they do, they often embellish on it and users tend to use the features they see available to them. As a result, migration between databases tends to be a challenging task. In this talk I will give some examples of database migrations I have participated in over the last twenty years and what issues we ran into with each. I will also talk in a more general sense about:
• Database only migration vs application refactoring - which is likely to have the better ROI?
• Analysis tools to help perform migration like Amazon's DMS, SQLines and DBconvert
• Database agnostic replication
• What it means to get support in the Open Source world and how to get it.


Speakers

John Schulz

John Schulz (The Pythian Group)

Principal Consultant

Biography:

John has 40+ of years' experience working with data. Data in files and in Databases from flat files through ISAM to relational databases and most recently NoSQL. For the last 15 he's worked on a variety of Open source technologies including MySQL, PostgreSQL, Cassandra, MongoDB, Hadoop and Hbase. As a Chief Database Architect at AOL he brought MySQL in to replace Sybase and has worked hands on with MySQL databases holding hundreds of billions of rows and running millions of transactions per second. For the last 4+ years he has been working for The Pythian Group to help their customers improve their existing databases and select new ones for new applications.


Connect with Percona

Stay Connected on:

Percona Live 2019 starts in:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA