Transitioning From SQL Server to MySQL: Lessons Learned Along The Way
What if you were asked to support a database platform that you had never worked with before? First you would probably say no, but after you lost that fight, then what? That is exactly how I came to support MySQL. Over the last year my team has worked to learn MySQL, architect a production environment, and figure out how to support it alongside our other platforms (Microsoft SQL Server and Oracle). Along the way, I have also come to appreciate the unique offering of this platform and see it as an important part of our environment going forward. To make things even more challenging, our first MySQL databases were the backend for a critical, web based application that needed to be highly available across multiple data centers. This meant that we did not have the luxury of standing up a simpler environment to start with and building confidence there. Our final architecture ended up using a five node Percona XtraDB Cluster spread across three data centers. This session will focus on lessons learned along the way, as well as challenges related to supporting more than one database platforms. It should be interesting to anyone who is new to MySQL, anyone who is being asked to support more than one database platform, or anyone who wants to see how an outsider views the platform. Supporting multiple platforms is only possible through lots of automation, documentation, and monitoring. I will touch on all of these topics as well as some of the challenges we faced along the way, such as: • A shift in mindset to understanding and becoming comfortable with the open source model • Learning a new platform from scratch • Shifting from Windows to a Linux OS (half of the team had little or very outdated Linux experience) • Architecture - With so many options and being new to the platform, this was one of the hardest decisions. • Monitoring - Not just how to monitor MySQL, but how to do so in a way that minimizes the number of tools needed across our entire environment. • Team learning - We have seven DBA's and they all learn in different ways. Figuring out how to bring everyone along and keep them engaged was challenging.
Senior Database Administrator, SAS Institute
I am a Senior Database Administrator for SAS Institute supporting SQL Server and, as of recently, MySQL. I started my IT journey as a web developer building small e-commerce websites with a heavy reliance on databases, but soon discovered that my real passion was the databases themselves. Most of my DBA career has been spent supporting a large SQL Server environment consisting of almost 2000 databases spread out over 100 instances. I have architected and supported nearly every flavor and combination of high availability within SQL Server. Over the last year about half of my time has been devoted to MySQL. I am a remote employee working out of a home office in Portland, Oregon.