Previous Thread
Next Thread
Print Thread
Hop To
#266871 12/05/2025 4:27 PM
Joined: Oct 2007
Posts: 531
Likes: 13
Addict
Addict
Joined: Oct 2007
Posts: 531
Likes: 13
Is there a way to mirror the database so that queries from the forum would be handled by whichever database was least busy? (I'm thinking of this as a way to distribute the load when we get overwhelmed by bots that create backups on the queries.)


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 8.0.0
Release 20240826
Server OS Linux
Server Load 0.11
Web Server Apache/2.4.37
PHP Version 8.3.11
MYSQL Version 8.0.39
Database Size 1.82 GB
Joined: Apr 2004
Posts: 2,033
Likes: 177
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 2,033
Likes: 177
A mirrored database is a real-time, redundant copy of a primary database used for high availability and disaster recovery. It is a complete backup that stays synchronized with the principal database, allowing for an immediate failover if the primary fails. This mirroring can be set up on the database level, and modern systems often include technologies to automate the process and handle data in different formats, such as delta tables in platforms like Microsoft Fabric.

source:
https://www.sqlshack.com/sql-server-database-mirroring/

It seems like what you're looking for is a specific type of server setup. UBB.threads is a basic PHP script software that points to a single database location. If you require a high-end hardware solution, you probably should contact your hosting company to see what options they have available to you.


current developer of UBB.threads php forum software
current release: UBB.threads 8.0.1 // wip: UBB.threads 8.1.0
isaac @ id242.com // my forum @ CelicaHobby.com

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Selling a Forum?
by ECNet - 10/10/2026 10:54 AM
PHP 8 bug in membermanage.tmpl
by phoenix011235 - 09/08/2026 7:47 PM
Who's Online Now
0 members (), 298 guests, and 124 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260527)