MDACA PDB is a performance database, configured for enterprises, leveraging 20+ years of Big Data experience.
The MDACA Performance Database (PDB) is a MySQL-based solution and is part of the integrated MDACA (Multiplatform, Data Acquisition, Collection, and Analytics) suite. MDACA PDB combines best-in-class Enterprise Database capabilities within a secure, unified, Big Data suite of applications supporting centralized near real-time acquisition, storage, and single view access to enterprise-wide repositories across data fabric architectures. It is purpose-built for ingestion data needs, taking into account purpose, cost, speed, retention policies, retrieval capabilities, disaster recovery, and security in support of enterprise big data.
MDACA Performance DB
The MDACA Performance DB is an enterprise MySQL DB that has been optimized and integrated with MDACA core technology add-ons designed for deployments by government agencies and commercial enterprises. Enhanced and fully compatible, MDACA PDB is a drop-in replacement for any MySQL database. It provides superior performance, scalability, instrumentation, and concurrency for the most demanding workloads, delivering robust capabilities with optimized performance, scalability, and availability.
MDACA PDB offers purpose-built databases by enhancing proven technology to meet a wide range of business needs. Our technology is designed to augment and work in conjunction with cloud-based environments, providing a cloud agnostic solution that can take advantage of the deployment platform. MDACA PDB is designed to support cloud adjacent technology with integrated connectivity across the enterprise for optimal performance and cost.
Purpose-Built, Pre-Configured, Cloud-Efficient Databases
Supporting Big Data initiatives across the enterprise, we understand the need for databases to solve a wide range of business cases in an enterprise ecosystem. The MDACA Performance DB’s are online transaction processing (OLTP) based databases designed and optimized for specific purposes in an enterprise data architecture. Built purposefully in support of high transaction data processing for enterprise applications, MDACA PDB accounts for cost, speed, retention policies, retrieval capabilities, disaster recovery, and security.
We make the process easy with cloud and cloud-adjacent optimized configurations designed to meet enterprise high ingestion and transaction needs.
An enterprise-grade solution designed for government and commercial entities.
High Ingestion (HI)
The MDACA PDB High Ingestion (MDACA PDB, HI) is designed to receive a high volume of data from across the enterprise. Designed to support the ingestion of billions of transactions on a daily basis while meeting the enterprise need for data ingestion, data replication, and data security playing a critical part in the enterprise data management strategy. Designed for high volume ingestion, supporting organizations with requirements to obtain data from multiple sources such as legacy systems, databases, ERP, CRM, files, HTTP links, IoT data, logistics data, and others into enterprise data repositories.
Key MDACA PDB, HI features include:
- Process a large number of transactions per second
- Designed to scale as the ingestion volume grows
- Production ready – be available 24/7/365, with constant incremental backups
The MDACA PDB Transaction, (MDACA PDB, T) is designed to power business applications—everything from the basic metadata stores to critical applications such as financial services, banking, retail, logistics, and healthcare applications. It is designed to be the Transactional Data Store for enterprise applications, providing the database support for day-to-day operations that typically involve inserting, updating, and deleting data.
Key MDACA PDB, T features include:
- Designed to support critical business transactions where a high-level of data integrity is necessary
- ACID compliant to ensure writes to the database either succeed or fail together, maintaining a high level of data integrity when writing data to the database
- Provide indexed data sets for rapid searching, retrieval, and querying
- Support very rapid processing with response times measured in milliseconds
- Production ready – be available 24/7/365, with constant incremental backups
Each purpose-built database configuration is designed to easily support your needs and maximize value while taking into account a number of hardware and software variables/needs. MDACA PDB provides resilience and security to power big data solutions and is the ideal performance database in support of high-speed ingestion supporting billions of transactions on a daily basis. It is optimized to take advantage of a wide range of cloud native configurations in addition to database optimizations.
Key features/benefits of MDACA PDB include:
Includes advanced, fully-enabled, external authentication, audit logging, and threadpool scalability features that are only available in Oracle’s commercial MySQL Enterprise Edition.
Easily scale out clusters in order to ensure data delivery. Vertical scalability and server consolidation to provide the capability to achieve hundreds of thousands of input/output (I/O) operations per second.
Single Sign-on Support
Easily integrate with Lightweight Directory Access Protocol (LDAP) providers. By leveraging LDAP, MDACA PDB simplifies the task of user administration as individual user accounts are managed directly by LDAP.
Advanced Visibility into Database Activity
Detailed query logging with per-query statistics about locking, I/O, and query plan, as well as performance and access counters per-table, per-index, per-user, and per-host.
Advanced Backup/Replication Options
Support the enterprise with advanced and full features for backup/replication options.
Database Driver Options
Provides advanced driver options in support of migration of other databases to MySQL, in addition to supporting database connectivity across the enterprise.
Enterprise Data Encryption at Rest
Easily secure your data without impacting operations. Protect sensitive data in support of a wide variety of use cases including ecommerce, financial, logistics, and healthcare.
Data Masking Features
Provides advanced data masking to obscure sensitive information. Strike a balance between data compliance and business demands.
Enterprise Management Tools Add-ons
Monitor the health of your database infrastructure, understand patterns in database behavior, and manage and improve the performance of your databases.
Enterprise Data Sync Tools Add-ons
Advanced data sync tools designed for the cloud and support of syncing your enterprise data to the data lake.
Database Driver Options
We understand the needs of an enterprise big data ecosystem to include accessing and querying the data. The MDACA PDB provides standards-based, MySQL drivers for JDBC, ODBC, and .Net for data scientists, business analysts, developers, and applications/tools supporting JDBC or ODBC connectivity to access their database.
- NET Driver for MySQL (Connector/NET)
- JDBC Universal DB Driver for MySQL (Connector/J)
- C++ Driver for MySQL (Connector/C++)
- ODBC Driver for MySQL (Connector/ODBC)
- js Driver for MySQL (Connector/Node.js)
- C Driver for MySQL (Connector/C)
- JDBC Driver for MySQL (Connector/J)
- Python Driver for MySQL (Connector/Python)
- C API for MySQL (mysqlclient)
In addition, the MDACA platform provides a JDBC MySQL Universal Database driver, specifically developed for MDACA PDB and designed to support legacy migration.
The MDACA JDBC MySQL Universal Database driver is designed to minimize the effect on legacy applications leveraging JDBC and to support incremental migration of the query code used by applications, reporting tools, AI/ML engine, and ETLs as well as user ad hoc queries, allowing phased migrations from databases such as Oracle, MS SQL, DB2, and others to MDACA PDB MySQL-based databases.
LDAP, PAM, Kerberos and Single Sign-On
The MDACA PDB database provides Single Sign-On (SSO) support through leveraging the Lightweight Directory Access Protocol (LDAP) to simplify the credential management process. LDAP is the industry standard for accessing distributed directory services such as Active Directory and Open LDAP directories store entries (which may include people, groups, organizational units, and other items) in a hierarchical arrangement.
Leveraging LDAP adds another layer of security access to your database, meeting modern cyber security needs while simplifying user administration. With individual user accounts managed directly by LDAP, access to the MDACA PDB is managed by mapping LDAP users, group roles, and permissions.
Additionally PDB supports Privileged Access Management (PAM)-based authentication plugin, providing the capability to integrate PDB with SSO and two-factor authentication (2FA) protocols such as Kerberos.
Works in the Cloud, Cloud-Adjacent, Edge, and On-Prem
The MDACA PDB database is designed to support cloud deployments as well as regionally distributed, cloud-adjacent, hybrid multi-cloud solutions. It can be easily deployed for cloud providers such as AWS, Google Cloud, Microsoft Azure, and others as well as within cloud-adjacent data centers such as Equinix.
Advanced Near Real-Time Data Replication
MDACA near real-time data replication is achieved by leveraging MDACA Sync Guard, designed to ensure that data across your enterprise ecosystem can be synchronized, kept consistent in near real-time that is flexible and configurable to capture and sync data changes.
Designed with flexibility of configuration in mind, enterprises can capture data from singular/multiple primary database(s) into a single or multiple sync database(s) with granular control over syncing specific tables or the entire database. MDACA Sync Guard is designed to support high transaction. high ingestion, and high volume environments meeting advanced big data enterprise needs. Some of the features/values of MDACA Sync Guard include:
- Facilitates near real-time data movement and delivery
- Provides disaster recovery capabilities and can sync data to multiple standby databases
- Minimizes the impact of unplanned outages and supports the migration and/or upgrade of databases with minimal downtime
- Supports data query and log-based change data capture w/ transactional integrity for big data integration
- Provides the management and monitoring tools with analytics and metrics in support of your enterprise data synchronization and replication efforts.
MDACA PDB Backup Manager
MDACA PDB Backup Manager (PDB BMAN) creates enterprise database, non-blocking backups that complete quickly and reliably while supporting uninterrupted transaction processing to provide enterprises with higher uptime due to fast restore process.
A summary of features provided by the PDB Backup Manager includes the following:
- Create hot backups without pausing your database
- Move tables between servers on-line
- Perform throttling based on the number of IO operations
- Make incremental backups
- Create new replication replicas easily
- Skip secondary index pages and recreate them when a compact backup is prepared
- Stream compressed backups to another server
- Backup without adding load to the server
- Can export individual tables even from a full backup
MDACA Performance Monitor
MDACA Performance Monitor (PM) provides an enterprise database monitoring and management solution for the MDACA PDB. It allows database administrators to observe the health of your database systems, explore new patterns in their behavior, troubleshoot them, and perform database management operations. MDACA PM provides the tools to find and fix database issues quickly and enhance the performance of your business-critical applications.
The MDACA Performance Monitor provides monitoring, alerting, notifications, historical analysis, and reporting tools supporting the overall management of your enterprise PDB assets.
Key features include:
- Database Monitoring – Monitor and identify slow-running queries and analyze the root cause behind the performance lags. Monitor your environment, such as the services, infrastructure, and critical issues.
- Query Analytics – Tools and dashboards that provide insights on how queries are executed and their performance metrics. Analyze database queries over time and leverage key metrics such as response times and numbers of rows to optimize database performance.
- Alerts – Comprehensive alerting through built monitoring alerts as well as prodigy tools to create custom alerts tailored to meet your enterprise business needs.
- Historical Query Analysis – Obtain insight on query plan choice and performance. Simplify performance troubleshooting by helping database administrators quickly find performance differences caused by query plan changes.
MDACA PDB and the MDACA Platform
The MDACA PDB component of the MDACA product suite provides flexibility and extensibility designed to support simple to complex solutions taking advantage of both software and hardware configurations optimized for the cloud and on-prem. Designed to work closely with the MDACA big data platform ingesting data from various sources by providing industry leading, easy to use, well-rounded, scalable, fault tolerant solutions to handle the high-throughput data ingestion needs for the enterprise in support of data fabric and data federation needs as well as a wide range of end user productivity tools.
MDACA combines best-in-class capabilities into a secure, unified, Big Data suite of applications with centralized near real-time acquisition, storage, and single view access to enterprise-wide repositories across data fabric architectures. Regardless of your data’s location and format, you can run your analytical and reporting workloads on our cloud adjacent and cloud-ready MDACA platform without worrying about scalability and performance.
MDACA Quick Start Program
We understand organization needs will differ based on business needs, budgets, interconnected partners, and ramp up timelines and requirements. The Quick Start Program is designed in collaboration with our industry partners to provide the agile approach to support the quick secure establishment of the baseline approach to meet your data access needs and support the onboarding and training of your teams.
Additionally it is designed to provide your team’s direct access to our product and integration teams as part of the MDACA customer experience.
The MDACA team is ready to support your team, your needs and your customers’ needs. We bring in the expertise as big data technology integrators and enterprise solution providers. As technology integrators, we provide value added experience and services. By offering a range of integration services we enable our clients to design solutions that meet their precise enterprise data needs for security, collaboration, and virtualization.
The MDACA engineering and professional services teams adhere to the process standards established by the International Organization for Standardization (ISO), Information Systems Audit and Control Association (ISACA, Capability Maturity Model Integration (CMMI Institute)), and National Institute of Standards and Technology (NIST). We are certified annually by an accredited 3rd party audit firm.
Training and Support
Our training and support program can be tailored to meet your needs. In addition to our staff that specialize in big data solutions, we have direct access to our industry partnerships that provide us access to a wide pool of resources that can tailor training specifically to your business and team’s needs. We offer a number of options in support of your training needs.