Is it possible to have a mysql database seperate from your shared hosting/ I am having a problem here.. somehow I am hogging all of my hosts mysql resources. http://www.blackhatworld.com/blackha...-list-now.html __________________
First things first, you have to work out why your sites are being such a mysql hog. Try minimizing sql calls in your theme (hardcode stuff where possible) and install a caching plugin. Yes you could have a separate VPS or server for mysql that's separate from your http server but it would be kind of pointless, you may as well just get a decent server for the whole shebang. With 60 blogs, you should be earning enough to get decent hosting for them. If you put your stuff on a VPS, then you are guaranteed a certain share of resources. Your mysql processes wouldn't be shared with the rest of the users of the server because you have your own mysql instance running on the OS on your VPS; your VPS can't exceed the resource limits assigned to it.
No. do not get the minumum hostgator package get atleast the 3rd option and above you want them to mange it....
HG is full of shit. for 60 autoblogs, HG is not for you. i started 1 autoblog there with few cron jobs, and they suspend me twice during this time b\c of "too much server resources". they sent me the log on and what i saw is only 10 google bots, 8 ftp connections and 4 cron jobs. edit: i mean, the shared hosting is not for you. maybe the VPS will be ok.
Whatever provider you choose, Don't forget to install wp super cache or w3 total cache plugin. These plugins will dramatically decrease server load.
I'd say that if you are using too much MySQL resources, you are trying to load too many articles into your web site, try focusing your keywords and better target your content.
You should either get a strong VPS or use 6-7 shared hosting accounts and divide all. You also need to be WP savvy in order to ensure all is going properly and no resources are being abused. I suggest using multiple hosts since using just one can get them all disappear within just a moment.
Even with a few wp blog you can get suspended if wp is poorly implemented. Some tips to make your wp install more stable. 1. above mentioned super cache plugin. Wordpress super cache plugin is an extensive modification of the WP-Cache plugin. The wordpress super cache plugin serializes your posts to a file on disk and later spits them back. It also knows how to update itself when comments are received, etc, so your site is always the most up to date. Note: to use this plugin you must have Mod_Rewrite enabled. Add the following to your .htaccess file: Options +FollowSymLinks RewriteEngine On 2. WP Built-in object cache - The default installation of wordpress can be used to cache database queries. Less database queries = less resources being used . Just add the following line to your wp-config.php file: // Enable the WordPress Object Cache: define(ENABLE_CACHE, true); 3. Review your plugins - You should go though the plugins you have installed and see if there is a way to make them faster. Any way in which you can make them stop creating database queries and use flat files, or even better, cache things will help out greatly. If you find that a particurelar plugin is slowing down your wordpress install you should uninstall the plugin or consult the author. 4. If you are doing media-rich applications and serving large files you may want to consider hosting on a vps or dedicated server. 5. keep your wordpress install up to date. I got these advises from my hosting.I thought I share them.
I was actually using it. I think the problem I was having is that there were 60 sites al running the plugin plus xml sitemaps plus duplicate erazer. Every time it ran I was using 75% of their server resources. Other customers complained. My keywords almost match my domain on every blog and I generally just use bllog search combined with an RSS feed delivery of Google alerts. I don't think this is in any way a bad reflection on any one plugin or combination of plugins I was using. It was just a matter of slamming a shared host with 60 autoblogs. When I switched to IX I made it clear what I was going to do and they said " it shouldn't be a problem but if it becomes one it will be an easy fix" This was far from an easy fix experience. The only reason I chose to stay with shared hosting and not go to a VPS before going to IX was they gave away 15 unique Ips and 3 domains. I guess Ill go ahead and get a Host Gator VPS now?
Ill get a Hostgotor VPS as soon as I am able and swap a load of my sites over there and keep 15 with ix to keep the 15 free ip's. I just tried switching one of my blogs from Wp super cache to hyper cache and I got a notice to edit my wp-config file that I never got with any other cacheing plugin. Could it be that I wasn't actually caching before?
Maybe I should just give up on Wordpress and go back to simple static page sites? I think I actually have this figured out now. I think my cacheing is broken. I just tried to change Cacheing plugin from WP supercache to w3 total cache and when I went to enable w3 I get this.. The path found in the database (/home/users/web/b1769/moo.southiecab/bostoncabtaxi//wp-content/uploads) is inconsistent with the current paths found on your server. Please manually adjust the upload path either in miscellaneous settings or in the site's edit page if in network mode. I don't suppose you can give me some hint how to fix it? I think that Moo bullshit is left over from when I was hosting with FATCOW
The plot thickens.. This is in my Google Webmaster tools for almost every domain under crawler access. User-agent: * Disallow: Sitemap: http://boston-taxi-cab.com/sitemap.xml.gz <!-- WP Super Cache is installed but broken. The path to wp-cache-phase1.php in wp-content/advanced-cache.php must be fixed! -->
Sounds like you just need to edit the path variable in that file to whatever the correct path is. http://wordpress.org/extend/plugins/wp-super-cache/faq/
Great.. Ill gladly do that.. Id do anything at this point. Id even consider driving to Ohio and blowing the entire ixwebhosting.com crew. Can you tell me how to edit that pathway?
Slightly tricky. Basically you just have to open advanced-cache.php and wp-cache-config.php in wp-content/plugins/wp-super-cache and edit the value of WPCACHEHOME and possibly CACHEHOME. Probably easiest just to put in a support ticket and let the techs sort it out. Also check the admin panel for super cache and see if it tells you anything informative.
