Insert user accounts and dynamically synchronize records across two active database instances
Database Node Monitor
Server 1 (Local Node)localhost
Online
Server 2 (Sync Endpoint)s1-nnvp.crazzydns.com
Online
Schema Setup (SQL)
Ensure the `users` table exists on both database nodes. You can run:
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(100) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);