Database Instances - MySQL / PostgreSQL / MongoDB Multi-Instance

NK supports MySQL / MariaDB / PostgreSQL / MongoDB multi-instance, each with isolated datadir, port, config, running under its own systemd-style subprocess.

Multi-instance rules

  • Isolated data_dir / log_dir / config_path per instance
  • Independent OS users (mysql:mysql / postgres:postgres / mongod:mongod)
  • User-specified ports (recommend 13306+ / 15432+ / 27018+)
  • NK-managed users prefixed nk_, auto-generated passwords. Never manually reset-pwd inside the engine.

Provision DB for PHP apps

Use website-db/create on an existing instance to provision DB + dedicated account:

  • name (required, DB name)
  • db_type (mysql / postgresql)
  • instance_id (number)

Returns username + password_enc (actually plaintext — write straight to wp-config.php). See Websites.

Replication

Business+ includes DB Master-Slave Replication for geo read replicas and DR.