MySQL / MariaDB DBA

Installation, Configuration & Memory

Question

Option files versus command-line options: how should production configuration be divided?

Answer

Option files provide repeatable startup configuration; command-line options are transient launch overrides. Put reviewed server policy in managed option files; reserve command-line overrides for controlled diagnostics or automation. Applies to MySQL and MariaDB.

This is 2 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples