I have a lot of data store in an MySQL database on an VPS.
Given it's 100k upto several million of records, depending on the table I'm using, I need a strong VPS for sever side processing.
For a lot of stuff, I work directly on the database via https://tableplus.com/ and connect via openssh.
Now I realized I cannot connect the same way with wpDataTables via 'Separate DB connection' to the external MySQL database. For webhosting solutions this was working geat.
You may have any hints, how I can solve this issue and get the connection done via wpDataTables as well?
Good da,
I have a lot of data store in an MySQL database on an VPS.
Given it's 100k upto several million of records, depending on the table I'm using, I need a strong VPS for sever side processing.
For a lot of stuff, I work directly on the database via https://tableplus.com/ and connect via openssh.
Now I realized I cannot connect the same way with wpDataTables via 'Separate DB connection' to the external MySQL database. For webhosting solutions this was working geat.
You may have any hints, how I can solve this issue and get the connection done via wpDataTables as well?
Thanks for your great support. :)
Felix
Attached files: MySQL connection to VPS.png
MySQL connection to VPS via wpDataTables.png
Hi Felix,
We were advised by our devs on this, in regards to any External DB connection that uses SSH.
At this time, it is not possible to achieve this with built-in options.
You would have to make a custom workaround, that would not be covered by our support at this time.
Here's one resource that you can check out if you wish to try:
https://help.pythonanywhere.com/pages/AccessingMySQLFromOutsidePythonAnywhere/.
MySQL databases on PythonAnywhere are protected by a firewall, so external computers can't access them.
There may be a way of doing this through VPN, but you'd need to have the tunnel constantly opened for something like that.
I don't exactly know how to do it, but if you are willing to explore this option, I'm sure you'll be able to find some useful info.
We hope this helps.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Dear Miloš,
Well noted and thanks for your feedback.
So, if I understood correctly, there are the following options:
Have a nice day
Felix