@Jim Do you do this more for private control of your app(s) and data or for efficiency? What were your considerations to go this route instead of cloud infrastructure like AWS/Pytnonanywhere/Heroku/etc ?
On Tuesday, April 4, 2017 at 8:38:31 AM UTC-5, Jim S wrote: > > The advantages would be more processing power and separation of duties. > In our environment, we have: > > * database server (MySQL) > * Load balancer (haproxy) > * Multiple webservers running nginx/uwsgi/web2py > * Redis server for caching > > By separating the database server from the webserver we can then scale up > for more web traffic by adding more webservers. The load balancer server > just handles routing traffic to the least used webserver. All servers run > on Ubuntu on different VMs under VMWare ESXi. > > This is a mildly complicated environment and definitely not necessary for > all installations. If you're newer to deploying web applications then > keeping everything on one piece of hardware may make more sense. > > When you say you have a large multiuser application, how many users do you > typically have? Any idea how many transactions per second? > > -Jim > > > > On Tuesday, April 4, 2017 at 8:30:09 AM UTC-5, Áureo Dias Neto wrote: >> >> Are the advantages of using mysql on another server? >> Or does this solution vary from my hardware? >> >> 2017-04-04 10:22 GMT-03:00 Jim S <[email protected]>: >> >>> Take a look here >>> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-strings--the-uri-parameter- >>> >>> Then, for MySQL, change the localhost in the connectstring to the name >>> of your database server. You also have to make sure that MySQL is set to >>> allow remote connections from the user you are connecting with. Check out >>> this link on how to do that: >>> >>> >>> http://stackoverflow.com/questions/23733734/how-to-enable-remote-access-of-mysql-in-centos >>> >>> -Jim >>> >>> >>> On Tuesday, April 4, 2017 at 8:07:55 AM UTC-5, Áureo Dias Neto wrote: >>>> >>>> How to migrate data from sqlite to mysql or postgre? >>>> I tried to migrate the data to mysql using the workbench, but it did >>>> not work .. >>>> >>>> And, how would this question the database on another server? How does >>>> the connection work? >>>> >>> -- >>> 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. >>> >> >> -- 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.
