Tag: MariaDB

Feed: MariaDB Knowledge Base Article Feed. Author: . MyRocks supports several compression algorithms. Supported Compression Algorithms Supported compression algorithms can be checked like so: show variables like 'rocksdb%compress%'; +-------------------------------------+------------------------------------+ | Variable_name | Value | +-------------------------------------+------------------------------------+ | rocksdb_supported_compression_types | Snappy,Zlib,LZ4,LZ4HC,ZSTDNotFinal | +-------------------------------------+------------------------------------+ Another way to make the check is to look into #rocksdb/LOG file in the data directory. It should have lines like: 2019/04/12-14:08:23.869919 7f839188b540 Compression algorithms supported: 2019/04/12-14:08:23.869920 7f839188b540 kZSTDNotFinalCompression supported: 1 2019/04/12-14:08:23.869922 7f839188b540 kZSTD supported: 1 2019/04/12-14:08:23.869923 7f839188b540 kXpressCompression supported: 0 2019/04/12-14:08:23.869924 7f839188b540 kLZ4HCCompression supported: 1 2019/04/12-14:08:23.869924 7f839188b540 kLZ4Compression supported: 1 2019/04/12-14:08:23.869925 7f839188b540 kBZip2Compression supported: 0 2019/04/12-14:08:23.869926 7f839188b540 kZlibCompression ... Read More

Feed: Planet MySQL; Author: FromDual; Last week at the MariaDB/MySQL Developer Training we had one participant asking some tricky questions I did not know the answer by heart.Also MariaDB documentation was not too verbose (here and here). So time to do some experiments: Prepared Statements and Multi-Row Inserts SQL> PREPARE stmt1 FROM 'INSERT INTO `test`.`test` (`data`) VALUES (?), (?), (?)'; Statement prepared SQL> SET @d1 = 'Bli'; SQL> SET @d2 = 'Bla'; SQL> SET @d3 = 'Blub'; SQL> EXECUTE stmt1 USING @d1, @d2, @d3; Query OK, 3 rows affected (0.010 sec) Records: 3 Duplicates: 0 Warnings: 0 SQL> DEALLOCATE PREPARE ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Many of our regular attendees already know that the Percona Live Open Source Database Conference is not all about Percona software or, indeed, all about Percona. However, with moving to a new city—Austin, TX— we have realized that it’s something we ought to shout out loud and clear. Our conference really is technology agnostic! As long as submissions were related to open source databases then they were candidate for selection. We have thirteen tracks at this year’s conference including a track entitled “Other Open Source Databases” which we are presenting alongside tracks ... Read More

Feed: Microsoft Azure Blog. Author: Parikshit Savjani. This blog is co-authored by Nick Lopez, Technical Advisor at Microsoft. Grafana is one of the popular and leading open source tools for visualizing time series metrics. Grafana has quickly become the preferred visualization tool of choice for developers and operations teams for monitoring server and application metrics. Grafana dashboards enable operation teams to quickly monitor and react to performance, availability, and overall health of the service. You can now also use it to monitor Azure services and applications by leveraging the Azure Monitor data source plugin, built by Grafana Labs. This plugin ... Read More

Feed: Planet MySQL; Author: Severalnines; We’re happy to announce that our new whitepaper How to Deploy Open Source Databases is now available to download for free! Choosing which DB engine to use between all the options we have today is not an easy task. An that is just the beginning. After deciding which engine to use, you need to learn about it and actually deploy it to play with it. We plan to help you on that second step, and show you how to install, configure and secure some of the most popular open source DB engines. In this whitepaper ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB 10.3 is the current major stable version. The first stable release was in May 2018, and it will be supported until May 2023. For details on upgrading from MariaDB 10.2, see Upgrading from MariaDB 10.2 to 10.3. MariaDB Server 10.3 is included in MariaDB TX 3.0. Watch the webinar recording to learn more about the new features included in this release. The following lists the major new features in MariaDB 10.3: Implemented Features Syntax / General Features System-versioned tables (also known as AS OF) (MDEV-12894) Table Value Constructors (MDEV-12172) — GSoC ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I have not much yet to say on a populartopic of upgrading everything to MySQL 8, so let me just continue reviewing public MySQL bug reports that I've subscribed to recently. After my previous post at least one bug, Bug #94747, got enough comments and clarifications (up to specific commit that introduced this regression pointed out by Daniel Black!) to have it re-classified and verified as InnoDB code bug. So, I see good reasons to continue attracting wide public attention to selected MySQL bugs - this helps to make MySQL better eventually. As usual, ... Read More

Feed: Planet MySQL; Author: Jesper Krogh; MySQL stores several files on disk. Even in MySQL 8 where the data dictionary is stored in InnoDB tables, there are still all the tablespace files. Different file system behave differently, and one particular challenge is case sensitivity. On Microsoft Windows, the case does not matter, on Linux the case is important, and on macOS the case of the file names is preserved but the operating system by default makes it look like it is case insensitive. Which convention that is the correct depends on your personal preference and use case. Between case sensitivity ... Read More

Feed: Planet MySQL; Author: HowToForge; This tutorial shows the installation of ISPConfig 3.1 on a CentOS 7.6 (64Bit) server. ISPConfig is a web hosting control panel that allows you to configure the following services through a web browser: Apache web server, PHP 7.2, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, Mailman, and many more. 1 Requirements To install such a system you will need the following: A Centos 7.6 minimal server system. This can be a server installed from scratch as described in our Centos 7 minimal server tutorial or a virtual-server or root-server from a hosting company that ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . With MariaDB Kubernetes Operator you can deploy MariaDB Platform on a Kubernetes Cluster, using one of several cluster topologies. When creating a cluster, you can set the specific topology you want to use with the cluster.topology parameter. The topology determines: Optimizations: Whether to optimize MariaDB Platform for Transactional or Analytical workloads Default Containers: The number of containers created by default Load-balancing: Whether the cluster uses MariaDB MaxScale to load-balance between containers Replication: Whether MariaDB Server containers deploy as master/slave or multi-master replication clusters Transactional Processing Topologies In cases where you need MariaDB ... Read More