January 23, 2007
Can MySQL scale?
Making the rounds of cyberspace is a report by MediaTemple, a hosting company, on how it believes it will solve its difficulties with grid-based MySQL hosting.
Takeaways include:
- MySQL has real issues with handling diverse, high-volume workloads.
- When MySQL gets overloaded, database corruption is routine.
- Some people write really, really bad MySQL web applications.
With the possible exception of #2, I doubt any of this surprises anybody.
Comments
6 Responses to “Can MySQL scale?”
Leave a Reply
Search our blogs and white papers
Monash Research blogs
- DBMS 2 covers database management, analytics, and related technologies.
- Text Technologies covers text mining, search, and social software.
- Strategic Messaging analyzes marketing and messaging strategy.
- The Monash Report examines technology and public policy issues.
- Software Memories recounts the history of the software industry.
User consulting
Building a short list? Refining your strategic plan? We can help.
Vendor advisory
We tell vendors what's happening -- and, more important, what they should do about it.
Monash Research highlights
Learn about white papers, webcasts, and blog highlights, by RSS or email. |
-
Recent posts
-
Categories
- About this blog
- Analytic glossary
- Analytic technologies
- Application areas
- Buying processes
- Companies and products
- 1010data
- Ab Initio Software
- Actian and Ingres
- Aerospike
- Akiban
- Aleri and Coral8
- Algebraix
- Alpha Five
- Amazon and its cloud
- ANTs Software
- Aster Data
- Ayasdi
- Basho and Riak
- Business Objects
- Calpont
- Cassandra
- Cast Iron Systems
- Cirro
- Citus Data
- ClearStory Data
- Cloudant
- Cloudera
- Clustrix
- Cogito and 7 Degrees
- Cognos
- Continuent
- Couchbase
- CouchDB
- Databricks, Spark and BDAS
- DATAllegro
- Datameer
- DataStax
- Dataupia
- dbShards and CodeFutures
- Elastra
- EMC
- Endeca
- EnterpriseDB and Postgres Plus
- Exasol
- Expressor
- FileMaker
- GenieDB
- Gooddata
- Greenplum
- Groovy Corporation
- Hadapt
- Hadoop
- HBase
- Hortonworks
- HP and Neoview
- IBM and DB2
- illuminate Solutions
- Infobright
- Informatica
- Information Builders
- Inforsense
- Intel
- Intersystems and Cache'
- Jaspersoft
- Kafka and Confluent
- Kalido
- Kaminario
- Kickfire
- Kognitio
- KXEN
- MapR
- MarkLogic
- McObject
- memcached
- MemSQL
- Metamarkets and Druid
- Microsoft and SQL*Server
- MicroStrategy
- MonetDB
- MongoDB
- MySQL
- Neo Technology and Neo4j
- Netezza
- NuoDB
- Nutonian
- Objectivity and Infinite Graph
- Oracle
- Oracle TimesTen
- ParAccel
- Pentaho
- Pervasive Software
- PivotLink
- Platfora
- PostgreSQL
- Progress, Apama, and DataDirect
- QlikTech and QlikView
- Rainstor
- Revolution Analytics
- Rocana
- salesforce.com
- SAND Technology
- SAP AG
- SAS Institute
- ScaleBase
- ScaleDB
- Schooner Information Technology
- SciDB
- SenSage
- SequoiaDB
- SnapLogic
- Software AG
- solidDB
- Splunk
- Starcounter
- StreamBase
- Sybase
- Syncsort
- Tableau Software
- Talend
- Teradata
- Tokutek and TokuDB
- Truviso
- VectorWise
- Vertica Systems
- VoltDB and H-Store
- WibiData
- Workday
- Xkoto
- XtremeData
- Yarcdata and Cray
- Zettaset
- Zoomdata
- Data integration and middleware
- Data types
- DBMS product categories
- Emulation, transparency, portability
- Fun stuff
- Market share and customer counts
- Memory-centric data management
- Michael Stonebraker
- Parallelization
- Presentations
- Pricing
- Public policy
- Software as a Service (SaaS)
- Specific users
- Storage
- Theory and architecture
- TransRelational
- Uncategorized
-
Date archives
-
Links
-
Admin
That’s not news for anyone who studied opensource database systems.
MySQL default setup is not even ACID compliant.
You could try MySQL w/InnoDB (it’s at least ACID), but it still lacks some basic functionality, like triggers. And please don’t tell me that MySQL has triggers. They’re severely limited.
If you want a full-featured, solid opensource RDBMS, get PostgreSQL. Really.
If you don’t need broad datatype support, Ingres may be the best of the bunch.
Actually, I wouldn’t be shocked if they fixed datatype extensibility as well. They had the guts of that technology in the product over a decade ago.
Curt, my thoughts exactly. PgSQL isn’t the only alternative out there. There’s also Firebird, but I haven’t tried it myself.
[…] MySQL told Computer Business Review they’re thinking strongly of an IPO this year, but also wouldn’t mind waiting. Frankly, I think they shouldn’t come public until they can prove solid acceptance of Version 5, because Version 4 remains in too many ways an embarrassment. […]
It appears that they may be in the habit of copying MyISAM tables around for load balancing, presumably while the shared server is still running, to avoid interfering with other customers. That almost guarantees index corruption if the table is in active write use. That shouldn’t surprise anyone.
High volume workloads aren’t a problem for MySQL. I doubt that that is all the story behind the applications/customers they have found troublesome. Shared hosting almost inevitably means resource over-allocation and pricing below the real cost needed for high demand users, particularly those with inefficient applications. We don’t know enough about their troublesome customers to know what the problems really were.
InnoDB – the transactional engine anyone serious about uptime and reliability would be wanting to use – can’t be copied while the server is live and isn’t prone to the MyISAM corruption risk you get when doing that live copying. It’s also less likely to suffer it in general use, though that’s fortunately not commonly encountered by MyISAM either.
Filip, InnoDB is the default engine for Windows, MyISAM for Linux, so the non-ACID default isn’t true for around half of all installations.
James Day, Support Engineer, MySQL AB, first DBA, Wikipedia.
[…] Curt Monash of DBMS2’s blog points to a paper analyzing MySQL hosting on a grid. One observation: “Some people write really, really bad MySQL web applications.” […]