I've been working on MySQL database in simple web applications for a long time and i now have a project which should maintain about 1,000 up to 10,000 query per minute (it is some logging database system) and a lot of theme are Insert statement.
First thing worried me is i don't think MySQL could handle that much query per second,I know i should buy stronger Server but i don't know if MySQL can be good solution for that.Is there any way to calculate that ability before buying servers?
Second important thing is that the database will grow too fast and it will be use all server resources like hard disk or CPU usage sooner or later and i should have an expanding solution,my question in this part from experienced database admins is :
"Is MySQL suitable for distributing or cluster databases ?"
"Is there any easy to use database which support clustering and distributing systems?" (I know MySQL have a cluster version but i don't know if it is appropriate in my project).
The project is about logging users(by their RF-ID tags) as they pass throw the antenna range or rf-id readers or Electronic gates and read their permission to enter or leave the area which specified in database for that tag ID, and record there activity in database.The operator should access all these data and be able to manipulate theme.
I know there are very professional servers with large capacity of hard disk like SAN or NAS(Network-attached storage),but as it is not national or very big company project i need easy to distribute database to distribute it over normal servers.