-1

We have a BlueHost WordPress install that we would like to enable a secure remote connection to our secondary database in Azure. We do not want to replace our existing db, just run queries through SSL connection against that db from our WordPress.

We have configured everything appropriately in Azure to accept the requests, but cannot find any good documentation for WordPress end to properly enable/make that connection.

We thought there might be a method to extend wpdb and/or modify the WP-config.php, but following WP docs on “SSL connection to remote database WordPress” (or variations of this) only returns guidance on setting up a primary database FOR WordPress using remote db.

We found a possible plugin (WP data access plugin), but when we try to use, our admin bugs out (could be a BlueHost issue). We would prefer, however, not to use a plugin but actually understand and manage this feature ourselves.

We assume since we have a web server we can attempt to manage this connection outside of the WordPress instance itself, but that feels hacky.

Improve this question

1 Answer 1

Reset to default
1

We do not want to replace our existing db, just run queries through SSL connection against that db from our WordPress.

You can create new WPDB objects to connect directly to new MySQL/MariaDB instances, but there is no support for tunnels, it is a direct connection only. For anything else you'd need to proxy it somehow and connect to the proxy, but this would be a non-WordPress non-PHP application that you would need to research and setup yourselves.

Likewise there is no support for non-MariaDB/MySQL databases, unless Azure DB can handle MySQL flavoured SQL as is without modification then WPDB is useless to you. WPDB uses mysqli internally.

The most you could expect WPDB to deviate from MariaDB/MySQL norms is SQLite, for which there are plugins that try to add support for.

Additionally, you should expect a heavy performance penalty for connecting to a remote database, regardless of the vendor or type of software at the other end. Remote requests and connections are one of the most expensive and slowest things you can do. Sites are normally colocated with their database for a reason, either on the same machine, or in the same data centre cluster for lower latency and turn around time. Your page will never load faster than the time it takes to do a request to your remote database, you will want a lot of caching and to make things as async as possible.

Instead you should stop searching WordPress resources, and instead try to find generic PHP resources, it's extremely unlikely you will find anything WordPress specific.

We found a possible plugin (WP data access plugin)

This plugin has little or nothing to do with what you want.

We assume since we have a web server we can attempt to manage this connection outside of the WordPress instance itself, but that feels hacky.

You'll need to treat this as a PHP application task that just happens to be inside WordPress. Look at generic PHP libraries, and their examples, and fit that into your WordPress code, or, have some other application that sits in-between WP and your Azure DB that can handle requests.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.