Hi Ive had cms MS up and running but I'm a constant updater and have shot my self in the fooT!
I'm getting the dreded adodb-mysqli.inc.php error which means my php / Mysql are our of Whack
Can some one recomend a rock solid php / mysql combination?
Being a lazy mac os X user I can only find a PHP 4.3.11 install is this going to be a problem?
Also there is the possiblilty that we will be deployint this on a site thta gets 1.3 Million hits a month has anyone useed cms on a similar sized site?
Also any thoughts of taking this up to php 5?
Thanks in advance
Steve
Whats rock solid? And what about big deployments?
Re: Whats rock solid? And what about big deployments?
I'm a lazy OS X user as well. Right now I'm using a 4.3.11 and mysql 4.1 combo that works really well for development. For extra laziness, I have my mysql 4.1 set back into old passwords mode so that the mysql driver works instead. On my dev server, i have linux with php 5 and 4.1 in mysqli mode. That works well, also.
In other words, they all work. It's just a matter of setting mysql up to the particular php distribution that you're using. Mysqli is better, but most of us don't have the option without compiling your own php (and who wants to do that?)
cmsmadesimple.org does approx 800k to 1 mill hits per month. Granted, some of that is forums traffic, but still. It can easily handle it, as long as caching is on. On an average site, you should only have 5-6 queries per request, which is well below most other CMS systems out there.
In other words, they all work. It's just a matter of setting mysql up to the particular php distribution that you're using. Mysqli is better, but most of us don't have the option without compiling your own php (and who wants to do that?)
cmsmadesimple.org does approx 800k to 1 mill hits per month. Granted, some of that is forums traffic, but still. It can easily handle it, as long as caching is on. On an average site, you should only have 5-6 queries per request, which is well below most other CMS systems out there.
-
Steve_a
Re: Whats rock solid? And what about big deployments?
Hay thanks for the fast reply!
1 more quesiton - I'm thinking of running the mysql on a diffrent computer than the web server. I had this working but the php/apache machine seemed to slow down... pages were taking about 10 sec or longer to load.... the mysql box was sitting at only about 20 % usage (the test box was an old 400 Mgh imac) and the web server (test box an emac) seemed to be locking up %100 utlisation lots of the time...
Any thoughts on why this may have been slow?
Any thoughts on wether it's a good idea to use a seperate mysql machine?
1 more quesiton - I'm thinking of running the mysql on a diffrent computer than the web server. I had this working but the php/apache machine seemed to slow down... pages were taking about 10 sec or longer to load.... the mysql box was sitting at only about 20 % usage (the test box was an old 400 Mgh imac) and the web server (test box an emac) seemed to be locking up %100 utlisation lots of the time...
Any thoughts on why this may have been slow?
Any thoughts on wether it's a good idea to use a seperate mysql machine?
Re: Whats rock solid? And what about big deployments?
That's really strange. MySQL on a separate box should only introduce latency, and a very small amount at that. I have my linux machine on a 533 mhz intel with 64(!) megs of ram. Pages take about 1-2 sec and the load is never high. I'm not really sure what could've been causing the problem. Lot's of people use this architecture and it's fine.
