Tag: INSERT

Feed: Recent Announcements. Apache Hudi is an open-source data management framework used to simplify incremental data processing and data pipeline development. Apache Hudi enables you to manage data at the record-level in Amazon S3 to simplify Change Data Capture (CDC) and streaming data ingestion, and provides a framework to handle data privacy use cases requiring record level updates and deletes. Data sets managed by Apache Hudi are stored in S3 using open storage formats, and integrations with Presto, Apache Hive, Apache Spark, and AWS Glue Data Catalog give you near real-time access to updated data using familiar tools. Apache Hudi is ... Read More

Feed: Planet MySQL; Author: Mark Callaghan; I am wary of papers with performance results for too many products.Too many means including results from systems for which you lack expertise. Wary means I have less faith in the comparison even when the ideas in the paper are awesome. I have expertise in MySQL, MongoDB, RocksDB, WiredTiger and InnoDB but even for them I have made and acknowledged ridiculous mistakes.Database configuration is too hard. There are too many options, most of them aren't significant and the approach is bottom-up. I an expert on this -- in addition to years of tuning I ... Read More

Feed: Clustrix Blog. Author: Ken Geiselhart. In the world of databases, having multiple copies of your database helps to serve your business in a multitude of ways. To achieve this, replication is used. Replication copies the contents of one server called a Primary to one or more servers called Replicas.One advantage of replication is the ability to separate the read requests from the write requests and direct those reads to a Replica, offloading that portion of a workload away from the Primary improving performance on the Primary. The main difference in basic replication, between a Primary and a Replica, is ... Read More

Feed: AWS Big Data Blog. Data is revolutionizing the way organizations of all sizes conduct their business. Companies are increasingly using third-party data to complement their internal data and deliver value for their customers. Third party data is used across a wide variety of use-cases, such as to build applications for customers, to run analytics workloads to improve business operations and marketing activities, or to build predictive models using machine learning (ML) techniques.However, as data becomes the center of how companies operate, the way data providers deliver to data subscribers has not changed in years. As data providers, you spend ... Read More

Feed: Planet MySQL; Author: Tiago L. Alves; Gaming, banking, telcos, and online services all are powered by fully-redundant and fault-tolerant software systems. At the heart of those systems, you can find MySQL Cluster — a distributed in-memory database having a minimum of five-9s availability (around 5 minutes a year). This open-source database provides nearly-linear scalability and real-time querying predictability at the microsecond level.To achieve such higher availability it’s crucial to ensure that each release is thoroughly validated. Thousands of automated tests are run daily, for different versions and platforms to ensure defects are detected early and fixed. Testing is everyone’s ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . The ribbon in Power BI Desktop has an updated and modern experience. When you turn on the “Updated ribbon” preview feature, you will see a ribbon that looks more like the ribbon in Office products. In the updated ribbon, you have access to all the existing features that you know and love, and over time, more features will be added to the ribbon. If you have feedback about the updated ribbon, we’d love to hear from you! The Journey When we started the journey of redesigning the ribbon, some ... Read More

Feed: Clustrix Blog. Author: Ken Geiselhart. Let’s talk about database backups for a minute. Making sure your data is safe and recoverable is a key component of Database Administration. Keeping regular and reliable backups are essential to the success of any organization. When something unexpected happens like a server crashes, data corruption or even data tampering, you need to be able to recover mission critical applications quickly and reliably.One of the new features in MariaDB Enterprise Server and MariaDB Enterprise Backup is the use of non-blocking backup lock to minimize workload impact during backup operations. It does this by doing ... Read More

Feed: Clustrix Blog. Author: Anders Karlsson. There are several ways to load data into MariaDB Platform, and some are better than others. The two basic ways are either to use LOAD DATA INFILE / LOAD DATA LOCAL INFILE, which is very fast, in particular the non-LOCAL one and then we have the plain INSERT statement. When using an INSERT statement you may pass an array to MariaDB Server, like thisINSERT (column1,column2) VALUES(, ),(, ) Nothing special with that, but what we will cover in this blog is another way of doing INSERTs using arrays, one which uses the MariaDB API ... Read More

Feed: Clustrix Blog. Author: Alejandro Infanzon. This is part 4 of a 5-part series, if you want to start from the beginning see Temporal Tables Part 1: Introduction & Use Case ExampleThe preceding parts of this series introduced system time and transaction precise time. It showed how MariaDB can automatically capture temporal information based on those definitions.  However, application defined timing information is often more important.  Often times it is less important to know when a change was recorded in the system, than it is to know when that change is meant to take effect.  Let’s take a Human Resource ... Read More

Feed: Clustrix Blog. Author: Alejandro Infanzon. This is part 3 of a 5-part series, if you want to start from the beginning see Temporal Tables Part 1: Introduction & Use Case ExampleUp until now, we haven’t crisply defined what is meant by SYSTEM_TIME in the above examples.  With the DDL statement above, the time that is recorded is the time that the change arrived at the database server.  This suffices for many use cases, but in some cases, particularly when debugging the behavior of queries at specific points of time, it is more important to know when the change was ... Read More