Here is a quick list of reasons why we host 1. Data sync - we sync data to/from a number other platforms that we host here as well, HR/Payroll (MS SQL), Accounting/Inventory (AS/400), Product Development (Pervasive). Would be slower if we were syncing to the cloud and we get killed on bandwidth charges. 2. Availability - we are in a relatively (not terribly) remote area. We have fiber to our building but we did lose it for about 1/2 a day twice in the past year. Our local users take priority over remote so we are willing to live with this. 3. Private Control - as you mentioned, we do like to retain control over our data. We have backups and replicate to a couple of our remote sites. 4. Cost uncertainty - last time I looked at moving to a cloud infrastructure it was hard to pin down exact costs. My concerns were with our synchronization programs and what kind of bandwidth we'd be charged for. But, it has been a while since I've researched any of those options and of course things could have changed.
So many new container technologies out there that we could benefit from but we haven't made the jump yet. Walking that thin like between sticking with a stable environment and newer bleeding edge technologies. -Jim > @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.
