Hi, I wanted to check back to see if there was any update on this. With more and more database solutions moving to hosted DB services (so no SSH tunnels), Web2Py apps do not have the ability to connect to these securely.
We are stuck hosting a dedicated machine to server our MySQL and run an SSH server. We'd like to switch to Amazon Aurora for example. 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, [email protected] > <javascript:> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
