Hi,
Pierre COLOMBIER wrote:
> I've got a 10GB database.
>
If not too many VARCHAR columns this should work on a pair of 16 GB nodes.
> mean traffic is
> input : 80MB / hour
> output : 70MB / hour
Can't translate that
>
> admin commands : 2M / hour
> changedb : 800K / hour
> select : 2M / hour
> update : 1.2M / hour
> insert : 700K / hour
>
~2000 queries a second which is quite doable for simple queries on a small cluster
but a select statement can take anything from a part of a milliseconds to a very long time
so it is hard to say more without more details of what queries actually are processed.
>
> theses are mean values.
> multiply by 5 to obtain peak values.
>
10000 queries top is rather likely to require some processing resources.
You will probably need a few MySQL Servers to handle the query processing load and
probably at least 4 data nodes for the storage part.
> can mysql-cluster handle this kind of databases.
> with how much nodes ?
> what kind of hardware ?
Most likely 64-bit machines given the data size and the speed requirements (64-bits ==
modern machine == fast machine).
Rgrds Mikael
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com