Wordpress - running multiple sites off one database?
- Started
- Last post
- 11 Responses
- fadein11
My client doesn't want to pay for 8 databases for 8 websites I am building for him in Wordpress.
All sites are on the same server with aliases. The first one I have built is using the mySQL available.
How feasible would it be to run 8 sites off one database using separate tables?
Are there big performance issues?
Can I import data just into one table easily via phpMyadmin?
Excuse the ignorance - never done this before apart from my own site when I tested some Wordpress stuff using my database.
- Stugoo0
Unless every website has the same content I would not recommend this in the slightest. They really should be separate.
However it would be possible if you install the database by using a different naming prefix instead of wp- I think you can change it when you install wordpress.
- meffid0
8 installs to update. Lucky you.
- fadein110
Thats good enough for me - thought as much.
Seemed like a nightmare.
Thanks.
- hereswhatidid0
If they insist on the one database just make sure to have a decent caching plugin in place. If done correctly the actual database access will be very minimal.
- hereswhatidid0
Side note: Isn't it hilarious that a client will pay thousands for a site to be built but then balk at spending more than $5 a month for hosting?
- fadein110
2 friends said the same thing - each site should have its own database.
- vaxorcist0
? is it because the webhost charges by the database ?
? they could switch web hosts ?
@hereswhatidid is right... this sounds like penny wise dollar foolishness, possible hint of future randomness....
it could be done by using caching, and cloudflare and making sure you set table prefixes carefully, but I smell duct tape engineering ...
the randomness that might happen due to this kludge may be blamed on you, so beware of a possible all-nighter or two when something randomly weird happens due to an update-WP quirk when you least expect it...
cloudflare can help by essentially caching your site all over a CDN, but it also means that your "update content" procedure gets more complicated and/or you have to live with a time delay to propegate changes....
- prophetone0
just make sure when this jenga setup starts acting up they don't blame you. warn them against it in the beginning. i would raise alarms personally to get the point across. and why would you stick with a host that charges for multiple databases? weird.
- fadein110
I'm not doing it it one database now - see above.
I have said I need separate databases especially as the faffin' about will cost as much as the actual databases.
@vaxorcist - I have no say on the webhost unfort.
- vaxorcist0
Are they high volume sites? Running multiple WP installs on same hosting account through aliases? Then the server RAM limit may be an issue.
-if so, I suggest Cloudlfare.com, which worked out VERY well for me on a high volume site.
Are they blogs with comments/users, or more like "wordpress as a CMS" sites?
-if there are comments I suggest putting the comments off-site, like using Disqus or Facebook comments, not so much for the comments, as the occasional wave of scripted spam-comment-attempts can wedge your server if you don't have a lot of RAM allocated.... even if you have anti-spam stuff in place, it takes code-run-time to detect and deflect....
- thanks for advice. low traffic sites with wordpress as CMSfadein11