How SEMSA Runs 50+ MariaDB ERP Databases on Database Mart
Since February 2024, SEMSA has built a stable, multi-server hosting footprint on Database Mart—a USA hosting provider—to host SEM 7.0 for dozens of businesses. VPS and dedicated server hosting carry production MySQL/MariaDB workloads with strong uptime, advance notice on migrations, and no data loss on their most recent platform move. For SEMSA, that partnership is the layer that keeps daily accounting, sales, inventory, and billing online for clients in Guatemala and the wider region.
SEMSA (Sistema Empresarial, Sociedad Anónima) develops and supports ERP SEM 7.0—the multi-company, multi-branch Sistema Empresarial platform marketed from Guatemala since the 1990s. The desktop product is built with Harbour and FiveWin for Harbour (FWH); clients typically connect from Windows workstations while database and application services run on Windows or Linux servers, including cloud VPS. SEMSA also provides MySQL/MariaDB administration, server management, and related IT services for customer deployments.
Day-to-day operations depend on Database Mart hosting: MySQL/MariaDB ERP databases, application services, and related workloads run on a fleet of 10 servers (six Windows VPS, three Linux VPS, and one NVMe dedicated server). Client SEM 7.0 installations connect throughout the working day for accounting, sales, inventory, and invoicing—so stability, predictable support, and smooth migrations matter as much as raw query throughput.
The Business Challenge
SEMSA hosts more than 50 client databases that power live ERP operations for many businesses. A single Database Mart VPS acts as a central MariaDB server for a large share of that footprint, while additional VPS and dedicated resources spread related services across the rest of the fleet. When accounting, sales, inventory, and billing run continuously during business hours, even brief instability shows up immediately in client workflows.
Before Database Mart, SEMSA relied on DigitalOcean. Carlos Sincuir’s team found it more expensive, harder to configure, and slower to reach for support when production issues needed a fast answer. They needed server hosting from a hosting provider that could:
- Keep MariaDB stable under high daily query volume and dozens of concurrent ERP sessions
- Support a growing mix of Windows and Linux workloads without juggling incompatible provider tooling
- Deliver responsive, high-quality support when database or platform questions block customer operations
- Communicate platform improvements and migrations early enough to plan cutovers with confidence
- Reduce overall server operating cost compared with the previous cloud provider
Because SEMSA both sells ERP software and operates the infrastructure behind it, provider choice directly affects customer trust. USA hosting with clear upgrade paths—from VPS to dedicated NVMe—mattered as much as day-one performance.
The Solution
SEMSA standardized on Database Mart for ERP database hosting and surrounding services. Today the company runs 10 servers under its main account—six Windows VPS, three Linux VPS, and one dedicated server with NVMe storage—with ERP databases and related services distributed across the fleet to match workload type and capacity.
MariaDB remains the core: client SEM 7.0 installations connect daily for operational data entry and reporting. One reference database host (173.208.xxx.xxx) illustrates the steady load SEMSA manages; another production server is registered under a separate Database Mart account (163.123.xxx.xxx) associated with an additional contact email, reflecting how SEMSA segments infrastructure while staying on the same platform.
Results And Impact
SEMSA reports a consistently positive experience: servers have stayed stable, support has been fast and high quality, and platform migrations were communicated well in advance. On the reference host at 173.208.xxx.xxx, the system had been running for more than 200 days without a restart at the time metrics were collected in October 2026—while still serving heavy daily ERP traffic.
At a glance, SEMSA’s Database Mart deployment supports:
Reference Server Workload
One host in the fleet runs 12 databases and serves roughly 20 to 30 simultaneous users during peak hours. Carlos provided accumulated totals since the last restart and approximate daily averages for core ERP operations (accounting, sales, inventory, and invoicing):
Metrics from October 2026 for one reference MariaDB host. IP addresses are redacted in this story.
| Metric | Total Since Last Restart | Daily Average |
|---|---|---|
| Queries | 94,725,446 | ~444,000 |
| Inserts | 3,344,987 | ~15,700 |
| Updates | 1,511,457 | ~7,100 |
| Deletes | 1,738 | ~8 |
| Total write operations | 4,858,182 | ~22,800 |
| Commits | 279,477 | ~1,300 |
| Peak concurrent connections | n/a | 45 |
Compared with their previous provider, SEMSA highlights lower operating cost, faster support, and reliable performance across the multi-database ERP estate on Database Mart server hosting. Carlos has recommended the same USA hosting provider to colleagues, several of whom also moved production workloads to Database Mart.
After years of working with Database Mart VPS servers, I can recommend them without hesitation. I have already recommended them to colleagues, and they have chosen Database Mart’s services as well.
Carlos Sincuir Development, SEMSA