Find the answer to your Linux question:
Results 1 to 2 of 2
Ok, I am putting together a proposal for my local school system. Students are required to complete a request numbers of Student Service Learning (SSL... irritating i know) hours before ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Guru kkubasik's Avatar
    Join Date
    Mar 2004
    Location
    Lat: 39:03:51N Lon: 77:14:37W
    Posts
    2,396

    Scalability in Database Driven Sites - Performance


    Ok, I am putting together a proposal for my local school system. Students are required to complete a request numbers of Student Service Learning (SSL... irritating i know) hours before graduation, a pretty common system. Currently this entire massive system is managed via carbon copies of forms filled out and filed by hand....

    the system houses some 150,000 students

    so I proposed creating an online form linked to a database, a pretty simple task, a one page submission, which then sends an e-mail to the supervisor of the service asking for confirmation. Follow the link, digital signature, 'you must be who you say you are etc etc' and badda-bing-badda-boom.

    The first thought was the obvious php/apache/mysql, I started mapping out the site and designing the database. Quickly I realized that while the throughput on any normal day will remain in the reasonable zone, the last day before all submissions are due, the system will face thousands of simultaneous sessions. Which is basically going to require load balancing to some degree, especially because this would be tested on older hardware before migration to high end servers.

    I then looked into Tomcat/Jakarta which seems to be the most viable option (but I may be biased because of my strong background in Java) linked to a mysql server. It looks feasible, but Java is not known for performance in the application world. While a cgi in something like C might be good with the resources, this need to be something maintained. And the admins handling it don't want C.

    In short, what free web technology and database pair will scale the best to something of this size? Has anyone worked on something of a similar scale and know where performance pitfalls will occur? In general.. any advice on how to tackle this?
    Avoid the Gates of Hell. Use Linux
    A Penny for your Thoughts

    Formerly Known as qub333

  2. #2
    Linux Guru kkubasik's Avatar
    Join Date
    Mar 2004
    Location
    Lat: 39:03:51N Lon: 77:14:37W
    Posts
    2,396
    *bump*

    I'm not looking for much, more does anyone have experiances with php handling over a thousand simultanious connections?
    Avoid the Gates of Hell. Use Linux
    A Penny for your Thoughts

    Formerly Known as qub333

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •