⚙ī¸ Multi-Terminal & Database Manager

Database Configuration & Management

Manage Local MariaDB, Store LAN Network, Cloud MySQL, or MongoDB Cloud Sync

MariaDB Portable Engine (Port 3307):
Offline ○
ACTIVE DB: ebuddylk_posdemo LAN IP: 23.227.187.189
⚡ Standalone Local Database Hub: This computer runs its internal portable MariaDB database engine on port 3307. Zero internet required. Manage multiple databases, import/export backups, and configure standalone checkout below.
ebuddylk_posdemo
Active Database
--
Total Tables
--
Total Records
--
Database Size
Database Name Tables Total Rows Disk Size Collation Actions
Loading local databases...
🌐 LAN Multi-POS Mode: Share one central database across all cash counters in your store over local Wi-Fi or router network. One computer is the Main Server, and other counters (Counter 2, Counter 3, Kitchen Display) connect as Clients.

đŸ–Ĩī¸ Exact Server Details to enter on Client PCs:

Enter these exact values into the "This PC is Client Counter" screen on Counter 2 and Counter 3:

Server IP: 23.227.187.189
Port: 3307
Database Name: ebuddylk_posdemo
LAN Username: posnetwork
LAN Password: pos12345
💡 Crucial: All cash counters on your LAN network MUST use the exact same Database Name (ebuddylk_posdemo) so products, invoices, and stock updates sync instantly!
☁ī¸ Direct Cloud Web Server Mode: Connect all POS terminals directly to a central cloud database over port 3306.
⚠ī¸ Speed Notice: If your web server is overseas or has network latency, direct queries on every screen action will slow down cashier checkout.
⚡ Recommended: For instant 0.01s billing with automatic cloud backup and syncing, use Tab 4 (Cloud Sync & Backup)!
☁ī¸ Local-First + Background Cloud Sync: Keep lightning-fast 0.01s billing locally on your PC, while a silent background engine automatically pushes every sale, receipt, and line item to your cPanel Web Server MySQL (phpMyAdmin) or MongoDB Atlas! You can also pull updated products and prices anytime.
--
Total Local Sales
--
Backed up in Cloud
--
Pending Sync
Active
Sync Engine

Automatically push new sales to your Web Server / MongoDB in the background

📁 Google Drive Automated Database Backup: Protect your store's point-of-sale data with automatic cloud backups. Use Option 1 (Local Google Drive Desktop / OneDrive sync folder for zero-setup ease), Option 2 (Direct Google Drive Cloud API with Service Account credentials for headless server uploads), or Both for ultimate peace of mind.
ebuddylk_posdemo
Target Database
Never
Last Backup Time
--
Last Backup Size
Option 1 & 2
Active Backup Mode

Keep your complete database dumps safely stored in Google Drive

📁 Option 1: Local / Synced Cloud Folder ZERO SETUP • FASTEST

Dumps are saved directly into your local Google Drive folder (e.g. G:\My Drive\POS_Backups), Microsoft OneDrive, or Dropbox. Your desktop cloud client automatically syncs the file to Google Drive in real time without any API keys!

Older backups in this folder beyond this count are automatically purged to save disk space.
Reduces backup file size by ~85% (faster sync)
☁ī¸ Option 2: Direct Google Drive Cloud API DIRECT API v3 • NO DESKTOP APP

Directly uploads database dumps to your Google Drive account over the official Google Drive API v3. Ideal if Google Drive desktop is not installed or for multi-counter setups.

Tip: Open your folder in Google Drive and copy the alphanumeric ID from the URL bar.
ℹī¸ Quick 3-Step Guide: How to get your Google Drive Service Account JSON
⏰ Automated Daily Backup Schedule

The POS desktop engine automatically executes this backup every day at your scheduled time in the background.

(Daily closing time)
← Return to POS Login