On Saturday, 7 October 2017 01:55:53 UTC-5, appjar...@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. > > 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.
