Nice article about SimCity outage and ways to defend
databases: http://www.mysqlperformanceblog.com/2013/03/16/simcity-outages-traffic-control-and-thread-pool-for-mysql/
The graphs showing throughput with and without the thread pool
are taken from the benchmark performed by Oracle and taken from
here:
http://www.mysql.com/products/enterprise/scalability.html
The main take away is this graph (all rights reserved to Oracle,
picture original URL):
Scalability is where throughput can grow and grow, as demand
grows. I need to get more from the database, the question …
One of the main responsibilities of any database administrator is to keep a close eye on how database performance is impacting size and storage. Decisions will have to be made on whether or not to make changes within the database structure or application itself, or to make the changes on the storage and resource side [...] Read More
A default installation of MySQL is easy to perform, but if you really want your databases to sing, you should tune them like you would tune a piano. In MySQL tuning pertains to either the application or the database system. In this post, we cover some common tuning techniques and best practices to increase your [...] Read More
Come Find the Answer Launching a next-gen app? You need a next-gen database. But figuring out which one is no walk-in-the-park. Tune in next Tuesday to a webinar where Matt Aslett, research manager for data management and analytics at 451 Research, Doron Levari, ScaleBase’s CTO, and I will discuss:
The increasingly complex and ever-changing database market The benefits and [...] Read More
I just came across this: "Scaling Pinterest and adventures in
database sharding" (http://gigaom.com/data/scaling-pinterest-and-adventures-in-database-sharding/)
"Pinterest has learned about scaling the way most popular sites
do — the architecture works until one day it doesn’t"Pinterest
found out that "the architecture" is not scalable and they turned
to development of a Scale Out mechanism also called
Sharding.
I find it amazing that sharding, or in other words, the idea of
"scale out by splitting and parallelizing data across
shared-nothing commodity-hardware" is not supplied "out of the
box" by "the architecture" (such as database, load-balancer, any
other IT stuff). I'm wondering who was the one that
decided that an IT issue like scale-out should
be outsourced from the database to the …
Oh I love these things: http://techcrunch.com/2012/08/22/how-big-is-facebooks-data-2-5-billion-pieces-of-content-and-500-terabytes-ingested-every-day/
Every day there are 2.5B content items shares, and 2.7B "Like"s.
I care less about GiGo content itself, but metadata, connections,
relations are kept transactionally in a relational database. The
above 2 use-cases generate 5.2B transactions on the database, and
since there are only 86400 seconds a day, we get over 60000 write
transactions per second on the database, from these 2 use-cases
alone, not to mention all other use-cases, such as new profiles,
emails, queries...
And what's the size of new data, on top of all the existing …
On the 8/16 I conducted a webinar titled: "Scale Up vs. Scale
Out" (http://www.slideshare.net/ScaleBase/scalebase-webinar-816-scaleup-vs-scaleout):
ScaleBase Webinar 8.16: ScaleUp vs.
ScaleOut from ScaleBase
The webinar was successful, we had many attendees and
great participation in questions and
answers throughout the session and in the
end. Only after the webinar it only occurred to me
that one specific graphic was missing from the webinar deck. It
was occurred to me after answering
several audience questions about "the difference
between …
MySQL database management tool ScaleBase virtualizes MySQL database, spreading database load into smaller bite-size chunks As an open source company, Mozilla developers make a lot of different versions of software code each day, and part of Sheeri Cabral’s job to keep track of them all: which ones work, which don’t, how many times they’ve been downloaded, and which have a [...] Read More
Tuesday, September 18, 2012, 6:30pm – 8:00pm
Cambridge Innovation Center, 1 Broadway, Cambridge, MA (map) http://www.meetup.com/boston-java/events/75357012/ Doron Levari Doron will be speaking at the Java Meetup. Doron is a long-time veteran of the database industry and the publisher of the Database Scalability Blog, has extensive experience in building and scaling-out database systems as well as the organizations and infrastructure necessary to support them. Please find a [...] Read More
Earlier this week we all read GigaOM's article with this title:
"Why the days are numbered for Hadoop as we know it"I know GigaOM
like to provoke scandals sometimes, we all remember some other
unforgettable piece, but there is something behind
it...
Hadoop today (after SOA not so long ago) is one of the worst case
of an abused buzzword ever known to men. It's everything,
everywhere, can cure illnesses and do "big-data" at the same
time! Wow! Actually Hadoop is a software framework that
supports data-intensive distributed applications, derived from
Google's MapReduce and Google File System (GFS) papers.
My take from the article is this: Hadoop is a foundation,
low-level platform. I used the word …