BrainPatchworkDX.com

FPC MySQL Enterprise/Government ready. Fork - Operator Manual

Version: 8.0.33-Enterprise-v5
Engine: DXSock6 (High-Speed Communications)
Security: AES-256 (Blowfish-448) Encryption at Rest

Introduction

Our FPC MySQL Fork is a high-performance, standalone MySQL-compatible server environment developed using Free Pascal and Delphi. It provides a specialized storage engine with ACID durability via Write-Ahead Logging (WAL) and native encryption for government-grade deployments.

Security Features

Encryption at Rest: All data written to .dat files is encrypted using 448-bit Blowfish keys derived from the master secret.
ACID WAL: Every INSERT or UPDATE is logged to our .wal file before being committed to memory, ensuring no data loss during power failures.

Persistence Lifecycle

The server loads state from enterprise.dat on startup. On a clean shutdown, the memory state is encrypted and flushed back to the data file, and the WAL is cleared.

Handshake Diagnostics (New in v5)

The client now reports specific handshake failures. If a connection fails, check the error code:

Error 1049 (ER_BAD_DB_ERROR): The database requested does not exist on the server.
Error 1045 (ER_ACCESS_DENIED_ERROR): Anonymous login was attempted but is disabled.

Interactive Commands

Standard SQL: Statements must end with a semicolon ";".

Script Execution: Run local SQL files using the @ prefix.

Advanced SQL Scripting Engine

The client's @ engine supports:

Multi-line SQL: Statements spanning multiple lines in the .sql file.
Sequential Execution: Each statement is verified for a Query OK response before the next is sent.
Local Context: The script runs using the permissions and database context of the current session.

© 2023 Brain Patchwork DX, LLC. - FPC/DXSock6 Project.