The scaling tag has no wiki summary.
0
votes
0answers
61 views
What is advantages and disadvantages in Horizontal Scaling and Vertical Scaling? [closed]
one of the excellence in nosql is Vertical Scaling but i want to know What is advantages and disadvantages in Horizontal Scaling and Vertical Scaling?
2
votes
1answer
187 views
How much data is needed to show MySQL Cluster's performance scaling vs. InnoDB
I am evaluating MySQL Cluster as a possible replacement for an InnoDB schema. So far, I have tested it with 10s of MB of data, and found MySQL Cluster slower than InnoDB; however, I have been told ...
1
vote
1answer
166 views
Experience using ScaleArc in test or production?
Has anyone had any experience using ScaleArc?
My CTO has asked my thoughts on it, and I have seen no information out there regarding real-world experiences.
-2
votes
1answer
182 views
when to use technology like hadoop?
I understand that MySQL and others support large enough data for storing and retrieving. I am also aware of the open source projects such as hadoop and mapreduce etc.. (only their purpose and what ...
4
votes
4answers
297 views
How to scale my SQL Server 2008?
My DB is SQL Server 2008 and I want to scale up the system by 5 fold (maybe more in the future).
The system currently has 95% read & 5% write from front end. And from backend actual data is bulk ...
4
votes
3answers
3k views
Why can't relational databases meet the scales of Big Data?
It is often repeated that the Big Data problem is that relational databases can not scale to process the massive volumes of data that are now being created.
But what are these scalability limitations ...
4
votes
3answers
632 views
MySQL tables/databases into different disks
I am aware that there is a possibility to have a single database server with many tables/databases, and you can separate some of those tables/databases into separate disks.
Lets say you have 5 ...
7
votes
3answers
179 views
Using Replication for Scale-Out
Having read Using Replication for Scale-Out, how can I route different queries to different servers, for example, SELECTI want to route to slaves and NON-SELECT to master. I assume as loadbalancer I ...
1
vote
2answers
435 views
MySQL Sharding tables/servers or other methods to reduce table sizes?
I'm currently working with a table exceeding 12 million rows (at about 3 GB when exported with mysqldump) and am curious how huge a table can realistically get without any serious performance impact. ...
1
vote
1answer
137 views
What is a better way to keep “user online”?
I'm working on software for social network and I plan it to scale a lot. Actually, I'm updating timestamp column every time user clicks, to be sure they're marked as online. When they do not click for ...
3
votes
4answers
752 views
Is it feasible to have MySQL in-memory storage engine utilize 512 GB of RAM?
I am considering scaling up instead of scaling out. Therefore, I am interested to hear whether it is feasible to utilize the MySQL in-memory storage engine for a database that is 500+ GB, given that ...
4
votes
2answers
895 views
Estimate average and median efficiently in Postgres?
I have a Postgres database with tables in the billion scale. So any aggregate functions such as count() and avg(), as well as "order by random()" are very time consuming. Postgres has pg_catalog which ...
8
votes
9answers
923 views
Which DBMS are fast enough for an online game (few thousand players)?
I'm currently making an MMORPG game, which could have a few thousand players online at the same time (probably not; just wishful thinking). First we wanted to use MySQL, but I have heard it isn't fast ...
5
votes
3answers
407 views
What are the sharding heuristics for MySQL - number of records per table & number of tables per instance?
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 scale. Would appreciate pointers and hear about the ...
0
votes
3answers
162 views
What database platform better at scaling? [closed]
I am planning a for a database that i expect will be very big in terms of number of records rather than tables and batabases. My Question is what product (i.e, SQL 2008, Cassandra, Azure) handles ...
