LW IT Solutions
« Blog Overview

Multi-WAN Failover with the Ubiquiti UniFi UCG-Fiber: Setup, Grounding and Configuration

· 2 comments

Achieving 100% network uptime requires a solid Multi-WAN strategy. The Ubiquiti UniFi UCG-Fiber is an excellent gateway for managing multiple internet sources. This guide covers how to set up a robust three-tier failover system. The Setup Architecture A highly resilient network requires diverse connection types to prevent a single point of failure. A reliable architecture […]

Read article →

Extracting Specific Tables from Massive SQL Dumps using PHP

· 2 comments

Sometimes only one database or a specific set of tables needs to be restored from a multi-gigabyte (e.g., 5GB) MySQL dump. Opening a file of that size in standard text editors like VS Code or Notepad++ usually leads to extreme lag or a complete system crash. Instead of struggling with desktop software or complex command-line […]

Read article →

UniFi Zone Matrix: Policy States for Server, CCTV and IoT Networks

· 2 comments

Managing firewall rules using traditional LAN IN / LAN OUT lists can be a nightmare, especially when a network grows to include IoT devices, cameras, and private servers. Ubiquiti has revolutionized this process in their UniFi ecosystem with the Zone Matrix, a visual representation of the firewall policies. As the referenced screenshot shows, the Zone […]

Read article →

How to Automate Raspberry Pi Backups to a UniFi NAS

· 2 comments

Anyone running self-hosted services, home automation, or custom web applications on a Raspberry Pi knows its Achilles’ heel: the microSD card. SD cards are prone to corruption, especially with heavy database read/write cycles. To build a truly resilient architecture, the data cannot live solely on the Pi. It needs to be offloaded to a redundant, […]

Read article →

How to Control Tuya Devices Locally in Home Assistant

· 2 comments

Anyone who has dabbled in smart home tech probably owns a Tuya-based device. They are affordable, ubiquitous, and available under hundreds of different brand names. However, they share one major flaw: a heavy reliance on the Tuya Cloud. Relying on a cloud server means latency, potential downtimes, and privacy concerns. If the internet goes down, […]

Read article →

How to Safely Host Public Servers on a UniFi Network

· 2 comments

Hosting a public accesible server—like a Raspberry Pi running a web server, Nextcloud, or a custom application—is a great way to take control of one’s own data. However, exposing a device on the local network to the internet introduces significant security risks. If that Raspberry Pi gets compromised, a flat network architecture gives the attacker […]

Read article →