I ran into a problem last week moving from dev-testing where one of my quieries which had run perfectly in dev, was crawling on my testing server. It was fixed by adding FORCE INDEX on one of the indexes in the query. Now i've loaded the same database into the production server (and it's running with the FORCE INDEX command, and it has...
I would like to run several virtual hosts via nginx, each serving a different django app via fcgi. Is this possible? If so, does anyone have good resources on where/how to start? The nginx docs seem to be mostly examples, but none of the particular config I'm attempting... ...
I'm having the following problem: Our users are using Macs running Mac OS Leopard to connect to an Xserve running Tiger Server (Version 10.4.11) via AFP. On the Xserve, I created a user group called "staff" (using Directory Admin) and put some user accounts into that group. Then I made the group "staff" owner of the folder I want them...
The game is a low graphic (SVG) strategic game. Each server represents a Game Domain with its players. All servers should be able to talk to each other, as players can move (in the game) from domain to domain/send "diplomatic messengers" etc.. We have chosen this idea as it enables us to enlarge the world map endlessly, it enables secon...
Hi My application needs to send thousands of emails on a daily basis. So I thought about writing my own smtp server, using C#, which would pull a database every minute to see if there are any pending email messages. But, then I came across Microsoft's IIS SMTP service.... My question : Can the IIS SMTP service handle that amount of...
The company I work with currently has 10 windows boxes running various in house scripts, however occasionally one goes down and no one notices for periods of up to 24 hours because the data that is manufactured is only gathered on weekly intervals. Does anyone know of a management system that will notify when a box goes down and possibl...
Our development team has just recently started using virtual machines to develop on and one issue we are having is keeping the clocks sync'd. I remember in the past there was an issue with ntpd not working on virtual machines. I also recall it not being a good idea to put ntpdate in as a cron. So my question is, is there another solution...
I am in the process of trying to graphically represent all of our server racks. So when we receive a new server we can decide where this should be put and where a specific servers currently resides. Are there any existing software packages that stores this kind of data already? I'd prefer open source ones if there are any but anything w...
I need my server to stay connected to the server. Does anyone know how to do this? Or post links tutorials anything? Also it says when it restarts 'could not accept client' so how would I clear everything and make it accept it? ...
I want to push data to the browser over HTTP without killing my django/python application. I decided to use a comet server, to proxy requests between my application and the client (though I still haven't really figured it out properly). I've looked into the following engines: orbited cometd ejabberd jetty Has anyone had any experience...
The code #!/usr/bin/env python import MySQLdb print "Content-Type: text/html" print print "<html><head><title>Books</title></head>" print "<body>" print "<h1>Books</h1>" print "<ul>" connection = MySQLdb.connect(user='me', passwd='letmein', db='my_db') cursor = connection.cursor() cursor.execute(“SELECT name FROM books ORDER BY pub...
Hi, I'm looking for a way to password protect a directory in IIS. I'm aware that the standard answer to this is to create a windows user account for this directory, then give that user read permissions on the directory... but my concern is that by creating a windows user, won't that give them permissions to do stuff like login to the com...
Can anyone point me to a good primer on how a large scale commercial website like amazon.com is set up? Most importantly, I'd like to know about how the databases are set up. Do they have a distributed set of databases to balance the load, that all sends updates to one 'master' database, etc.? Doesn't have to be the inside dope(although ...
I just switched to start using a CDN for external images/static files for my site and I wanted to know how I could build a backup in case this CDN failed. Is there a way to reference an external link in an HTML/JavaScript file that would let you specify a fallback location for that file if it is unavailable in the first external host? ...
I want to run a cron job that does cleanup that takes a lot of CPU and Mysql resources. I want it to run only if the server is not relatively busy. What is the simplest way to determine that from PHP? (for example, is there a query that returns how many queries were done in the last minute? ...) ...
In a currently deployed web server, what are the typical limits on its performance? I believe a meaningful answer would be one of 100, 1,000, 10,000, 100,000 or 1,000,000 requests/second, but which is true today? Which was true 5 years ago? Which might we expect in 5 years? (ie, how do trends in bandwidth, disk performance, CPU perform...
Currently I'm using jQuery on my asp.net content page (using master). I am creating a modal dialog using jquery. The div that is defined with the following code <div id="example" class="flora" title="Information" style="display:none; visibility:hidden; text-align:left;"> <asp:Panel ID="Panel" runat="server"> Is the...
I am going to install Debian on our new dedicated server and I have a chance to set up hard drive partitions. The server has two 750GB drives configured as RAID 1. We are going to have 10 Postgresql databases, where each database will be about 2 GB. There will be of course Apache/PHP on this server too. We'll use the server for only ou...
I am working on a project that will involve file upload to a server. I am interested in understanding what kinds of files virus writers currently tend to target. I am aware of the following threads: How would you programmatically test a file for viruses ? ensuring uploaded files are safe How can I determine a file’s true extension/type ...
Duplicate: http://stackoverflow.com/questions/15208/whats-the-best-linux-backup-solution I am about to purchase a dedicated linux server that has 160GB hard disk and will be used primarily for website hosting. The server doesn't come with backup/restore facilities and wondered if anyone knows how / what is the best (and cheapest)...