DZone
Database Zone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone > Database Zone > I Deleted My MySQL Database

I Deleted My MySQL Database

It's good to clean up your database and migrate to a new solution, even if you're still with the same provider. It helps shed unnecessary databases, tables, and costs.

Kin Lane user avatar by
Kin Lane
·
Jul. 11, 17 · Database Zone · Opinion
Like (3)
Save
Tweet
3.80K Views

Join the DZone community and get the full member experience.

Join For Free

I just deleted my primary MySQL database. Of course, I backed up everything, but it is the first time since 2011 I’ve cleaned up my entire database backend to the point where I could delete the entire instance (with confidence). I was motivated to do this mostly because I couldn’t downsize the AWS RDS instance to a smaller instance due to a variety of constraints. The situation gave me the opportunity to clean house and to rethink my next moves.

Image title

Instead of setting up a new MySQL instance, I went with the new MySQL compatible Amazon Aurora. I set up a smaller instance that was more affordable, and I was able to easily import the database backups I had made in my previous setup, but now I had a cleaner, more modern Amazon Aurora situation that, as Amazon claims “provides up to five times better performance than MySQL with the security, availability, and reliability of a commercial database at one-tenth the cost.” Time will tell…

I like cleaning up my database and migrating to a new solution, even if the solution is still with the same provider. It helps me think through things and shed unnecessary databases, tables, and hopefully costs. Everywhere that I’ve worked and within all of the businesses I have owned, the database is always the hardest thing to manage and migrate. I want that to be a thing of the past. Now that I have things cleaned up, I’m going to keep my databases small and modular and use standardized solutions that top-tier providers support. This means I can migrate my data wherever I need to, and wherever it makes sense to my business.

Another thing that has also allowed me to migrate my data in this way is that I have offloaded a significant portion of the data I manage, which drives my public research to Google Sheets. This approach helps me simplify and modularize my data, again using a common tool (spreadsheet/CSV) in a way that I can easily collaborate with others and publish to Jekyll and GitHub using YAML. This shift in my world is all about helping me reduce the bulk on the backend of my business and making sure I spread out my business data, content, and algorithms across a variety of solutions, while making sure all the services I use have APIs that allow me to automate, orchestrate, and (of course) migrate my data whenever I need to.

Database MySQL

Published at DZone with permission of Kin Lane, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • The Ultimate Software Engineering Job Search Guide
  • GraphQL in Enterprise: What It Takes to Build, Deploy, and Monitor a New Enterprise GraphQL Service
  • Why Blockchain Technology Is the Future of Data Storage
  • Testing Strategies for Microservices

Comments

Database Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo