high_scalability high_scalability-2008 high_scalability-2008-231 knowledge-graph by maker-knowledge-mining

231 high scalability-2008-01-29-Too many databases


meta infos for this blog

Source: html

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?


Summary: the most important sentenses genereted by tfidf model

sentIndex sentText sentNum sentScore

1 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). [sent-1, score-1.188]

2 Each clients website has a database with about 50 tables each, all the databases are small in size about 2-5 MB . [sent-7, score-1.23]

3 and the websites are low traffic websites with say. [sent-11, score-0.788]

4 Wanted to know if it is possible to have so many databases about 500 on the same server? [sent-26, score-0.552]

5 what are the things that i should look into if i should make this happen? [sent-27, score-0.216]


similar blogs computed by tfidf model

tfidf for this blog:

wordName wordTfidf (topN-words)

[('avg', 0.348), ('clients', 0.335), ('vps', 0.291), ('drupal', 0.288), ('websites', 0.281), ('mb', 0.265), ('website', 0.232), ('possible', 0.21), ('databases', 0.21), ('tables', 0.172), ('dedicated', 0.162), ('host', 0.161), ('maybe', 0.161), ('happen', 0.16), ('hit', 0.154), ('thinking', 0.152), ('size', 0.13), ('queries', 0.124), ('server', 0.119), ('low', 0.116), ('traffic', 0.11), ('means', 0.102), ('small', 0.096), ('things', 0.087), ('per', 0.076), ('know', 0.075), ('look', 0.074), ('many', 0.057), ('make', 0.055), ('database', 0.055), ('using', 0.042)]

similar blogs list:

simIndex simValue blogId blogTitle

same-blog 1 1.0 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?

2 0.29700974 169 high scalability-2007-12-01-many website, one setup, many databases

Introduction: Hi, I will need to host abound 500-1000 websites, all of them use drupal, What I thought was, to make all of these websites point to a single setup of drupal and make them run from there. I thought of using different databases for each website.. Do you think it'll work? Is there a better way to go about it?

3 0.22569369 724 high scalability-2009-10-19-Drupal's Scalability Makeover - You give up some control and you get back scalability

Introduction: Drupal 7 is having a scalability makeover. Karoly Negyesi, Drupal Core Developer and Public Development Team Lead, explains the process in this video: Drupal 7 APIs, scalability mindset . Karoly states the general theme of the changes as: You give up some control and you get back scalability . An interesting comment on the politics of scalability? Makeover may not be quite the right word though. A makeover implies a cosmetic change, looking better by changing the surface. Drupal's changes will go deeper than that, right to Drupal's core. It's a genuine and authentic change that will hopefully allow one of the Internet's most venerable Content Management Systems (CMSs) to compete with a constant stream of younger and sexier models. Drupal is based on an older LAMP stack approach where PHP modules are scooped up and merged together each time a request is made to Drupal. Drupal's most intriguing idea is how it is built, expands, and changes by weaving together a single system out

4 0.21828926 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?

5 0.14453857 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.

6 0.13496959 312 high scalability-2008-04-30-Rather small site architecture.

7 0.12468608 836 high scalability-2010-06-04-Strategy: Cache Larger Chunks - Cache Hit Rate is a Bad Indicator

8 0.12345552 399 high scalability-2008-10-01-Joyent - Cloud Computing Built on Accelerators

9 0.11418772 714 high scalability-2009-10-02-HighScalability has Moved to Squarespace.com!

10 0.11173188 121 high scalability-2007-10-14-Newbie in scalability design issues

11 0.1099343 598 high scalability-2009-05-12-P2P server technology?

12 0.10984879 95 high scalability-2007-09-17-Scalable CMS?

13 0.10730509 195 high scalability-2007-12-28-Amazon's EC2: Pay as You Grow Could Cut Your Costs in Half

14 0.10618278 209 high scalability-2008-01-12-Gandi.net, french registrar launches in granular server resources.

15 0.10507357 167 high scalability-2007-11-27-Starting a website from scratch - what technologies should I use?

16 0.10116175 699 high scalability-2009-09-10-How to handle so many socket connection

17 0.09860383 1 high scalability-2007-07-06-Start Here

18 0.092079788 146 high scalability-2007-11-08-scaling drupal - an open-source infrastructure for high-traffic drupal sites

19 0.091976933 626 high scalability-2009-06-10-Paper: Graph Databases and the Future of Large-Scale Knowledge Management

20 0.090195686 222 high scalability-2008-01-25-Application Database and DAL Architecture


similar blogs computed by lsi model

lsi for this blog:

topicId topicWeight

[(0, 0.12), (1, 0.049), (2, -0.047), (3, -0.095), (4, 0.001), (5, -0.007), (6, -0.014), (7, -0.025), (8, 0.011), (9, 0.008), (10, -0.021), (11, -0.023), (12, -0.033), (13, 0.036), (14, 0.091), (15, -0.051), (16, -0.005), (17, 0.03), (18, -0.01), (19, 0.009), (20, -0.015), (21, -0.023), (22, -0.032), (23, -0.022), (24, 0.034), (25, -0.056), (26, 0.042), (27, -0.022), (28, 0.025), (29, -0.073), (30, -0.014), (31, 0.033), (32, 0.027), (33, 0.074), (34, -0.003), (35, 0.096), (36, 0.082), (37, 0.037), (38, -0.06), (39, 0.03), (40, 0.051), (41, -0.018), (42, 0.07), (43, -0.04), (44, -0.094), (45, 0.044), (46, -0.082), (47, 0.006), (48, -0.055), (49, 0.017)]

similar blogs list:

simIndex simValue blogId blogTitle

same-blog 1 0.95725513 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?

2 0.69399017 169 high scalability-2007-12-01-many website, one setup, many databases

Introduction: Hi, I will need to host abound 500-1000 websites, all of them use drupal, What I thought was, to make all of these websites point to a single setup of drupal and make them run from there. I thought of using different databases for each website.. Do you think it'll work? Is there a better way to go about it?

3 0.65791661 146 high scalability-2007-11-08-scaling drupal - an open-source infrastructure for high-traffic drupal sites

Introduction: the authors of drupal have paid considerable attention to performance and scalability. consequently even a default install running on modest hardware can easily handle the demands a small website. if you are lucky, eventually the time comes when you need to service more users than your system can handle. at some point, you'll start looking at your hardware and network deployment. read more .

4 0.65433919 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?

5 0.65406263 206 high scalability-2008-01-10-MONO ASP.NET. Will it make the web???

Introduction: I was wondering if it is already possible to scale a MONO's .NET website. I cannot see any real websites (with the term real I mean "a highly visited website") running mono. What do you think? Will MONO ASP.NET scale??? Is it worth planning a site to run with Mono asp.net? Or should we leave it to the future? What do you think?

6 0.64466912 95 high scalability-2007-09-17-Scalable CMS?

7 0.63901633 724 high scalability-2009-10-19-Drupal's Scalability Makeover - You give up some control and you get back scalability

8 0.61948562 222 high scalability-2008-01-25-Application Database and DAL Architecture

9 0.61124545 312 high scalability-2008-04-30-Rather small site architecture.

10 0.60231841 1288 high scalability-2012-07-23-Ask HighScalability: How Do I Build My MegaUpload + Itunes + YouTube Startup?

11 0.59409517 167 high scalability-2007-11-27-Starting a website from scratch - what technologies should I use?

12 0.58971459 714 high scalability-2009-10-02-HighScalability has Moved to Squarespace.com!

13 0.58667493 277 high scalability-2008-03-16-Do you have any questions for the Elastra CEO?

14 0.5857873 379 high scalability-2008-09-04-Database question for upcoming project

15 0.58089292 256 high scalability-2008-02-21-Tracking usage of public resources - throttling accesses per hour

16 0.57373255 611 high scalability-2009-05-31-Need help on Site loading & database optimization - URGENT

17 0.57144177 276 high scalability-2008-03-15-New Website Design Considerations

18 0.56901824 675 high scalability-2009-08-08-1dbase vs. many and cloud hosting vs. dedicated server(s)?

19 0.56220782 488 high scalability-2009-01-08-file synchronization solutions

20 0.55651706 1 high scalability-2007-07-06-Start Here


similar blogs computed by lda model

lda for this blog:

topicId topicWeight

[(1, 0.273), (2, 0.231), (45, 0.127), (61, 0.105), (79, 0.103)]

similar blogs list:

simIndex simValue blogId blogTitle

1 0.95446271 1354 high scalability-2012-11-05-Are we seeing the renaissance of enterprises in the cloud?

Introduction: A series of recent surveys on the subject seems to indicate that this is indeed the case: Research conducted by HP found that the majority of businesses in the EMEA region are planning to move their mission-critical apps to the cloud. Of the 940 respondents, 80 percent revealed plans to move mission-critical apps at some point over the next two to five years. A more recent survey, by research firm MeriTalk and sponsored by VMware and EMC (NYSE: EMC ), showed that one-third of respondents say they plan to move some mission-critical applications to the cloud in the next year. Within two years, the IT managers said they will move 26 percent of their mission-critical apps to the cloud, and in five years, they expect 44 percent of their mission-critical apps to run in the cloud. The Challenge - How to Bring Hundreds of Enterprise Apps to the Cloud The reality is that cloud economics only start making sense when there are true workloads that utilize the cloud inf

2 0.95338267 260 high scalability-2008-02-25-Architecture Template Advice Needed

Introduction: Here's my template for describing the architecture of a system. The idea is to have people fill out this template and that then becomes the basis for a profile. This is how the Friends for Sale post was created and I think that turned out well. People always want more detail, but realistically you can only expect so much. The template is definitely too long, but it's more just a series of questions to jog people's memories and then they can answer whatever they think is important. What I want to ask is if you can think of any things to add/delete/change in the template? What do you want to know about the systems people are building? So if you have the time, please take a look and tell me what you think. Getting to Know You * What is the name of your system and where can we find out more about it? * What is your system is for? * Why did you decide to build this system? * How is your project financed? * What is your revenue model? * How do you market y

3 0.95338184 259 high scalability-2008-02-25-Any Suggestions for the Architecture Template?

Introduction: Here's my template for describing the architecture of a system. The idea is to have people fill out this template and that then becomes the basis for a profile. This is how the Friends for Sale post was created and I think that turned out well. People always want more detail, but realistically you can only expect so much. The template is definitely too long, but it's more just a series of questions to jog people's memories and then they can answer whatever they think is important. What I want to ask is if you can think of any things to add/delete/change in the template? What do you want to know about the systems people are building? So if you have the time, please take a look and tell me what you think. Getting to Know You * What is the name of your system and where can we find out more about it? * What is your system is for? * Why did you decide to build this system? * How is your project financed? * What is your revenue model? * How do you market you

same-blog 4 0.9521001 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.9466666 1099 high scalability-2011-08-16-The 5 Biggest Ways to Boost MySQL Scalability

Introduction: Sean Hall with some really good  MySQL advice :  Tune those queries . Biggest bang for your buck. Enable the slow query log and watch it. Once you've found a heavy resource intensive query, optimize it! Tune what receives real-world traffic.  Employ Master-Master Replication . Immediately have a read-only slave for your application to hit as well. Use Your Memory . Set innodb_buffer_pool_size, key_buffer_size and other key options. RAID Your Disk I/O . Use RAID 10 mirroring and striping. On EC2 striping across a number of EBS volumes using the Linux md software raid. Tune Key Parameters . speeds up inserts & updates with innodb_flush_log_at_trx_commit=2; create a tablespace and underlying datafile for each table with innodb_file_per_table. Full details at the original article .

6 0.94095516 70 high scalability-2007-08-22-How many machines do you need to run your site?

7 0.9408704 1 high scalability-2007-07-06-Start Here

8 0.93913549 382 high scalability-2008-09-09-Content Delivery Networks (CDN) – a comprehensive list of providers

9 0.93778175 983 high scalability-2011-02-02-Piccolo - Building Distributed Programs that are 11x Faster than Hadoop

10 0.93768281 727 high scalability-2009-10-25-Is Your Data Really Secured?

11 0.93755656 560 high scalability-2009-04-08-Learned lessons from the largest player (Flickr, YouTube, Google, etc)

12 0.93489015 623 high scalability-2009-06-10-Dealing with multi-partition transactions in a distributed KV solution

13 0.93388832 819 high scalability-2010-04-30-Hot Scalability Links for April 30, 2010

14 0.93346792 841 high scalability-2010-06-14-How scalable could be a cPanel Hosting service?

15 0.93270791 1309 high scalability-2012-08-22-Cloud Deployment: It’s All About Cloud Automation

16 0.9321577 1517 high scalability-2013-09-16-The Hidden DNS Tax - Cascading Timeouts and Errors

17 0.93192679 1096 high scalability-2011-08-10-LevelDB - Fast and Lightweight Key-Value Database From the Authors of MapReduce and BigTable

18 0.93135178 395 high scalability-2008-09-25-Is your cloud as scalable as you think it is?

19 0.93109268 691 high scalability-2009-08-31-Squarespace Architecture - A Grid Handles Hundreds of Millions of Requests a Month

20 0.93020189 1288 high scalability-2012-07-23-Ask HighScalability: How Do I Build My MegaUpload + Itunes + YouTube Startup?