AgileApps Support Wiki Pre Release

Difference between revisions of "Database Administration Tips"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
Line 1: Line 1:
=== Database Administration Tips ===
=== Database Administration Tips ===
 
* Ensure that all database servers and web servers are configured to be in the same timezone, regardless of where they are geographically located.
* You should have different user accounts with different access permissions. These are typical:
* You should have different user accounts with different access permissions. These are typical:
** A ''root'' user with all permissions, accessed from a specific host only.
** A ''root'' user with all permissions, accessed from a specific host only.

Latest revision as of 00:41, 19 September 2015

Database Administration Tips

  • Ensure that all database servers and web servers are configured to be in the same timezone, regardless of where they are geographically located.
  • You should have different user accounts with different access permissions. These are typical:
    • A root user with all permissions, accessed from a specific host only.
    • For access from other web servers, one root user for each host.
    • An admin user with limited privileges to do a DB dump, monitor the DB server, and/or monitor the replication server.
    • A read only user who cannot modify the database for reports, backups, and exports.
    • A replication user that is used only by the replication process.
  • Always do DB dumps, reporting, and exports from the replication server, as those activities introduce locks that interfere with users.
  • Analyze queries from the replication server. Do not login as root.
  • Do not login as root on the production server unless executing a DML or DDL.
  • Always use transactions when executing a DML (begin- and end-rollback).