?
Solved

Is MySQL 5.1 stable?

Posted on 2007-04-03
3
Medium Priority
?
616 Views
Last Modified: 2012-06-21
Hello,

Is mysql 5.1 stable enough for a large application. I need to use it's partitioning funcionality.

Thank you!
0
Comment
Question by:ditkis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 30

Expert Comment

by:todd_farmer
ID: 18847211
Well, it's still in beta.  Obviously, MySQL would like it to be GA, so there are outstanding bugs that are preventing it from getting there.  MERGE tables are an alternative in 4.1 or 5.0, although those also have a number of issues that can cause problems if you aren't careful.
0
 

Author Comment

by:ditkis
ID: 18847893
As I understand, MERGE wokrs only with MyISAM, we need some solution for InnoDB. Do you know of anything that can help us split very large table (handreds of millions of rows)  into several ones?
0
 
LVL 30

Accepted Solution

by:
todd_farmer earned 1500 total points
ID: 18847904
Outside of partitioning, no.  You can, of course, do application-level partitioning (say, A-D in tableA, E-J in tableE, etc.) - but that can be quite a change at the application layer.

I'd take a real good look at all of the open bugs (at http://bugs.mysql.com) related to partitioning before deciding to implement 5.1 in it's current beta state for this feature.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question