Tag: MariaDB Server

Feed: Clustrix Blog. Author: Ralf Gebhardt. We are pleased to announce the second release of MariaDB Server 10.6.  MariaDB Server 10.6 is the next major version of our yearly MariaDB Server Release Series. With this release, internal optimizations have covered all areas of the server, including a lot of refactoring in InnoDB. Commands of the Data Definition Language (DDL) are atomic operations with MariaDB Server 10.6, so any DDL statement is guaranteed to be either fully executed or completely discarded even if the server has crashed or was killed in the middle of an operation. MariaDB Server 10.6 also got ... Read More

Feed: Clustrix Blog. Author: Ralf Gebhardt. We are pleased to announce the first release of MariaDB Server 10.6.  MariaDB Server 10.6 is the next major version of our yearly MariaDB Server Release Series, following the MariaDB Server 10.5 GA release last July. For MariaDB Server 10.6 a focus has been set on internal optimizations and clean-ups, and also the preparation for new features like storage engine independent foreign key support. Such preparations provide the baseline for a strong storage engine based model for MariaDB Server, to leverage multiple storage engines implemented for different workloads, and to support new, combined use ... Read More

Feed: Clustrix Blog. Author: Ralf Gebhardt. We are pleased to announce the general availability of MariaDB Connector/C++. This new connector complements our existing family of production-ready connectors, which recently grew with the GA releases of MariaDB Connector/Python in June 2020 and MariaDB Connector/R2DBC last month.  All connectors are fully supported for MariaDB Platform subscription customers and MariaDB SkySQL customers. MariaDB Connector/C++ delivers an object-oriented C interface, implemented as a custom C++ version of Java’s JDBC API, for developers building applications with C++ for MariaDB Server on premises and in the cloud on SkySQL. We encourage you to try this new ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB uses branch protection to ensure that pushes to the MariaDB Server git repository cannot be made without first passing a series of tests. This page aims to describe what a developer should do in order to ensure that their changes get pushed to the main repository. Protected Branches Flow Rebase your work on top of the latest main branch. <<git rebase 10.2>> Push to bb-* branch Wait for all the checks to run If all checks are successful you can push to the main branch to be the same as bb-* ... Read More

Feed: Clustrix Blog. Author: Rob Hedgpeth. Last year we released the new MariaDB Python connector and published a blog post on how to get started using it in your applications. Based on the overwhelmingly positive response that MariaDB Connector/Python has received, we’re going to develop additional tutorials and sample code to help showcase how easy it is for you to use MariaDB Connector/Python within your solutions. Python is a very powerful and versatile programming language, capable of being used in a large variety of applications, solutions, and integrations. Ultimately, that’s one of the reasons why the Python language has become ... Read More

Feed: Clustrix Blog. Author: Rob Hedgpeth. Today, we announced the general availability of MariaDB Connector/C++. The C++ language is known for its efficiency, versatility and extensibility. In fact, it’s often used in industries like fintech and gaming where applications require predictable concurrency and latency. With MariaDB Connector/C++, developers can use the new connector within their applications to natively connect to MariaDB Server on premises and in the cloud on MariaDB SkySQL. In this article I’ll be introducing you to MariaDB Connector/C++ with simple examples that demonstrate create, read, update, and delete (CRUD) interactions with data stored in MariaDB. More specifically, ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . mysql 명령줄 클라이언트에 대하여 mysql (from MariaDB 10.4.6, also called mariadb) is a simple SQL shell (with GNU readline capabilities). It supports interactive and non-interactive use. When used interactively, query results are presented in an ASCII-table format. When used non-interactively (for example, as a filter), the result is presented in tab-separated format. The output format can be changed using command options. mysql (MariaDB 10.4.6부터는 mariadb라고도 불립니다.)은 간단한 SQL 셸입니다.(GNU readline 기능 포함) 대화형 및 비 대화형 사용을 지원합니다. 대화형으로 사용될 경우 쿼리 결과는 ASCII-테이블 형식으로 표시됩니다. 비 대화형으로 사용될 경우(예시 : 필터로 ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . mysql 클라이언트(MariaDB 10.4.6부터는 mariadb라고도 불립니다.)의 기본 구분 기호는 세미콜론(;) 입니다. 저장 프로그램(stored program)을 명령줄에서 작성하는 경우, 통상적인 구분 기호와 BEGIN END 블록 내의 구분 기호를 다르게 해야 할 수 있습니다. 더 잘 이해하기 위해 아래의 예제를 살펴보세요: CREATE FUNCTION FortyTwo() RETURNS TINYINT DETERMINISTIC BEGIN DECLARE x TINYINT; SET x = 42; RETURN x; END; 만약 위의 코드를 차례로 한 줄씩 입력한다면, mysql 클라이언트는 DECLARE x TINYINT의 끝에 있는 첫번째 세미콜론을 전체 구문의 끝으로 인식할 것입니다. 그러나 이는 부분적인 정의에 불과하므로 아래와 같은 syntax error를 발생시킬 것입니다: CREATE FUNCTION FortyTwo() RETURNS TINYINT DETERMINISTIC ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . mariadb_schema is a data type qualifier that allows one to create MariaDB native date types in a SQL_MODE that has conflicting data type translations. mariadb_schema was introduced in MariaDB versions 10.3.24, 10.4.14, 10.5.5. For example in SQL_MODE=ORACLE, if one creates a table with the DATE type, it will actually create a DATETIME column to match what an Oracle user is expecting. To be able to create a MariaDB DATE in Oracle mode one would have to use mariadb_schema: CREATE TABLE t1 (d mariadb_schema.DATE); mariadb_schema is also shown if one creates a table ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Operators basically instruct Kubernetes about how to manage a certain technology. Kubernetes comes with some default operators, but it is possible to create custom operators. Operators created by the community can be found on OperatorHub.io. Custom Operators Kubernetes provides a declarative API. To support a specific (i.e. MariaDB) technology or implement a desired behavior (i.e. provisioning a replica), we extend Kubernetes API. This involves creating two main components: A custom resource. A custom controller. A custom resource adds an API endpoint, so the resource can be managed via the API server. It ... Read More