high_scalability high_scalability-2008 high_scalability-2008-252 knowledge-graph by maker-knowledge-mining
Source: html
Introduction: Have a few doubts.. here are the qs 1) is there any limit on the number of databases that can be accessed simultaneously? (MySQL) 2) will it be a problem to scale in the future if there are large number of small databases(2-5 MB) each?
sentIndex sentText sentNum sentScore
1 here are the qs 1) is there any limit on the number of databases that can be accessed simultaneously? [sent-3, score-1.336]
2 (MySQL) 2) will it be a problem to scale in the future if there are large number of small databases(2-5 MB) each? [sent-4, score-1.049]
wordName wordTfidf (topN-words)
[('mb', 0.469), ('simultaneously', 0.422), ('databases', 0.37), ('accessed', 0.356), ('limit', 0.319), ('number', 0.291), ('future', 0.215), ('mysql', 0.173), ('small', 0.17), ('problem', 0.14), ('large', 0.122), ('scale', 0.111)]
simIndex simValue blogId blogTitle
same-blog 1 0.99999994 252 high scalability-2008-02-18-limit on the number of databases open
Introduction: Have a few doubts.. here are the qs 1) is there any limit on the number of databases that can be accessed simultaneously? (MySQL) 2) will it be a problem to scale in the future if there are large number of small databases(2-5 MB) each?
2 0.34523293 43 high scalability-2007-07-30-Product: ImageShack
Introduction: ImageShack offers free, unlimited storage with a 100 MB per hour bandwidth limit for each image.
3 0.21961914 44 high scalability-2007-07-30-Product: Photobucket
Introduction: Photobucket's free account has a storage limit and a download bandwidth limit of 10 GB per month. There's no bandwidth limit on the $25 Pro account.
4 0.21828926 231 high scalability-2008-01-29-Too many databases
Introduction: Hi, I am using drupal for my clients website, and was thinking is it possible to host all ( about 500) of them on the same server(maybe VPS or dedicated). Here is the situation..... Each clients website has a database with about 50 tables each, all the databases are small in size about 2-5 MB .... and the websites are low traffic websites with say.. 50 hits/day on avg.... that means about 2000 queries/db/day ..... (avg 40 queries per hit).... Wanted to know if it is possible to have so many databases about 500 on the same server? what are the things that i should look into if i should make this happen?
5 0.16421838 340 high scalability-2008-06-06-Economies of Non-Scale
Introduction: Scalability forces us to think differently. What worked on a small scale doesn't always work on a large scale -- and costs are no different. If 90% of our application is free of contention, and only 10% is spent on a shared resources, we will need to grow our compute resources by a factor of 100 to scale by a factor of 10! Another important thing to note is that 10x, in this case, is the limit of our ability to scale, even if more resources are added. 1. The cost of non-linearly scalable applications grows exponentially with the demand for more scale. 2. Non-linearly scalable applications have an absolute limit of scalability. According to Amdhal's Law, with 10% contention, the maximum scaling limit is 10. With 40% contention, our maximum scaling limit is 2.5 - no matter how many hardware resources we will throw at the problem. This post discuss in further details how to measure the true cost of non linearly scalable systems and suggest a model for reducing that cost signifi
6 0.14024153 256 high scalability-2008-02-21-Tracking usage of public resources - throttling accesses per hour
7 0.12779689 626 high scalability-2009-06-10-Paper: Graph Databases and the Future of Large-Scale Knowledge Management
8 0.10922255 196 high scalability-2007-12-30-MySQL clustering strategies and comparisions
9 0.10072762 978 high scalability-2011-01-26-Google Pro Tip: Use Back-of-the-envelope-calculations to Choose the Best Design
10 0.099853881 5 high scalability-2007-07-10-mixi.jp Architecture
11 0.099784203 911 high scalability-2010-09-30-More Troubles with Caching
12 0.097001478 1413 high scalability-2013-02-27-42 Monster Problems that Attack as Loads Increase
13 0.094776899 18 high scalability-2007-07-16-Paper: MySQL Scale-Out by application partitioning
14 0.093288586 721 high scalability-2009-10-13-Why are Facebook, Digg, and Twitter so hard to scale?
15 0.088252887 699 high scalability-2009-09-10-How to handle so many socket connection
16 0.087848559 729 high scalability-2009-10-28-And the winner is: MySQL or Memcached or Tokyo Tyrant?
17 0.087634824 671 high scalability-2009-08-05-Stack Overflow Architecture
18 0.084773645 1640 high scalability-2014-04-30-10 Tips for Optimizing NGINX and PHP-fpm for High Traffic Sites
19 0.083460785 1288 high scalability-2012-07-23-Ask HighScalability: How Do I Build My MegaUpload + Itunes + YouTube Startup?
20 0.083383836 514 high scalability-2009-02-18-Numbers Everyone Should Know
topicId topicWeight
[(0, 0.081), (1, 0.047), (2, -0.019), (3, -0.04), (4, 0.015), (5, 0.082), (6, -0.038), (7, -0.027), (8, 0.006), (9, -0.033), (10, 0.011), (11, -0.035), (12, 0.018), (13, 0.079), (14, 0.08), (15, -0.013), (16, -0.037), (17, 0.037), (18, 0.007), (19, 0.05), (20, -0.002), (21, 0.012), (22, -0.048), (23, -0.043), (24, 0.067), (25, 0.035), (26, 0.031), (27, -0.016), (28, 0.113), (29, -0.094), (30, 0.022), (31, 0.009), (32, 0.064), (33, 0.096), (34, -0.033), (35, 0.046), (36, 0.058), (37, 0.023), (38, 0.037), (39, -0.013), (40, 0.057), (41, -0.024), (42, 0.021), (43, -0.026), (44, -0.054), (45, 0.032), (46, -0.085), (47, 0.02), (48, -0.019), (49, 0.021)]
simIndex simValue blogId blogTitle
same-blog 1 0.98073888 252 high scalability-2008-02-18-limit on the number of databases open
Introduction: Have a few doubts.. here are the qs 1) is there any limit on the number of databases that can be accessed simultaneously? (MySQL) 2) will it be a problem to scale in the future if there are large number of small databases(2-5 MB) each?
2 0.66624796 231 high scalability-2008-01-29-Too many databases
Introduction: Hi, I am using drupal for my clients website, and was thinking is it possible to host all ( about 500) of them on the same server(maybe VPS or dedicated). Here is the situation..... Each clients website has a database with about 50 tables each, all the databases are small in size about 2-5 MB .... and the websites are low traffic websites with say.. 50 hits/day on avg.... that means about 2000 queries/db/day ..... (avg 40 queries per hit).... Wanted to know if it is possible to have so many databases about 500 on the same server? what are the things that i should look into if i should make this happen?
3 0.61828738 995 high scalability-2011-02-24-Strategy: Eliminate Unnecessary SQL
Introduction: MySQL Expert Ronald Bradford explains how one key way to improve the scalability of a MySQL server, and undoubtedly nearly every other server, is to eliminate unnecessary SQL , saying the most efficient way to improve an SQL statement is to eliminate it : The MySQL kernel can only physically process a certain number of SQL statements for a given time period (e.g. per second). Regardless of the type of machine you have, there is a physical limit. If you eliminate SQL statements that are unwarranted and unnecessary, you automatically enable more important SQL statements to run. There are numerous other downstream affects, however this is the simple math. To run more SQL, reduce the number of SQL you need to run. Ronald shows how to use mk-query-digest to look at query execution times and determine which ones can be profitably whacked. Related Articles Quora: What are the best methods for optimizing PHP/MySQL code for speed without caching?
4 0.61189133 340 high scalability-2008-06-06-Economies of Non-Scale
Introduction: Scalability forces us to think differently. What worked on a small scale doesn't always work on a large scale -- and costs are no different. If 90% of our application is free of contention, and only 10% is spent on a shared resources, we will need to grow our compute resources by a factor of 100 to scale by a factor of 10! Another important thing to note is that 10x, in this case, is the limit of our ability to scale, even if more resources are added. 1. The cost of non-linearly scalable applications grows exponentially with the demand for more scale. 2. Non-linearly scalable applications have an absolute limit of scalability. According to Amdhal's Law, with 10% contention, the maximum scaling limit is 10. With 40% contention, our maximum scaling limit is 2.5 - no matter how many hardware resources we will throw at the problem. This post discuss in further details how to measure the true cost of non linearly scalable systems and suggest a model for reducing that cost signifi
5 0.60288888 62 high scalability-2007-08-08-Partial String Matching
Introduction: Is there any alternative to LIKE '%...%' OR LIKE '%...%' in MySQL if you have to offer partial string matching on a large dataset?
6 0.58739132 455 high scalability-2008-12-01-MySQL Database Scale-out and Replication for High Growth Businesses
7 0.5856759 44 high scalability-2007-07-30-Product: Photobucket
8 0.5783003 16 high scalability-2007-07-16-Book: High Performance MySQL
9 0.56967157 770 high scalability-2010-02-03-NoSQL Means Never Having to Store Blobs Again
10 0.55660003 303 high scalability-2008-04-18-Scaling Mania at MySQL Conference 2008
11 0.55341548 196 high scalability-2007-12-30-MySQL clustering strategies and comparisions
12 0.55290675 222 high scalability-2008-01-25-Application Database and DAL Architecture
13 0.55260271 43 high scalability-2007-07-30-Product: ImageShack
14 0.54910886 465 high scalability-2008-12-14-Scaling MySQL on a 256-way T5440 server using Solaris ZFS and Java 1.7
15 0.54519123 1065 high scalability-2011-06-21-Running TPC-C on MySQL-RDS
17 0.54056996 86 high scalability-2007-09-09-Clustering Solution
18 0.53614366 504 high scalability-2009-01-29-Event: MySQL Conference & Expo 2009
19 0.53356731 17 high scalability-2007-07-16-Paper: Guide to Cost-effective Database Scale-Out using MySQL
20 0.53314859 729 high scalability-2009-10-28-And the winner is: MySQL or Memcached or Tokyo Tyrant?
topicId topicWeight
[(2, 0.37), (99, 0.394)]
simIndex simValue blogId blogTitle
1 0.90635896 1128 high scalability-2011-09-30-Gone Fishin'
Introduction: Well, not exactly Fishin', I'll be on vacation starting today and I'll be back in mid October. I won't be posting, so we'll all have a break. Disappointing, I know. If you've ever wanted to write an article for HighScalability, this would be a great time :-) I especially need help on writing Stuff the Internet Says on Scalability as I won't even be reading the Interwebs. Shock! Horror! So if the spirit moves you, please write something. My connectivity in South Africa is unknown, but I will check in and approve articles when I can. See you on down the road...
2 0.85531175 1350 high scalability-2012-10-29-Gone Fishin' Two
Introduction: Well, not exactly Fishin', I'll be on vacation starting today and I'll be back late November. I won't be posting anything new, so we'll all have a break. Disappointing, I know, but fear not, I will be posting some oldies for your re-enjoyment. And If you've ever wanted to write an article for HighScalability, this would be a great time :-) I especially need help on writing Stuff the Internet Says on Scalability as I will be reading the Interwebs on a much reduced schedule. Shock! Horror! Â So if the spirit moves you, please write something. My connectivity in Italy will probably be good, so I will check in and approve articles on a regular basis. Ciao...
3 0.73235321 120 high scalability-2007-10-11-How Flickr Handles Moving You to Another Shard
Introduction: Colin Charles has cool picture showing Flickr's message telling him they'll need about 15 minutes to move his 11,500 images to another shard. One, that's a lot of pictures! Two, it just goes to show you don't have to make this stuff complicated. Sure, it might be nice if their infrastructure could auto-balance shards with no down time and no loss of performance, but do you really need to go to all the extra complexity? The manual system works and though Colin would probably like his service to have been up, I am sure his day will still be a pleasant one.
4 0.72625023 374 high scalability-2008-08-30-Paper: GargantuanComputing—GRIDs and P2P
Introduction: I found the discussion of the available bandwidth of tree vs higher dimensional virtual networks topologies quite, to quote Spock, fascinating : A mathematical analysis by Ritter (2002) (one of the original developers of Napster) presented a detailed numerical argument demonstrating that the Gnutella network could not scale to the capacity of its competitor, the Napster network. Essentially, that model showed that the Gnutella network is severely bandwidth-limited long before the P2P population reaches a million peers. In each of these previous studies, the conclusions have overlooked the intrinsic bandwidth limits of the underlying topology in the Gnutella network: a Cayley tree (Rains and Sloane 1999) (see Sect. 9.4 for the definition). Trees are known to have lower aggregate bandwidth than higher dimensional topologies, e.g., hypercubes and hypertori. Studies of interconnection topologies in the literature have tended to focus on hardware implementations (see, e.g., Culler et
5 0.72584844 1653 high scalability-2014-05-23-Gone Fishin' 2014
Introduction: Well, not exactly Fishin', but I'll be on a month long vacation starting today. I won't be posting new content, so we'll all have a break. Disappointing, I know. If you've ever wanted to write an article for HighScalability this would be a great time :-) I'd be very interested in your experiences with containers vs VMs if you have some thoughts on the subject. So if the spirit moves you, please write something. See you on down the road...
6 0.72023749 907 high scalability-2010-09-23-Working With Large Data Sets
7 0.71982682 478 high scalability-2008-12-29-Paper: Spamalytics: An Empirical Analysisof Spam Marketing Conversion
8 0.69367957 1301 high scalability-2012-08-08-3 Tips and Tools for Creating Reliable Billion Page View Web Services
9 0.68383116 56 high scalability-2007-08-03-Running Hadoop MapReduce on Amazon EC2 and Amazon S3
10 0.68383116 565 high scalability-2009-04-13-Benchmark for keeping data in browser in AJAX projects
11 0.68359989 1367 high scalability-2012-12-05-5 Ways to Make Cloud Failure Not an Option
12 0.68349069 436 high scalability-2008-11-02-Strategy: How to Manage Sessions Using Memcached
13 0.68305552 223 high scalability-2008-01-25-Google: Introduction to Distributed System Design
14 0.68076491 836 high scalability-2010-06-04-Strategy: Cache Larger Chunks - Cache Hit Rate is a Bad Indicator
15 0.68061256 878 high scalability-2010-08-12-Strategy: Terminate SSL Connections in Hardware and Reduce Server Count by 40%
16 0.67995751 911 high scalability-2010-09-30-More Troubles with Caching
17 0.67533016 594 high scalability-2009-05-08-Eight Best Practices for Building Scalable Systems
18 0.67469037 455 high scalability-2008-12-01-MySQL Database Scale-out and Replication for High Growth Businesses
19 0.66881716 205 high scalability-2008-01-10-Letting Clients Know What's Changed: Push Me or Pull Me?
20 0.66834527 1155 high scalability-2011-12-12-Netflix: Developing, Deploying, and Supporting Software According to the Way of the Cloud