Is that possible one wordpress with multi DB ? Cause my site is grow to huge and mysql seem like difficult to handle it .... Not hardware issue cause db run in single dedi and host with no issue too (100mb line) .... Current stat : Post 500k Tag few millions. problem i facing now : very slow on search and difficult to access wp admin panel, some time can't even post or edit or delete any post ..... Hardware : quad xeon 2.8 8gb ram 100mb line on DB only.
Indirectly it relates to your question, because it will relate to my answer. Any blog with that many posts is obviously auto-generated, in which case, you get what you put into it. And you will get the same in return from me, because I have no time to invest in a splog. My auto-generated answer. MySQL can handle it. The database has nothing to do with the slowdown in your Admin.
don't be over confidence or look down on other .... not a lot ppl will spend 300 monthly hosting for auto blog, just for your information, i run classified wp site with classipress theme ..... db have nothing to do with the web ? could u answer this ?
If you are adding these posts by autoblog, depending on how many feeds you are importing, they will definitely slow your site down to a crawl. And the more you add from other sources, the slower your site will be. In that case it has nothing to do with the database. Also, shared hosting is slow and get's slower as your site grows. VPS is not much better. To answer your question, here is a multi database plug in that is reliable, well documented, with support: http://premium.wpmudev.org/project/multi-db However, multiple databases are usually reserved for multiple blogs on the same installation. One website, no matter how many posts, doesn't necessarily need to run on multiple databases and I suggest that there is another problem slowing down your Wordpress website. Are you on a shared server or Dedicated? What version of PHP are you running and what version of Wordpress? Are all of your plug ins up to date? How many plug ins are you running? If you are running a cache plug in, are the settings correct? Are you running any old plug ins that haven't been supported? Are you compressing your images? Is your theme coded well? There are plenty of large sites out there running on Wordpress on one database. I would caution you to troubleshoot everything else before you make such a decision.
As per OP, he is running a classified site using WP. And if this site had been running for quite long and is as popular then there are certainly issues with the older posts which have no use of other than for SEO purposes. I would suggest OP to delete the older posts and delete the db entries by date, amy be a few years of entries which are of no use. This will surely affect SEO as the organic search results will definitely show the older results. So, a better configuration of 404 error page with apt results categorised will prove much useful than slowing the admin panel and there by affecting the over all performance. MySQL can handle virtually any number of requests, but do not underestimate the servers too. There might be other factors which are eating up resources and it will need a considerable amount of lookup before answering your query aptly. If you are asking about the stored procedures in MySQL, you definitely can perform these jobs on a periodic basis, but we are not running a search engine to index each and every post on a blog, right? Any way, what good would a classified web site make when the indexed posts are a few months old? Probably, a benefit for SEO but over all, they burden the db when retrieving the search results. @skabt: Please do not underestimate other users who are answering your questions here. Dodger was helping you and that too, considerably. We do not have any reason to help any one out in this section. We are just offering several solutions for your problems. I did not like your voice in the reply posted above. But, please do consider that we had been working on WordPress for the past several years and We have virtually covered most of the intricate sections of the CMS platform and are quite confident when we are answering. And, that was a perfect checklist kinda questions from hmansfield. Update us with your queries. we are hearing and yes, we do get agitated as well.
my apologize on harsh reply (to you), i act base on what is first and second reply, i know there plenty good and nice programmer around, skill and knowledge is not only thing make them good programmer .... i does hate some one jump in conclusion before he/she knowing what happen or assume by his knowledge without accepting other's .... there is no feed crawl on my site, 1. Dedicated server ? yes 2.Php version ? Php 5.2.13 3. Plugin up to date ? yes base on my version of wp, some newer plugin don't work on 2.9.2 (sorry i can't afford too frequent update from wp). 4. How many plugin ? 18 plugin, all in one, add to any, sitemap generator, page navi, no category and all basic stuff. 5. Cache plugin yes, configuration is ok. 6. Yes photo well compress. (i used thumbnail only) 7. Theme coded ? shouldn't be any problem, my theme is very simple, basically nothing much different then wp standard theme. Problem is not on the site, site work fine and perfect speed, only issue i having difficulty is when inside admin panel, hard time to edit, delete and making new post .... I agree 1 gb of data is not much, but difficulty on admin panel keep pop out, that really irritate me .... Site spec : quad 2.8 xeon 16gb ecc ram Bandwidth : guaranty 10mb, no limit on buffer. basically it serve 98% local traffic. Site visitor : 6k-11k UV daily 20k-45k daily impression. 500k post. few million tag. (i can't afford to remove this, where my traffic from) Compare with my other site (WP base) Server spec : Share host from Godaddy, USD 7 permonth. Traffic : 30k - 35k (daily) Impression : 55k-65k (daily) Almost same plugin. basically traffic is much higher but site having no problem with smaller WP DB and share host (really surprises with godaddy share host) Test i did before : Create another 7 wp site (base on site category) with individual db under same server. Higher db with 270k post. Everything same other then category become sub folder, but it work perfect without single issue on admin site .... this does make me wonder and suspect on wp-DB issue. thanks
Sorry, that multidb plugin is for multiple site install with multiple DB, it won't work on single wp installation, (i found it hardware by paying them) ..
My bad. I assumed that you were running a MU site. I have never heard of anyone needing multiple databases to run a single user installation. You didn't make that clear at the beginning or I just didn't understand your English.
yes, they do wp.com by running hyperdb (partition, duplicate, foil and bla) .... but for a small site (500k post) do i really need to dedicated server to handle wp ?