Thread: Setting up a query server

a company i'm working has asked me design query based website. need allow member registrations , return query strings based on ?query=search+term

know basic php concepts should no problem in , of itself. problem arises when bring in advanced hosting problems , circumstances. such fact @ given time, need perform around 500 - 1000 query searches every minute (it's communication company , queries make connections). in words of employer "i want can compete skype." bandwidth actual communications has been taken care of, requirements queries little shaky @ moment. need website allows users register username, password, address, payment information, nickname, , serial number site. site when addressed http://url.com/?query=username return single string containing serial number. tell person calling direct routing number person receiving call (it's weird concept). every call, text, file, video, whatnot, server queried. it's type of dns idea.

problems:
- best setup server this?
- how backup database keep going bad?
- best server use? @ current, budget limited thing need query servers. else has been taken care of. thought stringing few raspberry pis (256mb ram arm processors, they're $35) external usb harddrives.

this sort of thing lamp made :
webserver (apache), database read performance (mysql) , web-friendly scripting language (php) on linux box.

rest simple matter of creating database , writing php , relevant queries, preferably in secure manner.

performancewise, don't think 15 requests/queries per second much. make sure, can test setting simpliest configuration work, , running awful lot of wget statements against see how copes.

otoh, think i'd looking @ cheap server rather handful of raspberry pis. external usb drives sounds scary.
think hp proliant microserver - it's marketed "server hardware stuff used put on dedicated pc".

, if you're entire business gonna depend on availability of system, might want two.

Forum The Ubuntu Forum Community Ubuntu Specialised Support Ubuntu Servers, Cloud and Juju Server Platforms [other] Setting up a query server

Ubuntu