Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 20 10 Older Entries

Displaying posts with tag: database scalability (reset)

MySQL thread pool and scalability examples
+2 Vote Up -0Vote Down
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 (http://www.mysql.com/products/enterprise/scalability.html)

The main take away is this graph (all rights reserved to Oracle, picture original URL (http://www.mysql.com/common/images/enterprise/MySQL_Threadpool_Benchmark_RW.png" target="_blank)):

Scalability is






  [Read more...]
Top Two Signs your MySQL Database is Maxing Out
+0 Vote Up -0Vote Down
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
How to Tune a MySQL Application Like a Piano
+1 Vote Up -0Vote Down
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
Setting Shakespeare Straight. NoSQL, NewSQL or MySQL: THAT is the Question.
+0 Vote Up -0Vote Down
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
Being successful like Pinterest without its DB adventures...
+1 Vote Up -0Vote Down
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


  [Read more...]
Facebook makes big data look... big!
+1 Vote Up -0Vote Down
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



  [Read more...]
Scale Up, Partitioning, Scale Out
+1 Vote Up -0Vote Down
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



  [Read more...]
NetworkWorld: How Mozilla keeps its MySQL database tidy
+1 Vote Up -0Vote Down
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
The Boston Java Meetup – Java & Mysql: Scaling is everything! | September 18, 2012, 6:30pm – 8:00pm
+1 Vote Up -0Vote Down
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
So now Hadoop's days are numbered?
+3 Vote Up -0Vote Down
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




  [Read more...]
Showing entries 1 to 10 of 20 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.