Home > php > How would you connect to 100 different databases in wp-config.php

How would you connect to 100 different databases in wp-config.php

December 18Hits:63

We have a setup where we have 100 sites using exactly the same code base, and all files are stored on Amazon S3. But right now we are running 100 different WordPress installations.

Now I was thinking just to change the settings in wp-config.php based on which is openend.

All our databases is on Amazon RDS and in general all hosting is on Amazon, so we have all their services at disposal for the setup up.

I have not made any test yet, but of cause the "database" container the information which database to load should be high speed, so what would you do ?

My though was either a json text document on the server or somekind of database.

Tags:php, wp config

Related Articles

  • How would you connect to 100 different databases in wp-config.phpDecember 18

    We have a setup where we have 100 sites using exactly the same code base, and all files are stored on Amazon S3. But right now we are running 100 different WordPress installations. Now I was thinking just to change the settings in wp-config.php based

  • Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServerTempDBAugust 20

    The error log on my sql server throws this warning every 5 seconds 'Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServerTempDB.' From what I can tell this may be due to my environment having a mix of 2005 and 2008 SQL Servers,

  • Is a traditional client app which connects directly to a database a good idea?February 4

    After using Django's excellent admin interface, I was pondering creating a similar system which wasn't as tied to an ORM. Now, while considering this, I thought that overcoming webapps limitations (basic widgets, sessions, text/HTTP-based forms, dist

  • Limit number of connections to a MySQL databaseJune 6

    Is it possible to limit the number of concurrent connections to one MySQL database, regardless of which user is connecting to it? --------------Solutions------------- No, this is not possible. You can limit the connection one user can have or globall

  • Connect to MS Access Database with androidJanuary 17

    I'm working on a project and I need to connect to MS Access Database. The problem is that I'm using a pretty new platform , I'm using Visual Studio 2015 Xamarin and I'm developing to android with c# (thought this platform). I already have a project w

  • How to get connection string of a database mirroring?January 27

    I want to write to program to connect to a database mirroring, and now I'm confused with the connection string. My database mirroring was installed on three SQL Server instances on three virtual PCs. I want my program to run on one of them and connec

  • WSS "Cannot connect to the configuration database"March 15

    I have 64-bit WSS 3.0 installed on a 64-bit Windows 2003 Server. After installing WSS 3.0 I switched IIS to run in 32-bit emulation mode as we have some applications that require this. I'm getting a "Cannot connect to the configuration database"

  • Unable to connect to a remote databaseJune 23

    I'm playing with MongoDB. I have a good deal of experience with MySQL and was using something called Sequel Pro to connect to remote databases. I'm now trying MongoHub but can't seem to get it to connect to the remote database. I tried a basic SSH tu

  • Using wpdb to connect to a separate databaseSeptember 10

    I want to connect wpdb to another database. How do I create the instance and pass it the database name/username/password? Thanks --------------Solutions------------- Yes it's possible. The wpdb object can be used to access any database and query any

  • Connection error to mysql databaseOctober 19

    My application needs to do quite frequent connects to a mysql database on another machine. However I get frequent errors on connection; I can usually eventually connect but after many retries. The error message I get is: Mysql.mysql(): Couldn't conne

  • 100 terabytes database on PostgreSQL without shardingMarch 29

    Is it realistic to setup a 100 TB database (about 90 TB actually) on PostgreSQL without data sharding between a number of nodes? Are there any success stories / examples about similar setups? --------------Solutions------------- 50K writes per second

  • How to connect to a mysql database from a range of ip addresses (or all ip addresses)September 22

    I want to be able to connect to a mysql database remotely but don't know what ipaddress I would be connecting from. Either I'll be connecting over a vpn with dynamically assigned ip addresses or I'll be connecting from inside the company network. ---

  • Changing the user account of the SharePoint applicaton pool returns the error "Cannot connect to the configuration database"November 16

    I am trying to debug an issue regarding the proxy setting in web.config. Currentley it is set to: <system.net> <defaultProxy enabled="true" useDefaultCredentials="true"> <proxy bypassonlocal="true" proxyaddress

  • Why "DataBase Connections" mapped to "Dataset DataBase Connections" in ArcCatalog?November 30

    I am trying to Export data from a geodatabase by a existed sde file(created by ArcCatalog), the Error Messges: Executing: ExportCAD 'DataBase Connections\Connection to GIS-WANG.sde\SDE.water\SDE.ControlValve' DWG_R2010 D:\117.DWG Ignore_Filenames_in_

  • How can I connect to an Oracle database through a shell script?December 16

    I have tried to connect to an Oracle database using the below command: sqlplus -s [email protected]:ORA_PORT/SERVICE_NAME However I couldn't connect. It was throwing the following error: ORA-12541: TNS: no listener. How can I fix this? -------

  • How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.oraFebruary 15

    I want to connect to an oracle database located on another host using sqlplus. This page suggested adding an item on my tnsnames to conenct to that database local_SID = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= hostname.network)(Port= 1521)) (C

  • Unable to connect to MySQL cluster databaseMarch 3

    I am unable to connect to mysql cluster database after starting my management node, data node, mysql node. I made the necessary changes by adding the loadbalance in the dbURL. But I am not able to access the connection. The mysqld port is 1186. Pleas

  • Cannot connect to the configuration database ErrorMay 15

    I am having a bit of a strange issue. I am able to connect to the Central Admin page just fine but when I try to connect to any page on the site I get the following error. Exception information: Exception type: WebPartPageUserException Exception mess

  • Cannot connect to the configuration databaseMay 21

    I don't really know what to do. I was trying to get some bcs working, and because they were not, I've decided to restart the server. After it restarted I was unable to go on any site / page or on the central administration. I had this message : [WebP

  • Multiple multisite instances connecting to the same databaseSeptember 28

    I like the idea of making developers connect their copies to the same database and just set WP_HOME and WP_SITEURL to configure the domain name as they like it. In this model, we don't need to keep migrating databases between servers, and the content

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 0.689 s.