- (C) 2026 by Brain Patchwork DX, LLC.
- 17723954414a20f25a5d96c45978ac1525d11809b6d0a168bbd1d5cd815a395b26ef6a673c.png (1.49 MiB) Viewed 64927 times
#mySQL-evA
Re: #mySQL-evA
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.
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.
Re: #mySQL-evA
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.
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.
Re: #mySQL-evA
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.
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.
Re: #mySQL-evA
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.
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.