Tag: MariaDB

Feed: MariaDB Knowledge Base Article Feed. Author: . This guide will cover: The load balancing and high availability concepts in Mariadb Connector/J for version before 3.0 The different options. Failover and high availability were introduced in 1.2.0. Failover occurs when a connection to a primary database server fails and the connector opens up a connection to another database server.For example, server A has the current connection. After a failure (server crash, network down …) the connection will switch to another server (B). Load balancing allows load (read and write) to be distributed over multiple servers. In MariaDB (and MySQL) replication, ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB has an event scheduler that can be used to automate tasks, making them run at regular intervals of time. This page is about using events for automation. For more information about events themselves, and how to work with them, see event scheduler. Pro's and Con's of Using Events for Automation Events can be compared to Unix cron jobs or Windows scheduled tasks. MariaDB events have at least the following benefits compared to those tools: Events are system-independent. Events are written in procedural SQL. There is no need for other languages. Events ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The MariaDB Foundation maintains a Downloads REST API. See the Downloads API documentation to find out all the tasks that you can accomplish with this API. Generally speaking, we can say that it provides information about MariaDB products and available versions. This allows to easily automate upgrades for MariaDB and related products. The Downloads API exposes HTTPS endpoints that return information in JSON format. HTTP and JSON are extremely common standards that can be easily used with any programming language. How to Use the API with a Unix Shell Linux shells are ... Read More

Feed: Recent Announcements. Amazon Relational Database Service (Amazon RDS) for MariaDB now supports MariaDB minor versions 10.5.13, 10.4.22, 10.3.32, and 10.2.41. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of MariaDB, and to benefit from the numerous bug fixes, performance improvements, and new functionality added by the MariaDB community. You can leverage automatic minor version upgrades to automatically upgrade your databases to more recent minor versions during scheduled maintenance windows. Learn more about upgrading your database instances, including automatic minor version upgrades, in the Amazon RDS User Guide. Amazon RDS ... Read More

When you DROP or TRUNCATE a table or partition in MySQL or MariaDB and you have a large buffer pool, you may have noticed a complete server lock-up or stall of multiple seconds. Here is what you can do to work around this bug (MySQL bug #98869, MariaDB bug MDEV-9459).Most people never notice this bug because their database servers have relatively small memory (and thus buffer pool) and the manifestation of the bug disappears in the noise on the monitoring graphs. But on large servers it quickly becomes obvious. Depending on the server’s CPU and memory bandwidth, the stall can ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This document lists known issues and limitations in MariaDB MaxScale and its plugins. Since limitations are related to specific plugins, this document is divided into several sections. Configuration limitations In versions 2.1.2 and earlier, the configuration files are limited to 1024 characters per line. This limitation was increased to 16384 characters in MaxScale 2.1.3. MaxScale 2.3.0 increased this limit to 16777216 characters. In versions 2.2.12 and earlier, the section names in the configuration files were limited to 49 characters. This limitation was increased to 1023 characters in MaxScale 2.2.13. Multiple MaxScales on ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Restrictions and Limitations Here's a list of the current restrictions and limitations of the MariaDB Jupyter kernel. Trying to stretch what we listed here is at your own risk, the results and the behavior of the kernel might be at the mercy of the universe :-) One cell should only contain a single SQL statement. It can be multi-line, a one liner, it doesn't matter, but it needs to only be a single statement. A notebook cell can only contain one line magic command (line magics start with %). Everything else within ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . If you installed the kernel, installed its kernelspec and you have MariaDB installed on your system, you just need to open JupyterLab, and when you create a new notebook, pick MariaDB as your kernel. For some sample notebooks, check out the notebooks directory in our GitHub repository page. Those should guide through what you can do with mariadb_kernel. You can also try mariadb_kernel using the amazing MyBinder platform by clicking this badge or you can click on the Try MariaDB @ binder badge from the mariadb_kernel GitHub repo. This takes absolutely no ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Afza Wajid. By Afza Wajid, Global Business Lead, SaaS at AWSBy Sudhir Reddy Maddulapally, Sr. Solutions Architect, SaaS at AWS Have you ever had to manage a transactional database and data warehouse separately when the better solution would be to combine the two? For example, when a real-time analytical layer is needed on top of a transactional database, separate management can be less than ideal. Traditionally, solving for this scenario has meant leasing an expensive database appliance and sizing it for current and forecasted usage needs—essentially trading off agility for the sake of ... Read More

Feed: Recent Announcements. T3 database instances are the latest generation of x86-based burstable general-purpose instances that provide a baseline level of CPU performance with the ability to burst CPU usage at any time for as long as required. T3 instances offer a balance of compute, memory, and network resources and are ideal for database workloads with moderate CPU usage that experience temporary spikes in use. Amazon RDS database instances running MySQL versions 5.7.16 and higher, MySQL versions 8.0.17 and higher, MariaDB versions 10.4.8 and higher, and MariaDB versions 10.5.8 and higher are supported with T3. You can easily upgrade to ... Read More