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] <javascript:>>: > >> 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] <javascript:>. >> 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.
