In Mysql:
Code: Select all
create database someuser_od;
create user 'someuser'@'%' identified by 'SomeSuperSecurePassword';
grant all on someuser_od\%.* to 'someuser'@'%'; # allows it to create backup databases
Code: Select all
mysql someuser_od <backup.sql
mysqld.cnf file:
Code: Select all
sql_mode = NO_AUTO_CREATE_USER
I noticed that there are 24 queries that are run when navigating from page to page, which could account for up to almost 2 seconds of lag at 70ms each, but what about the rest? Is the ping time the only issue here, or is there more for me to look at?
I wouldn't mind trying the middle tier, but is it possible to host multiple offices using a single server on middle tier? It wouldn't be economical if each had to have it's own Windows license and deal with the overhead of multiple OS installations.