MT4 Data Replication Push Service to MySQL – Metatrader 4 Reporting Server Alternative

WE ❤️ DEVELOPERS!

This MT4 Synchronization Service is for brokers, marketers, and developers who require efficient, local access to MT4 data for various applications. 

Brokers can leverage the service to generate customized reports, enabling them to monitor client activity, analyze trading data, and gain insights tailored to their business requirements. 

Developers can use this data to build custom referral and IB payout logic, build Forex risk applications, integrate Forex Marketing Suites, implement custom Prop firm triggers and more.  

The web service functions as a middleware layer between an MT4 trading server and a MySQL database. Its main role is to retrieve and process live trading data from the MT4 server and maintain an up-to-date mirror in the local database for reporting, analysis, and operational monitoring purposes.

MT4 Reporting Server Alternative includes:

• MT4 Manager API Connector: This module connects to the MT4 server using the Manager API, performing secure authentication to access trading data and account management functions.
• Data Synchronization Service: A real-time service that fetches data from the MT4 server and synchronizes it with the local database. 
• Data Transformer: This component structures the raw data retrieved from the MT4 server to fit into the schema of the local database, ensuring consistency across the following tables.

Database Schema and Table Details:

• Groups: Stores user groups and associated trading permissions: Columns: id, group_name, currency, markup, permissions, max_leverage, etc.
• Prices: Contains live price data synchronized from the MT4 server: Columns: id, symbol, buy_value, sell_value, spread, markup, etc.
• Timezone: Keeps track of the server’s current time and timezone: Columns: id, server_time, timezone_offset, timezone_name.
• Trades: Stores all trades for each user, including active and closed trades: Columns: id, user_id, trade_type, symbol, price_open, price_close, volume, timestamp_open, timestamp_close, etc.
• Users: Holds client data with personal and trading account details: Columns: id, username, email, group_id, balance, address, registration_date, account_status, etc.
• Equity: Contains equity data for each user: Columns: id, user_id, live_equity, highest_equity, lowest_equity, timestamp.
• Daily Reports: Provides end-of-day summaries of trading activity: Columns: id, report_date, total_volume, balance, active_users, closed_positions, etc.
• Securities: Lists all securities available on the platform with settings and markups: Columns: id, symbol, security_name, type, margin, markup, trade_enabled, etc.
• In addition Kenmore Design will add any data-points required for your project.

Synchronization Workflow:

• Data Pull: The service initiates API calls to the MT4 server at set intervals or following the server pre-defined API retrieving data changes across trades, users, equity, and other pertinent tables.
• Data Transformation and Validation: Incoming data is transformed to fit the local schema. Additional validation ensures data consistency, removing or flagging any anomalies.
• Database Update: The processed data is inserted or updated in the local database, maintaining a mirrored state of the MT4 server.
• Synchronization Speed: In general the sync speed varies. It depends on the Trading server limitations, geographical distances, network throughput, and general requirement of the client. It is possible to synchronize Equity values faster than updating User info for example. 
• Post-Disconnect catch up: In case the connection with database or trading server is lost the server will go back in time and will catch up/re-sync missing data updates.
• Logs: the system keeps logs for troubleshooting.
• Notifications: The system can post critical notification to a Slack channel or provide web-hooks for events.

Get access to documentation and consultation for the MT4 Data Push

Expert knowledge, replication push service details, documentation, pricing, guides, resources, and tools.

Get started

Choose Metatrader 4 PUSH Database Replication Service for hassle-free data access with no per-use or usage limitations — all for a simple flat monthly fee. With over 15 years of expertise and a reputation for reliability, we’re the trusted choice to keep your business data effortlessly synchronized and ready to power your custom applications and reports.