Tagged Questions
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.
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 ...
8
votes
9answers
921 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
406 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 ...
