Author: Clustrix Support

Feed: Clustrix Blog. Author: Shane Johnson. DBaaS offerings like Amazon RDS require you to choose from a predefined set of instance types, and they’re often based on the underlying infrastructure-as-a-service (IaaS) instance types. In the case of RDS current generation instance types, we have the T3 and M5 general-purpose classes as well as the R5 and X1E/X1/Z1D memory-optimized classes. This is a broad range of instance types, but as we know, every database is unique.In general, databases tend to benefit from more memory rather than more compute as they will often become IO bound first. The optimal amount of compute ... Read More

Feed: Clustrix Blog. Author: Shane Johnson. Until today, there have always been difficult trade-offs between running a database on public or private infrastructure (e.g., Amazon EC2) and using a database-as-a-service (DBaaS).You can run databases on premises or on cloud infrastructure. You can make sure they precisely match your specific requirements, but it requires effort. You can use a DBaaS such as Amazon RDS. You’ll benefit from self service and automation – but you’ll pay a steep price for it. You’ll be forced to adhere to the lowest common denominator (like everyone else using it), and you’ll be bound by artificial ... Read More

Feed: Clustrix Blog. Author: Anders Karlsson. Set operators are the SQL operators that deal with combining, in different ways, different result sets. Say you have two different SELECTs that you want to combine into a single result set, the set operators come into play. MariaDB has been supporting the UNION and UNION ALL set operators for a long time, and these are by far the most common set operators.But we are getting ahead of ourselves here, let me first explain the set operators that we have and how they work. If you want to give this a try, you can ... Read More

Feed: Clustrix Blog. Author: Rob Hedgpeth. We recently announced the immediate availability of MariaDB SkySQL, the first DBaaS (database-as-a-service) to unlock the full power of MariaDB Platform on an industry-leading, cloud-native architecture.One of the key tenets of a DBaaS is simplicity. Not only should a DBaaS be easy to set up, but it should also be easy to use. Not only easy to use, but easy to use with tools that help us visualize and conceptualize our data. In this article you’ll learn just how easy it is to integrate with MariaDB SkySQL. If you don’t already have a SkySQL ... Read More

Feed: Clustrix Blog. Author: Rob Hedgpeth. MariaDB recently announced SkySQL, the first DBaaS (database-as-a-service) to unlock the power of the MariaDB Platform. You’re likely familiar with the traditional row-based storage that RDBMS platforms offer, and while MariaDB SkySQL certainly offers that approach, it also provides much more.MariaDB Platform for Analytics leverages the columnar capabilities of MariaDB ColumnStore with data placed on object storage in the cloud. With this functionality, you not only get the high-performance analytical benefits of columnar storage, but you eliminate the need to pre-allocate storage for growth. MariaDB Platform for Analytics allows you to perform real-time ad ... Read More

Feed: Clustrix Blog. Author: Nick Lamb. With the introduction of our SkySQL cloud database offering, we’ve launched SkyDBA to build on the success of the Remote DBA (RDBA) program that MariaDB has operated since the early days of the company. The RDBA service, and now SkyDBA, extend the capabilities of your in-house DBAs with the backing from a global team of expert MariaDB database administrators, available 24/7 for the most severe (S1) issues.MariaDB’s SkyDBA program is unique in the industry both because of the depth of database experience and the breadth of the services offered – from day to day ... Read More

Feed: Clustrix Blog. Author: Shane Johnson. We already gutted Amazon Redshift in Part 1, we might as well finish with a fatality. Yes, the Mortal Kombat in the arcade at the roller rink kind of fatality. And yes, I had custom roller skates. Will I share pictures in a future blog post? No.Now, back to cloud data warehouses. Redshift is great if… You have money to burn, and enjoy bonfires. You love complexity, and prefer Reptangles over Legos. If you don’t, it’s time for something better (and less expensive). Here’s the thing. Redshift is up to 40% more expensive than ... Read More

Feed: Clustrix Blog. Author: Shane Johnson. If you needed an on-premises data warehouse today, would you choose a version of Postgres released in 2005 (Postgres 8.0.2)? How about a version of MySQL released in 2005 (MySQL 5.0.15)? Perhaps you’d ask Oracle if you could use Oracle Database 10g Release 2 even though it was released in 2005 and reached end-of-life a decade ago?I didn’t think so. You know better, and so do I. Amazon? Not so much. They built Redshift on ParAccel Analytic Database (PADB) in 2013, itself built on Postgres 8.0.2. ParAccel would go on to be acquired by ... Read More

Feed: Clustrix Blog. Author: Rob Hedgpeth. Today we announced the immediate availability of MariaDB SkySQL, the first DBaaS (database-as-a-service) to unlock the full power of MariaDB Platform on an industry-leading, cloud-native architecture. SkySQL delivers the “MariaDB in the cloud” experience customers have been waiting for – fully featured, fully customizable and backed by world-class support and database expertise from the source, the engineers who built it.MariaDB Enterprise Server, part of MariaDB Platform, is a 100% Open Source modern SQL database. MariaDB Enterprise Server 10.4 extends the capabilities of the widely-deployed MariaDB Community Server with enterprise-focused advanced features, optimized builds, and ... Read More

Feed: Clustrix Blog. Author: Franz Aman. Today marks a new milestone for MariaDB with the launch of SkySQL, a next-generation cloud database that combines powerful enterprise features and world-class database support with groundbreaking innovation. There is someone in particular that’s worth thanking at this moment – Amazon. They pioneered the first generation of databases on the internet. But in classic retail fashion they simply strip-mined the best of open source databases, and made it available on their shelf without an ability to innovate on the database itself. Databases are some of the most complex software products today. Wrapping open source databases ... Read More