Thanks for the great reply Jim... On Wed, Apr 5, 2017 at 4:31 PM, Jim S <[email protected]> wrote:
> 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/d >>>>> efault/chapter/29/06/the-database-abstraction-layer#Connecti >>>>> on-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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/web2py/tpzYF1Rh0kY/unsubscribe. > To unsubscribe from this group and all its topics, 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.
