I would like to figure out a way to have all of my client's websites connect to a central db (hopefully MySQL) and retrieve shipping costs that way, even if they're not on the same server. This will make it easier if the costs are raised again (like they were on Jan 1). Anybody have any ideas?
Unless anyone knows of a way to connect to weight => cost USPS shipping info with some other service?
Essentially a mysql user is created in the central database. In the host field, instead of Localhost, it will be % so that connections from other servers are allowed. It might be a good idea to give that user limited powers - ie, just SELECT etc.
Then the connecting databases will connect to the central server as that new user, instead of to the "localhost" as they normally would.