DZone
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
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones AWS Cloud
by AWS Developer Relations
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones
AWS Cloud
by AWS Developer Relations

Trending

  • Automated Multi-Repo IBM App Connect Enterprise BAR Builds
  • What Is End-To-End Testing? E2E Testing Tutorial With Examples and Best Practices
  • Apache Cassandra With Java: Introduction to UDT
  • Write a Smart Contract With ChatGPT, MetaMask, Infura, and Truffle
  1. DZone
  2. Data Engineering
  3. Databases
  4. You’ve Outgrown Your MySQL Database, Now What?

You’ve Outgrown Your MySQL Database, Now What?

MySQL is a great database for starting out. But eventually, if things go well, you'll have to consider alternatives, like the cloud or other technologies. Here's some advice.

Joanna Witkowski user avatar by
Joanna Witkowski
·
Nov. 21, 16 · Tutorial
Like (1)
Save
Tweet
Share
5.33K Views

Join the DZone community and get the full member experience.

Join For Free

MySQL has always been a great database option for companies in their infancy. It’s cheap and contains the basic functionality most organizations need. It is the simplest way to provide access to multiple databases for multiple users looking to sift through basic company structured data.

Of course, as companies hit the big time and see incredible growth in the number of concurrent transactions on their websites, they suddenly find that their affordable MySQL solution can’t handle this volume reliably—at least not without some complex, expensive and risky technical workarounds.

In the past, when companies were ready for a state-of-the-art relational database management system (RDBMS) they found that proprietary solutions from vendors like Oracle, IBM and Informix were their only choices. These big-box vendors were the only ones that could handle the large read-write workloads seen by then-emerging titans like PayPal and eBay. Consequently, this also meant financial prudence was not an option as customers were (and still are) then saddled with DBMS agreements that are too expensive and technologically cumbersome to break.

Newcomers Have New and Better Choices (That Older Companies Didn’t Have)

Existing (largely on-premise) Oracle customers will likely never be able to untangle themselves from Larry Ellison’s clutches — they made decisions that they probably had to make, given the lack of viable options that were available at the time.

Emerging e-commerce, ad tech, gaming and other financial-transaction-heavy companies, on the other hand, have choices today that can help them steer clear of that sticky web. And if the strategies of companies such as Rakuten, MakeMyTrip, and Twoo.com are any indication, this new generation of “born-in-the-cloud” companies is choosing a different path (which no doubt accounts for Oracle’s focus on selling existing customers on the Oracle Cloud). As we wrote in a recent article, it is a good time to grow up as an organization.

What would be on an emerging e- and social-commerce leader’s database wish list?

  • Contractual flexibility. Customers should be able to opt out at any time without penalty and easily extricate themselves technologically.
  • Pay only for what you need. Next-generation e-commerce, social commerce, gaming and ad tech stalwarts can now enjoy pay-as-you-go models and “flex” up and down to pay only for the database capacity they need. (By contrast, a portion of Oracle’s cloud customers are using less than 20 percent of what they paid for.)
  • Perform in either the cloud or data center. Ironically, Oracle is seeing more and more use cases for which it isn’t a fit because it doesn’t run in AWS, Azure, Google or other leading clouds.
  • The same high performance. Duh! Just because you don’t go with a big-box vendor doesn’t mean you should expect anything less than seamless processing of 40 million or more simultaneous read and write transactions.
  • Compatibility. Utilize the same MySQL tools with which your IT staff is already familiar.

MySQL may be a reasonable selection for startups and small businesses. But once a company realizes its most ambitious visions and begins to execute on its loftiest goals, they’ll find that they can now swap in next-generation RDBMSs that won’t force them to sacrifice flexibility and cost for performance.

Database Relational database MySQL

Published at DZone with permission of Joanna Witkowski. See the original article here.

Opinions expressed by DZone contributors are their own.

Trending

  • Automated Multi-Repo IBM App Connect Enterprise BAR Builds
  • What Is End-To-End Testing? E2E Testing Tutorial With Examples and Best Practices
  • Apache Cassandra With Java: Introduction to UDT
  • Write a Smart Contract With ChatGPT, MetaMask, Infura, and Truffle

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • 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

Let's be friends: