Axel Schwenke ¼g¹D¡G

> "howa" <howachen@gmail.com> wrote:
> > for example, MySQL replication is not suitable for scable application
> > which need many writes, e.g. a popular forum
> >
> > ao are there any recommendation in this suitation?
>
> InnoDB on big hardware (lots of memory and fast disks).
> If that does not work out (unlikely) - MySQL Cluster.
>
>
> XL
> --
> Axel Schwenke, Senior Software Developer, MySQL AB
>
> Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
> MySQL User Forums: http://forums.mysql.com/

thanks for your reply first, i have two questions:

1. Did MySQL has some benchmark that could give a general picture on
the performance of MySQl, such as on a dual processor 3Ghz Xeon, 4GB
memory, 15k RPM HD setup, it can handle xxx write/read transeactions
per second?

2. Is Cluster the last option? What would be the drawback if both
InnoDB & Cluster work for me, but I chose to use Cluster besides it
will be difficult to setup?

thanks again.