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 <javascript:>> 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 <javascript:>. > 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.
