Multiple DBs on 1 WP install

Submitted by paullas on Sat, 2013-04-06 12:07 in Installation and Setup

Hi David

as yu know i have 1 main wp shopping site but as the prodcuts get imported the DB is getting too big. So is it possible to have 1 main WP frontend site and then use different datatabse, so for example:

MAIN SITE (WP)
-/women/PT install
-/MEN/PT install
-/COMPUTERS/PT install
-/GARDEN/PT install

This way if splitting the DBS up the site will hopefully load products quicker.

Thanks

Paul

Hello Paul, A number of

Submitted by support on Sun, 2013-04-07 08:27

Hello Paul,

A number of users have enquired about doing this (in a similar way to the multi-site search that I help users with using standalone Price Tapestry), so I'll consider this for version 2 that I am very close to releasing. It wouldn't be a straightforward plumb-in job right now as essentially the database table prefix needs to be made variable - so I'll consider that for the next release.

Cheers,
David.
--
PriceTapestry.com

Thanks, looking forward to

Submitted by paullas on Sun, 2013-04-07 11:01

Thanks, looking forward to see that.

Is there also a way to host the databases on a seperate server, reason i ask is at the moment because the DBS as so big it sometimes slows other sites down that has DBs on the same server so im thinking of just getting a hosting account just for databases.

Or if you have any other ideas/suggestions about database hosting.

thanks

paul

Hi Paul, The MySQL host is

Submitted by support on Mon, 2013-04-08 07:15

Hi Paul,

The MySQL host is configurable in both Price Tapestry ($config_databaseServer in config.php) and WordPress (by the DB_HOST definition in wp-config.php) so yes - your database can be on a separate server (many hosting companies in fact have separate database servers so users would have settings like "mysql1234.example.com" as the MySQL host rather than "localhost".

If you are running a large database also check out this thread on PriceTapestry.com which discusses MySQL configuration tuning for large databases...

Cheers,
David.
--
PriceTapestry.com

Hi David Above i gave an

Submitted by paullas on Wed, 2013-04-10 21:51

Hi David

Above i gave an example of 4 seperate categories, would it be better if i had 5 seperate installs of WP and PT or best wait until you have a solution with PT

thanks
paul

Also. Is it better to host

Submitted by paullas on Wed, 2013-04-10 21:56

Also.

Is it better to host the DB in the cloud?

Or do you have any advice on cloud hosting, is this good for large databases.

thanks

paul

will PT work on this david

Submitted by paullas on Wed, 2013-04-10 22:01

will PT work on this david http://www.rackspace.com/cloud/databases/

Hello Paul, Multiple

Submitted by support on Thu, 2013-04-11 08:03

Hello Paul,

Multiple installs would be the most efficient solution at this stage for your scenario - don't forget that you should be able to use the same WordPress theme across multiple installs simply by soft-linking (ln -s command from Linux command line on your VPS/dedi server) the wp-content/themes/ folder of subsequent installations to the wp-content/themes/ of your first / master installation (although settings will have to managed individually) - but any actual code changes to your templates etc. will be seen by all installs.

Regarding http://www.rackspace.com/cloud/databases/ - absolutely no reason why it shouldn't work - once a cloud DB instance is "spooled up" you will have MySQL server, username, password and databasename variables which you can use in your WordPress / Price Tapestry configs just as any local MySQL database - no problem at all!

Cheers,
David.
--
PriceTapestry.com