I am using "autossh" which is a monitor wrapper around ssh that restarts the ssh connection if it gets dropped. It appears to be working well.
On Thursday, October 12, 2017 at 4:52:49 PM UTC-5, appj...@gmail.com wrote: > > I'm using Heroku. Would the VPN option be more stable/reliable/performant > than an SSH tunnel? > > On Thursday, October 12, 2017 at 8:07:36 AM UTC-5, CDA wrote: >> >> 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, <appj...@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+un...@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.
