What Android devices are you targeting? I’d investigate the resource consumption (memory, mostly) of the options you’re considering and make sure they’re appropriate for your target devices. A NoSQL solution that gobbles up 500K or more of memory for code+stack+heap will not be happy on a device with 1GB of memory. (I’m just pulling numbers out of the air; I don’t know the footprint of HyperDex, MongoDB or Cassandra are. MySQL in its embedded form is about 500K for code.)
Are you concerned about high number concurrent users on a single device? Seems contrary to the Android market (mobile devices). MySQL can handle a lot of concurrent users, but it’s not a NoSQL solution and wouldn’t scale in the context of a massive multiplayer game, which is what I /think/ you’re contemplating (i.e. a bunch of players, each with their own Android device, playing a game together).
That helps. For that scenario, MySQL should work fine. You could migrate to MySQL Cluster if a single instance started to sag under the load (but then your architecture becomes substantially more complex).
Think about using a connection pool instead of a one-to-one mapping of player-to-MySQL-user. The players probably only need intermittent access to the database, not a persistent connection, so one MySQL connection could serve N players. The value of N will be a function of the definition of “intermittent”, and the size of the connection pool can grow/shrink dynamically with the demand.
Also, data associated with gaming tends to be structured, not unstructured (NoSQL is a better fit for unstructured data), which is another factor in favor of MySQL.
Don't you mean 10000 concurrent users? There is seldom need for 10000 concurrent connections.
Perhaps if you were running 10000 independent server processes, but that is unlikely, and not what one ought to design for from start.
What you need to consider when selecting database layer is, at least: writes/sec, reads/sec, types of access (indexes, ordered collections, joins, searching), consistency, availability, persistence.
What kind of profile, in those terms, do you foresee?
//Martin
--
You received this message because you are subscribed to the Google Groups "NOSQL" group.
To post to this group, send email to nosql-di...@googlegroups.com.
To unsubscribe from this group, send email to nosql-discussi...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/nosql-discussion?hl=en.
El 01/05/12 15:07, Konstantin Osipov escribió:
I propose DB4O. It work in Android and is really fast.
* Joe Stein<cryp...@gmail.com> [12/05/01 21:15]:
my glib response was going to be+1
If you think your choices are limited to just those two NoSQL systems, then
you should choose MySQL
--
You received this message because you are subscribed to the Google Groups "NOSQL" group.
To post to this group, send email to nosql-discussion@googlegroups.com.
To unsubscribe from this group, send email to nosql-discussion+unsubscribe@googlegroups.com.
>>> > To post to this group, send email to nosql-discussion@googlegroups.com.
>>> > To unsubscribe from this group, send email to
>>> > For more options, visit this group at
>>> > http://groups.google.com/group/nosql-discussion?hl=en.
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "NOSQL" group.
>>> To post to this group, send email to nosql-discussion@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> For more options, visit this group at
>>> http://groups.google.com/group/nosql-discussion?hl=en.
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> /*
>>> Joe Stein
>>> http://www.linkedin.com/in/charmalloc
>>> Twitter: @allthingshadoop
>>> */
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "NOSQL" group.
>>> To post to this group, send email to nosql-discussion@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> For more options, visit this group at
>>> http://groups.google.com/group/nosql-discussion?hl=en.
>>>
>>>
>>>
>>>
>>>
>>> --
>>> Regards,
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "NOSQL" group.
>>> To post to this group, send email to nosql-discussion@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> For more options, visit this group at
>>> http://groups.google.com/group/nosql-discussion?hl=en.
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "NOSQL" group.
>>> To post to this group, send email to nosql-discussion@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> For more options, visit this group at
>>> http://groups.google.com/group/nosql-discussion?hl=en.
>>>
>>>
>>>
>>>
>>>
>>> --
>>> Regards,
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "NOSQL" group.
>>> To post to this group, send email to nosql-discussion@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> For more options, visit this group at
>>> http://groups.google.com/group/nosql-discussion?hl=en.
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "NOSQL" group.
>>> To post to this group, send email to nosql-discussion@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> For more options, visit this group at
>>> http://groups.google.com/group/nosql-discussion?hl=en.
>>
>>
>>
>>
>> --
>> Regards,
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "NOSQL" group.
>> To post to this group, send email to nosql-discussion@googlegroups.com.
>> To unsubscribe from this group, send email to
>> For more options, visit this group at
>> http://groups.google.com/group/nosql-discussion?hl=en.
>
>
>
>
> --
>
> /*
> Joe Stein
> http://www.linkedin.com/in/charmalloc
> Twitter: @allthingshadoop
> */
>
> --
> You received this message because you are subscribed to the Google Groups
> "NOSQL" group.
> To post to this group, send email to nosql-discussion@googlegroups.com.
> To unsubscribe from this group, send email to
> For more options, visit this group at
> http://groups.google.com/group/nosql-discussion?hl=en.
--
You received this message because you are subscribed to the Google Groups "NOSQL" group.
To post to this group, send email to nosql-discussion@googlegroups.com.
To unsubscribe from this group, send email to nosql-discussion+unsubscribe@googlegroups.com.
--
Regards,