Unfortunately, I have more problems with fcgid than anything else. When my fcgid goes down, it takes Apache's parent with it. The child runs and answers all requests till such time as there is a lull in traffic long enough for the timeout to take affect, it kills the child (as it is supposed to) but without the parent, there is nothing to spawn a new child to answer requests so the server is shut down at this point.
I have always had the problem matching php versions connector with a mysql version. With the exception of what I have now, which is so old I do not trust it.
I hate locking data into a database that I then have to be stuck with, why I still to this day use a lot of flat file databases ... anything can read it, no special software required.