asked on

does this project can be done on mysql

Hi all,
I need your help as proffessionals in that :
I got thoes requirement from the system analyst
- estimated number of concurrent users per second on the web application is 5 million user
- estimated number of records per database is 40 million record
- record size is 20 kilo byte
I'm responsible for technical specification but I'm newbie
- does mysql can take that huge ammount of data and that huge number of users per second
if so how about the stability and security and performance and speed in that case is it good enough or it 'll be poor???
best Regards
HG

ASKER CERTIFIED SOLUTION

todd_farmer

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

shang3000

ASKER

hi todd_farmer,
thanks for reply
>>> You will likely need to scale out across multiple machines using replication >>>(read-only queries going to replication slaves, writes going to masters) or >>>shard your data across multiple machines.
does you mean making a load balance cluster? does it's supported on mysql?

>>>but any project where you are expecting the types of volume you describe >>>should have a well-considered and scalable architecture. Definitely look into >>>caching at multiple layers.
please explain what you means by scalable architechter and caching at multiple layers?

giltjr

Please refer to:

https://www.experts-exchange.com/questions/22716696/does-this-project-can-be-done-on-apache.html
https://www.experts-exchange.com/questions/22716697/does-this-project-can-be-done-on-linux-fedora.html

for more information. This is really a duplicate.