Average Ratings 0 Ratings
Average Ratings 11 Ratings
Description
InfiniDB is a column-oriented database management system specifically designed for online analytical processing (OLAP) workloads, featuring a distributed architecture that facilitates Massive Parallel Processing (MPP). Its integration with MySQL allows users who are accustomed to MySQL to transition smoothly to InfiniDB, as they can connect using any MySQL-compatible connector. To manage concurrency, InfiniDB employs Multi-Version Concurrency Control (MVCC) and utilizes a System Change Number (SCN) to represent the system's versioning. In the Block Resolution Manager (BRM), it effectively organizes three key structures: the version buffer, the version substitution structure, and the version buffer block manager, which all work together to handle multiple data versions. Additionally, InfiniDB implements deadlock detection mechanisms to address conflicts that arise during data transactions. Notably, it supports all MySQL syntax, including features like foreign keys, making it versatile for users. Moreover, it employs range partitioning for each column, maintaining the minimum and maximum values of each partition in a compact structure known as the extent map, ensuring efficient data retrieval and organization. This unique approach to data management enhances both performance and scalability for complex analytical queries.
Description
Percona XtraDB Cluster is an open-source, high availability, MySQL clustering solution. It helps enterprises reduce unexpected downtime and data losses, lower costs, and improve performance and scalability in their database environments. PXC supports critical business applications in the most demanding public and private cloud environments. Percona XtraDB Cluster, (PXC), preserves, secures and protects data as well as revenue streams, by providing the highest availability for business-critical applications. PXC can help you reduce costs, eliminate license fees, and meet budget constraints. Our integrated tools allow you to optimize, maintain, monitor, and monitor your cluster. This allows you to get the most from your MySQL environment.
API Access
Has API
No
API Access
Has API
No
Integrations
MySQL
Yes
Pandora FMS
No
Percona Kubernetes Operator
No
Percona XtraBackup
No
ProxySQL
No
Integrations
MySQL
Yes
Pandora FMS
Yes
Percona Kubernetes Operator
Yes
Percona XtraBackup
Yes
ProxySQL
Yes
Pricing Details
No price information available.
Free Trial
No
Free Version
No
Pricing Details
Free
Free and open-source
Free Trial
Yes
Free Version
Yes
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
Yes
Chromebook
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
Yes
Mac
Yes
Linux
Yes
Chromebook
No
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
No
Live Rep (24/7)
Yes
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Types of Training
Training Docs
Yes
Webinars
Yes
Live Training (Online)
Yes
In Person
Yes
Vendor Details
Company Name
Database of Databases
Founded
2000
Country
United States
Website
dbdb.io/db/infinidb
Vendor Details
Company Name
Percona
Founded
2006
Country
USA
Website
www.percona.com/software/mysql-database/percona-xtradb-cluster
Product Features
Database
Backup and Recovery
No
Creation / Development
No
Data Migration
No
Data Replication
No
Data Search
No
Data Security
No
Database Conversion
No
Mobile Access
No
Monitoring
No
NOSQL
No
Performance Analysis
No
Queries
No
Relational Interface
No
Virtualization
No
Product Features
Database
Backup and Recovery
Yes
Creation / Development
No
Data Migration
No
Data Replication
Yes
Data Search
Yes
Data Security
Yes
Database Conversion
No
Mobile Access
No
Monitoring
Yes
NOSQL
No
Performance Analysis
Yes
Queries
Yes
Relational Interface
Yes
Virtualization
No
RDBMS
Backup
Yes
Data Migration
No
Monitoring
Yes
Performance Analysis
Yes
Queries
Yes
Storage Optimization
Yes