Tag: MariaDB

Feed: Actian. Author: Lewis Carr. In December, January, and February, I posted a short series of blogs on Flat file systems. The series of blogs focus on the continued use of flat files and why they are no longer viable for use in the future.The first installment focused on flat files and why embedded software application developers readily adopted them. Then in the second installment, I discussed why embedded developers are reluctant to use databases. The third installment looked at why developers cling to the flat file systems. The final installment provided a checklist for embedded developers migrating off flat files ... Read More

Feed: Recent Announcements. Some of the new features in MariaDB 10.4 include an instant drop column operation, additional authentication capabilities, and a capability to reload new SSL certificates without restarting the server. For more details about the new features in this release please see release notes for MariaDB 10.4.  ... 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: Planet MySQL; Author: MySQL Performance Blog; This is a three-part blog series. Be on the lookout for parts two and three in the coming days.There was no reason to plan for it, but the load on your system increased 100%, 300%, 500%, and your MySQL database has to support it. This is a reality many online systems have to deal with these days. This series focuses on dealing with the unexpected high traffic event as it is happening.There are also a lot of things you can do proactively, which we covered in “Prepare Your Databases for High Traffic on ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . There are several ways to move data between SQL Server and MariaDB. Here we will discuss them and we will highlight some caveats. Moving Data Definition from SQL Server to MariaDB To copy an SQL Server data structures to MariaDB, one has to: Generate a CSV file from SQL Server data. Modify the syntax so that it works in MariaDB. Run the file in MariaDB. Variables That Affect DDL Statements DDL statements are affected by some server system variables. sql_mode determines the behavior of some SQL statements and expressions, including how strict ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The events_transactions_history table contains the most recent completed transaction events for each thread. The number of records stored per thread in the table is determined by the performance_schema_events_transactions_history_size system variable, which is autosized on startup. If adding a completed transaction event would cause the table to exceed this limit, the oldest thread row is discarded. All of a thread's rows are discarded when the thread ends. The table contains the following columns: +---------------------------------+------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------------------+------------------------------------------------+------+-----+---------+-------+ | THREAD_ID | bigint(20) unsigned ... 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

Feed: Clustrix Blog. Author: Saravana Krishnamurthy. SkySQL is the first database-as-a-service (DBaaS) to unlock the full power of MariaDB Platform in the cloud. Engineered for mission-critical applications and enterprise governance, SkySQL cloud database is focused on features which make life better for the developer, the DBA, and the operator — extending powerful enterprise features with unrivaled ease of use and first-in-class innovation.MariaDB Platform for Transactions Whether you need transactional capabilities for dev/test or production, MariaDB Platform for Transactions delivers the robust modern SQL capabilities of MariaDB Enterprise Server either in single-node Standalone configuration, or in a multi-node replicated Primary/Replica topology ... Read More

Feed: Clustrix Blog. Author: Shane Johnson. We couldn’t be more excited to announce the general availability of MariaDB SkySQL today!It’s been years in the making, from the initial release of official MariaDB containers and Helm Charts back in 2018 to engineering-led sessions at OpenWorks ‘19 discussing design principles for a next-generation database-as-a-service (DBaaS) to initial feedback from customers participating in the limited technical preview earlier this year. All of this has led up to today’s launch of SkySQL cloud database in multiple regions across the world. We created SkySQL because the world deserves, and demands, a DBaaS capable of meeting ... Read More