On Sunday 28 June 2009, jitendra wrote: > Last year, 2008, the fyjc admission was made online using FOSS. > The software is available for any one for asking. > I was the architect on behalf of the government. > I was instrumental in turning the decision of autorites from not going in > for online to going in for online this year. > That is when my contribution ended. > > Last year we used the latest MySQL (5.0) when our engineers had not enough > experience( was that a sensible decision ? I feel yes as it was essentially > a pilot) . It took two days to locate MySQL expert who was familiar with > settings ( Courtesy Dainik Bhaskar) and the dying server revived in 10 > minutes.
Afaik MySQL has poor write capability under heavy load. Postgres would be a better alternative. However without adequate infrastructure (HA, LB, DR etc) such projects should never be attempted. The typical govt tendency to cut corners only brings a bad name to FOSS and the developer. -- Rgds JTD -- http://mm.glug-bom.org/mailman/listinfo/linuxers
