Will's questions

What are the options for having multiple mysql servers with the same database and data. I know there is replication but I have been reading that it can have issues especially if there are connection issues. Are there any alternatives to the built in replication that are reliable? Someone suggested getting a server on the same network so the mysql server can be accessed by all the servers over lan, but currently that is not an option for me.

Is mysql just not meant for replication? Is there another sql engine that is better for it?

I have never done something like this. I currently am running a forum and service which rely on the same database on the same server but as they grow it has become apparent that 1 box is not enough. Plus this will be good experience for when I add on to it even more.

So I have a forum (vbulletin) and a wcf service which uses the user table to get user information when they log into the service.

What should I do for splitting them apart? I imagine having the service connect remotely would be slow. I have read about replication but I am not really sure how to set that up. Also does replication support only doing a single table? As I don't need it replicating the entire database.

I was thinking about getting a stable 3rd server for hosting the mysql database that way if the forum server goes down the service server will still work. But how would that work? Can replication go both ways? Like changes to the replicated database on the forum server will be sent to the database server.

My host provides an smtp server for sending mail. I want to setup sendmail to relay all emails to the hosts smtp server. How do you do that?

I want to install the mono RPM like it would be if I installed it through yum. What I mean is that when you install the rpm it puts everything in /opt/novell/. I want it to put in /usr/bin/, etc like yum does.

if I try to run my program that uses HttpListener without root it throws this exception.

Unhandled Exception: System.Net.Sockets.SocketException: Access denied
  at System.Net.Sockets.Socket.Bind (System.Net.EndPoint local_end) [0x00000] in :0
  at System.Net.EndPointListener..ctor (System.Net.IPAddress addr, Int32 port, Boolean secure) [0x00000] in :0
  at System.Net.EndPointManager.GetEPListener (System.Net.IPAddress addr, Int32 port, System.Net.HttpListener listener, Boolean secure) [0x00000] in :0
  at System.Net.EndPointManager.AddPrefixInternal (System.String p, System.Net.HttpListener listener) [0x00000] in :0
  at System.Net.EndPointManager.AddListener (System.Net.HttpListener listener) [0x00000] in :0

How can I allow HttpListener to be used by users besides root?

I have a remote server that needs to access my mysql database a lot. So I figured instead of sending a bunch of remote mysql commands it would be more effecient to sync the database to the remote server. Is there a program that easily does this and that I can configure to only sync specified tables and possibly columns?

I have a ddos protection proxy in place to deal with SYN floods and such. But http floods are still getting through. For some reason their ddos proxy is not blocking any of the flood. So there are about 500 ips connecting to the box as many times as possible and max out at about 20k connections. This is causing php to spawn 1k processes overloading the box. How can I mitigate this http flood? I thought setting up an htaccess file which required a cookie to access the site would work but rewritecond seems to be invoking php which causes the box to overload.

How can I mitigate this?

Is it possible to have 2 web servers running on the same box with different ports and then use htaccess to tunnel traffic from 1 server to another based on a rewritecond? Basically when a certain condition is met I want the request to be handled by my other web server and I don't want to return a moved response.

I am trying to compile mono from source and am getting this error.

../src/.libs/libeglib.a(libeglib_la-gunicode.o): In function monoeg_g_get_charset': /opt/mono-2.10.1/eglib/src/gunicode.c:312: undefined reference tolocale_charset'

I am compiling it on centos5. I have compiled it before on other machines (Centos too) so I have no idea whats wrong.

I want to setup pptpd on my linux server and tunnel through it like if I were tunneling through ssh. Is it possible to setup the vpn connection to be a local proxy that way I can choose what programs connect using it?

I have a program that runs in the foreground so I run it via a 'screen'. Is there a good start/stop/restart template for 'screen'? I need it to pass the commands to the screen and create it if it doesn't exist.

I installed mcrypt via "yum install php-mycrypt" but php still says it can't find it. How do I configure php to find it?

How do you compile Python/TKinter? I installed tk-devel and then recompiled python which got rid of a warning about tk. But Imaging still says

*** TKINTER support not available

Also when I try /locate tkinter it says

/usr/lib/python2.4/lib-dynload/_tkinter.so

How do I compile tkinter for python 2.7?

Trying to compile corona on CentOs5.

When I run ./configure I get

checking how to run the C++ preprocessor... /lib/cpp
configure: error: C++ preprocessor "/lib/cpp" fails sanity check
See `config.log' for more details.

Tried downloading an rpm and it said missing dependencies

Although after looking at that, I am guessing I downloaded an rpm not for centos5?

(Ugh, I can never get pre/code to work :|. Even though it looks fine in the preview)