We don’t need to exchange our present db, simply run queries via SSL connection towards that db from our WordPress.
You’ll be able to create new WPDB objects to attach on to new MySQL/MariaDB cases, however there is no such thing as a help for tunnels, it’s a direct connection solely. For the rest you’d have to proxy it by some means and hook up with the proxy, however this may be a non-WordPress non-PHP utility that you’d have to analysis and setup yourselves.
Likewise there is no such thing as a help for non-MariaDB/MySQL databases, until Azure DB can deal with MySQL flavoured SQL as is with out modification then WPDB is ineffective to you. WPDB makes use of mysqli internally.
Essentially the most you might anticipate WPDB to deviate from MariaDB/MySQL norms is SQLite, for which there are plugins that attempt to add help for.
Moreover, it’s best to anticipate a heavy efficiency penalty for connecting to a distant database, whatever the vendor or sort of software program on the different finish. Distant requests and connections are one of the crucial costly and slowest issues you are able to do. Websites are usually colocated with their database for a purpose, both on the identical machine, or in the identical information centre cluster for decrease latency and switch round time. Your web page won’t ever load quicker than the time it takes to do a request to your distant database, you want a number of caching and to make issues as async as potential.
As an alternative it’s best to cease looking out WordPress assets, and as a substitute attempt to discover generic PHP assets, it is extraordinarily unlikely you can see something WordPress particular.
We discovered a potential plugin (WP information entry plugin)
This plugin has little or nothing to do with what you need.
We assume since we have now an online server we will try and handle this connection outdoors of the WordPress occasion itself, however that feels hacky.
You may have to deal with this as a PHP utility process that simply occurs to be inside WordPress. Have a look at generic PHP libraries, and their examples, and match that into your WordPress code, or, have another utility that sits in-between WP and your Azure DB that may deal with requests.
