Author: Clustrix Support

Feed: Clustrix Blog. Author: Ivan Zlatoustov. The newest release of MariaDB SkySQL includes major new capabilities, such as new topologies for distributed SQL and clustering, and cloud data warehousing with massively parallel processing and HA.  With this release, we’ve also expanded SkySQL Monitoring, adding support for these new topologies and extending observability of SkySQL services.Whether operating a simple database-backed application or a very complex enterprise application, SkySQL Monitoring provides a right-sized view of database status and metrics. The default SkySQL Monitoring dashboard is an overview of your active services, available as a card or list view, with more details just ... Read More

Feed: Clustrix Blog. Author: Shane Johnson. This article first appeared in InfoWorld. It is reprinted with permission. © IDG Communications, Inc., 2020. All rights reserved How MariaDB achieves global scale with Xpand. Xpand is now available in MariaDB SkySQL adding distributed SQL for scalability and elasticity in the cloud. As information and processing needs have grown, pain points such as performance and resiliency have necessitated new solutions. Databases need to maintain ACID compliance and consistency, provide high availability and high performance, and handle massive workloads without becoming a drain on resources. Sharding has offered a solution, but for many companies ... Read More

Feed: Clustrix Blog. Author: Saravana Krishnamurthy. Modern applications require robust data models that span from traditional transactions to business analytics, to complex machine learning and AI algorithms with varying scalability requirements. SkySQL eliminates the need for applications developers to mash together a myriad of database technologies to meet their evolving needs.SkySQL now runs the latest version of MariaDB Platform X5. In particular, this major release of SkySQL adds distributed SQL for write scalability with strong consistency, and distributed cloud data warehousing with massively parallel processing. In this blog, I’ll highlight some of the new cornerstone features of this release – ... Read More

Feed: Clustrix Blog. Author: Ralf Gebhardt. MariaDB Connector/R2DBC is now a release candidate (RC). MariaDB Connector/J has long been a popular choice for Java application developers connecting with MariaDB, and now with Connector/R2DBC we have support for non-blocking, reactive Java programming with MariaDB databases.Connector/R2DBC implements the R2DBC 0.8.2 specification. R2DBC specifies a service-provider interface (SPI) to enable integration of databases into systems that use reactive programming models. Reactive programming takes the existing Callbacks-Futures based asynchronous paradigm further with a new Publisher-Subscriber based asynchronous model. A publisher-subscriber is a push-pull model rather than the classic asynchronous model that is push-consume. A ... Read More

Feed: Clustrix Blog. Author: Faisal Saeed. MariaDB MaxScale is an advanced database proxy, firewall, and query router that provides automatic failover for high availability in MariaDB replication deployments with MariaDB Server. Automatic failover occurs when MaxScale automatically promotes a replica server to be the new primary server when a primary server fails. Cooperative monitoring is one of the many important new features in MaxScale 2.5. With cooperative monitoring, MaxScale nodes automatically designate a new primary MaxScale node in the event the designated primary MaxScale node in a cluster goes down.Automatic Failover MaxScale 2.2 – 2.4 In MaxScale versions 2.2 – ... Read More

Feed: Clustrix Blog. Author: Peter Friedenbach. What we tested: Relative performance of MariaDB vs MySQLHow we tested: Multi-statement, transaction processing workload (Sysbench 90:10)Where we tested: Amazon AWS EC2 and RDS, large to 12xlarge instancesWhat we conclude: MariaDB provides superior performance on commodity cloud hardware for real business workloads. Looking back in MariaDB Server’s family tree, we find its ancestor, MySQL Server. MariaDB Community Server and MySQL Server Community Edition, both Open Source, have over the years been packaged for many of the same Linux distributions, powering application stacks behind hundreds of popular websites and applications. And both are available in ... Read More

Feed: Clustrix Blog. Author: Rob Hedgpeth. Nearly a year ago, I accepted an offer to work on the developer relations team at MariaDB Corporation. I remember feeling pretty apprehensive and a little overwhelmed leading up to my first day. To be completely transparent, I didn’t have any previous experience using MariaDB. My first project was to write an application using React.js and Node.js built on MariaDB – oh and I had to present it in front of the entire company in two weeks. No big deal, right?Sure, throughout my years as an application developer I’d spent time working with relational ... Read More

Feed: Clustrix Blog. Author: Rupert Harwood. Database professionals will often groan when someone utters the word migration – it can be complex to move a database from one platform to another. There is one type of migration that need not cause consternation – the “lift and shift”. Lift and shift migrates an application or operation from one environment to another without the need to redesign the application or change operations workflow. Migrating from an on-prem MariaDB Server deployment to MariaDB SkySQL is a lift and shift, so is migrating from Amazon RDS for MariaDB or from Microsoft Azure for MariaDB ... Read More

Feed: Clustrix Blog. Author: Rob Hedgpeth. With the release of MariaDB Platform X5, we’ve added new tooling and features that offload development complexity so developers can focus on creating innovation solutions. MariaDB Platform X5 includes MariaDB Enterprise Server 10.5, pluggable engines (such as InnoDB, ColumnStore, MyRocks, Spider and now Xpand), connectors, and the MaxScale database proxy. And because there’s so much that’s included with the MariaDB Platform X5 release I figured it might be best to start with the high points before drilling down into more details in the future.Added aggregate JSON functions New Temporal Tables features Enhanced SQL Kafka ... Read More

Feed: Clustrix Blog. Author: Ralf Gebhardt. Best practice for enterprise data management is to use data-at-rest encryption for storing highly sensitive data on storage media, with encryption keys safely stored in an external key management system. HashiCorp Vault has become an increasingly popular tool for this purpose, so we are excited to announce that MariaDB Platform X5 can integrate directly with HashiCorp Vault.The HashiCorp Vault Encryption Plugin (hashicorp_key_management) enables using HashiCorp Vault to manage MariaDB’s data-at-rest encryption keys. hashicorp_key_management supports both the open source and enterprise version of HashiCorp Vault. HashiCorp Vault can be used as the key management system ... Read More