Depending on the type of cloud service you may be able to setup VPN over internet and connect your DB via the VPN tunnel.
On Oct 11, 2017 11:24 PM, <appjar...@gmail.com> wrote: On Wednesday, October 11, 2017 at 11:52:02 AM UTC-5, Massimo Di Pierro wrote: > > > On Saturday, 7 October 2017 01:55:53 UTC-5, appj...@gmail.com wrote: >> >> Thank you Massimo! >> >> There is a great detailed deployment recipe for SSH tunneling to your >> database server from a Heroku app instance (dyno). It works as of this >> post.10/8/17 >> https://stackoverflow.com/questions/21575582/ssh-tunneling- >> from-heroku/46629121#46629121 >> >> There are 2 issues/questions with this though: >> >> 1) So now that I can tunnel in, I have a performance question: Since the >> mysql database server will be making all of its connections to localhost is >> that a single connection rather than multiple? Will I lose database read >> concurrency? If so, will either that or the SSH tunnels be a bottleneck >> and severely degrade my database performance? >> > > web2py has connection pooling. Each of connection from the pool will go > through the tunnel, concurrently up to the max number in the pool. > >> >> 2) SSH tends to be flaky and drop connections leaving a broken Web2py app >> instance. Any suggestions on best practices for handling that case? >> > > > No. Sorry. If others have suggestions I would like to hear them. > > >> >> It's too bad DAL doesn't support secure connections. Encrypted database >> connections are pretty standard nowadays and I see there are python mysql >> connectors that do. Has anyone successfully swapped out the one that ships >> with one of those? >> > > It would be easy to add. we will work in it. > Thank you! What is the process for this? Should I open an issue in github? > > >> >> Cloud deployment is new to me so I really appreciate the help, and I love >> using Web2py so thanks for making it and the ongoing support! >> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
