{% include 'admin/partials/header.html' %}
{% include 'admin/partials/sidebar.html' %}
<div class="acp-page-head"><div><span class="eyebrow">HIGH AVAILABILITY</span><h1>Database Replication</h1><p>Maintain a read-only standby database for backup, recovery, and low-downtime promotion.</p></div></div>
{% if $databaseRole !== 'primary' %}<div class="replication-alert danger"><b>Failover mode active</b><span>The primary database could not be opened. NexusForum is currently operating from the secondary database.</span><code>{{ $primaryFailure }}</code></div>{% else %}<div class="replication-alert success"><b>Primary database active</b><span>Normal traffic is using {{ $activeDriver }}.</span></div>{% endif %}
<div class="admin-stat-grid compact"><article><span>Active role</span><strong>{{ $databaseRole }}</strong></article><article><span>Primary driver</span><strong>{{ $activeDriver }}</strong></article><article><span>Standby driver</span><strong>{{ $replication['secondary']['driver'] }}</strong></article><article><span>Last sync</span><strong>{{ $replication['last_sync_at'] }}</strong></article></div>
<section class="dash-card"><div class="dash-card-head"><div><h2>Standby configuration</h2><p>The secondary is overwritten during a full synchronization and should not receive independent writes.</p></div></div><form method="post" action="{{ $baseUrl }}/admin/database-replication/configure"><input type="hidden" name="_token" value="{{ $csrfToken }}"><div class="settings-grid"><label><span>Secondary driver</span><select name="secondary_driver"><option value="mysql" {{ $replication['secondary']['driver']==='mysql'?'selected':'' }}>MySQL</option><option value="sqlite" {{ $replication['secondary']['driver']==='sqlite'?'selected':'' }}>SQLite</option></select></label><label><span>SQLite standby path</span><input name="sqlite_path" value="{{ $replication['secondary']['sqlite']['path'] }}" placeholder="storage/database/standby.sqlite"></label><label><span>MySQL host</span><input name="mysql_host" value="{{ $replication['secondary']['mysql']['host'] }}"></label><label><span>MySQL port</span><input name="mysql_port" value="{{ $replication['secondary']['mysql']['port'] }}"></label><label><span>MySQL database</span><input name="mysql_database" value="{{ $replication['secondary']['mysql']['database'] }}"></label><label><span>MySQL username</span><input name="mysql_username" value="{{ $replication['secondary']['mysql']['username'] }}"></label><label class="wide"><span>MySQL password</span><input type="password" name="mysql_password" placeholder="Leave blank to keep the saved password" autocomplete="new-password"></label></div><div class="settings-switches"><label><span><b>Enable standby replication</b><small>Allows manual synchronization and recovery actions.</small></span><input type="checkbox" name="enabled" value="1" {{ $replication['enabled']?'checked':'' }}></label><label><span><b>Automatic emergency failover</b><small>Use the standby when the primary cannot connect. Review and promote deliberately afterward.</small></span><input type="checkbox" name="automatic_failover" value="1" {{ $replication['automatic_failover']?'checked':'' }}></label></div><footer class="replication-actions"><button class="btn primary" type="submit">Test and save</button></footer></form></section>
<section class="dash-card"><div class="dash-card-head"><div><h2>Database-independent recovery access</h2><p>Configure a separate emergency credential that works even when the primary database and normal Admin CP authentication are unavailable.</p></div><span class="status-pill {{ $recoveryConfigured?'success':'muted' }}">{{ $recoveryConfigured?'Configured':'Not configured' }}</span></div><div class="replication-card-body"><div class="replication-alert {{ $forcedSecondary?'danger':'success' }}"><b>{{ $forcedSecondary?'Forced standby mode active':'Primary-first mode' }}</b><span>Emergency console: <code>{{ $baseUrl }}/recovery/database</code></span></div><form method="post" action="{{ $baseUrl }}/admin/database-replication/recovery-access"><input type="hidden" name="_token" value="{{ $csrfToken }}"><div class="settings-grid"><label><span>New recovery password</span><input type="password" name="recovery_password" minlength="12" autocomplete="new-password" placeholder="At least 12 characters"></label><label><span>Confirm recovery password</span><input type="password" name="recovery_password_confirmation" minlength="12" autocomplete="new-password"></label></div><footer class="replication-actions"><button class="btn primary" name="action" value="save" type="submit">Save recovery credential</button>{% if $recoveryConfigured %}<button class="btn danger" name="action" value="disable" type="submit" onclick="return confirm('Disable database-independent recovery access?');">Disable access</button>{% endif %}<a class="btn" href="{{ $baseUrl }}/recovery/database" target="_blank" rel="noopener">Open emergency console</a></footer></form><p class="help-text">The emergency console uses a separate secure session, filesystem audit log, rate-limited authentication, and does not query the members table.</p></div></section>
<section class="replication-grid"><article class="dash-card"><div class="dash-card-head"><div><h2>Synchronize standby</h2><p>Replace the standby with a verified copy of the active primary.</p></div></div><div class="replication-card-body"><p>This performs a full table copy, preserves record IDs, and verifies row counts before reporting success.</p><form method="post" action="{{ $baseUrl }}/admin/database-replication/sync" onsubmit="return confirm('Overwrite the standby with the current primary database?');"><input type="hidden" name="_token" value="{{ $csrfToken }}"><button class="btn primary" type="submit">Synchronize now</button></form></div></article><article class="dash-card danger-card"><div class="dash-card-head"><div><h2>Recovery and promotion</h2><p>Destructive high-availability operations.</p></div></div><div class="replication-card-body"><form method="post" action="{{ $baseUrl }}/admin/database-replication/rebuild-primary"><input type="hidden" name="_token" value="{{ $csrfToken }}"><label>Type <b>REBUILD PRIMARY</b><input name="confirmation"></label><button class="btn danger" type="submit">Rebuild primary from standby</button></form><form method="post" action="{{ $baseUrl }}/admin/database-replication/promote"><input type="hidden" name="_token" value="{{ $csrfToken }}"><label>Type <b>PROMOTE SECONDARY</b><input name="confirmation"></label><button class="btn danger" type="submit">Promote standby to primary</button></form></div></article></section>
<section class="dash-card"><div class="dash-card-head"><div><h2>Replication history</h2><p>Recent full synchronization attempts.</p></div></div><div class="acp-table-wrap"><table class="acp-table"><thead><tr><th>Status</th><th>Direction</th><th>Rows</th><th>Drivers</th><th>Started</th><th>Details</th></tr></thead><tbody>{% foreach $runs as $run %}<tr><td><span class="status-pill {{ $run['status']==='completed'?'success':'muted' }}">{{ $run['status'] }}</span></td><td>{{ $run['direction'] }}</td><td>{{ $run['rows_processed'] }}</td><td>{{ $run['source_driver'] }} → {{ $run['target_driver'] }}</td><td>{{ $run['started_at'] }}</td><td><small>{{ $run['error_message'] }}</small></td></tr>{% endforeach %}</tbody></table></div></section>
{% include 'admin/partials/footer.html' %}