scalability

I built a website in PHP/MySQL which is a kind of social network. Obviously, everywhere on the site I display the triple (Picture,Name,Location). In…

I think this is a simple question: I'm just new to php and can't really figure this out in an efficient way. What I want to do is for each friend,…

Designing an object store for ~10B objects and using mySQL for storing metadata. We know we need to shard and are looking for general heuristics to…

What are the problems, if any, of storing binary data in Riak? Does it effect the maintainability and performance of the clustering? What would the…

I want to start using load balancers, database replication and sharding, cloud computing. I know I can follow many tutorials, that's no problem, but…

The Map-Reduce programming model stems from the map and reduce functions which are present in functional languages like Lisp and Scheme dating back…

Let's assume that it was only writes. Each "document" inserted is less than 140 characters. How many writes can this database handle?

Hi Guys, Here is the problem I am facing with. We are having a postfix server that needs to parse emails forwarded from some user's account and…

More than half of the hits on one of my servers are from the Google Bot, constantly crawling our millions of pages. The reason we have so many pages…

I built a Rails app which originally only needed to support one site, and it runs quite fast. Now I added the ability to run multiple sites on the…

Say, I have a big database globalclients which is very very big. Now, I divide this big database to 100 sub-databases, as: chinaclients japanclients…

I am working on a project where i have to save list of friends.After thinking a lot and searching on net best way to do it seems saving user id and…

I usually set all my varchars to 255 to be safe. Does it make any difference in terms of the disk space or anything else? Is there any downside to…

I have a table like this CREATE TABLE IF NOT EXISTS `billing_success` ( `bill_id` int(11) NOT NULL AUTO_INCREMENT, `msisdn` char(10) NOT NULL,…

I have a table in which approx 100,000 rows are added every day. I am supposed to generate reports from this table. I am using PHP to generate these…

Hi, Consider the following hypothetical scenario: A Web application receives 25% write traffic and 75% read traffic. Given that this application can…

Hi, Our app would be creating dynamics forms for each users. We are considering two approaches a) We store all users forms data in single table as…

The usual case. I have a simple app that will allow people to upload photos and follow other people. As a result, every user will have something…

I'm looking to implement a database that can be widely distributed geographically and such that each node can be read/write with eventual…

Hi all, I am working on the high-level design of a web application with the following characteristics: Millions of records Heavily…