Web Server & Database Administration Flashcards

Which Apache configuration file format is used in Debian-based systems to enable or disable sites?

Answer: Symlinks in /etc/apache2/sites-enabled/ managed by a2ensite/a2dissite

Debian-based systems use a2ensite to create symlinks from sites-available to sites-enabled, which Apache reads at startup.

What is the purpose of the PostgreSQL pg_hba.conf file?

Answer: Controls client authentication methods and access rules

pg_hba.conf (host-based authentication) defines which hosts can connect to which databases as which users and by what authentication method.

Which Nginx directive defines a named location block for internal redirects only?

Answer: location @name {}

A named location prefixed with @ (e.g., location @fallback) is only accessible via internal Nginx directives like try_files or error_page, not directly by clients.

When configuring MariaDB binary logging for replication, which configuration file option enables it?

Answer: log_bin=/var/log/mysql/mysql-bin

Setting log_bin in my.cnf with a file path enables binary logging, which is required for MySQL/MariaDB replication.

Which Apache module enables URL rewriting using regular expressions?

Answer: mod_rewrite

mod_rewrite provides a powerful rule-based URL rewriting engine using Perl-compatible regular expressions via RewriteRule and RewriteCond directives.

In MySQL, what does the binary log format 'ROW' record?

Answer: The actual data changes for each affected row

ROW-based binary logging records the actual before and after values for each changed row, making replication more precise and safe than STATEMENT format.

Which Nginx directive sets the number of worker processes, typically matched to CPU cores?

Answer: worker_processes

worker_processes defines how many Nginx worker processes run; setting it to auto detects and matches the number of available CPU cores.