Skip to content

Manual Guide: Sites

The Sites menu is designed to manage mdlwr central and remote site instances. From this interface, remote sites can force-pull changes from the central site based on predefined schedules or via a manual sync button. New tables can also be added for synchronization as needed, checking that the last_modify_date is greater than the execution time of the sync process.

1. Overview & Main Layout

The module contains two primary sections within the dashboard interface:

  • Sites Table: Manages the registration, connection status, IP addresses, types (central/remote), and API key prefixes of connected instances.

  • Tables Registry Table: Manages individual database tables configured for sync, synchronization direction (PULL/PUSH), priorities, sync status, and active states.

  • Offcanvas Editor: A slide-out panel used for creating or editing site records and table registries dynamically.

2. Sites Management Table

This table lists all registered central and remote locations.

Table Columns & Information:

  • ID: Unique identifier string (displays the last 8 characters).

  • Site Name: The designated name of the site.

  • IP Address: Network address or central URL configuration endpoint.

  • Status Connection: Displays health status (Healthy, Offline / Down, Disabled, or Central Master).

  • Last Heartbeat: Timestamp of the last successful heartbeat communication.

  • API Key Prefix: Identifier for the authentication token.

  • Type: Defines the node role (central or remote).

  • Active: Status flag (True or False). Inactive rows are styled in red.

  • Audit Trail / Actions: Hidden metadata columns (Created By/Date, Last Modified By/Date) and operational action buttons (Sync Now, Edit, Delete).

3. Tables Registry Management

Located beneath the sites section, this table manages granular table rules and synchronization metrics.

Table Columns & Information:

  • ID: Unique segment identifier (displays the last 8 characters).

  • Table: Name of the synchronized database table.

  • Direction: Data flow direction (PULL or PUSH).

  • Priority: Execution order priority level.

  • Last Sync: Timestamp of the most recent data synchronization window.

  • Status: Current operational state (IDLE, SYNCING, ERROR).

  • Active: Status flag (True or False).

  • Actions: Action items to trigger instant sync, edit configuration, or delete registry mappings.

4. Configuration & Setup Workflow

  1. Central Site Configuration: Log into the Central Site, open the Sites menu, click the + button to register a new remote location, and copy the provided setup configurations from the prompt modal.

  2. Remote Site Configuration: Access the remote server via SSH, append the configuration to the .env file, clear out duplicate keys, restart the application, and verify the connection status from the dashboard.

5. Standard Table Operations

For complete guidelines on how to use standard table utility features (such as ColVis, copying data, Export/Import, Refresh, Bulk Delete, etc.), please refer to the Standard Tables Guide.