Python Client Server

I need a multithreaded client/server for linux. The server will check a mysql database for files that clients need to download. The clients will connect with username and password. Once the client is connected the server will update a MySQL table showing that the client is connected. If the connection is lost. The server will also update this table to show disconnected. The server will check a mysql table every minute for files to send out. If there is a file to send. The server will send the command to the client. The client will then preform a wget, and download the file. Once the file is downloaded on the client side. The client will tell the server, and the server will mark that file as completed in the mysql database. Then then client will also run a local command for that file. Server. 1. Clients connect to server with username and password. Located on the `clients` table. 2. Clients table is updated as clients connect or disconnect to server. If client is connected. The `connected` row in clients is updated to a 1; if they are disconnected then a 0. 3. Checks `outbox` MySQL table every 60 seconds for unsent files. If file download command needs to be sent to client there is a 0 in the `sent` row. 4. Sends command to client to download file. 5. Once file is downloaded client sends message to server letting it know the file is downloaded, and the server updates the `sent` row in the `outbox` to a 1. 6. Check to see if the clients are connected for accurate list of connected clients. (“possibly with a ping?”) 7. Must be able to handle hundreds of connections. Client 1. Connects to server with username and password. 2. Receives download file command from server. 3. Performs a wget to download file. 4. Once file is downloaded sends command back to server letting it know the file has been successfully downloaded. 5. Once file is downloaded shells a system command telling another program to import the file with the downloaded files filename. 6. If disconnects trys to reconnect until connection is made.