Tag: MariaDB

Feed: Planet MySQL. Author: MariaDB. Optimizing your database performance is important, but it often falls by the wayside in the bustle of daily business. How big a deal is it? Let’s look at potential consequences of a poorly tuned database: Bad user experience: Obviously you never want customers to complain of bad performance from your application. That’s the first step toward… Lost sales: Customers may walk away when your application is just too slow. But it gets worse. You’re more likely to run into downtime when your database is overloaded, and if the server that’s down is an ordering or ... Read More

Feed: Percona Database Performance Blog. Author: Emily Ikuta. Emily Ikuta  | June 26, 2017 |  Posted In: MariaDB, MySQL, Technical Webinars PREVIOUS POST Join Percona’s Chief Evangelist, Colin Charles as he presents MariaDB Server 10.2: The Complete Guide on Tuesday, June 27, 2017, at 7:00 am PDT / 10:00 am EDT (UTC-7). The new MariaDB Server 10.2 release is out. It has some interesting new features, but beyond just a list of features we need to understand how to use them. This talk will go over everything new that MariaDB 10.2 has to offer. In this webinar, we’ll learn about Window functions, ... Read More

Feed: Planet MySQL. Author: Wagner Bianchi. In this second installment of schema sharing with MariaDB MaxScale to combine SchemaRouter and ReadWriteSplit MaxScale routers, we'll go through the details of implementing it in order to shard databases among many pairs of master/slave servers. Before we move forward, I would like to highlight that you need to remove any duplicate database schema or a schema that is present on both shards. Schemas should exist in just one of the shards as when the SchemaRouter plugin starts, it’s going to read all the database schemas that exists on all the shards to get to know where ... Read More

Feed: Planet MySQL. Author: Jaime Crespo. For the impatient: # echo -e "deb http://repo.mysql.com/apt/debian/ stretch mysql-5.7ndeb-src http://repo.mysql.com/apt/debian/ stretch mysql-5.7" > /etc/apt/sources.list.d/mysql.list # wget -O /tmp/RPM-GPG-KEY-mysql https://repo.mysql.com/RPM-GPG-KEY-mysql # apt-key add /tmp/RPM-GPG-KEY-mysql # apt update # apt install mysql-server# echo -e "deb http://repo.mysql.com/apt/debian/ stretch mysql-5.7ndeb-src http://repo.mysql.com/apt/debian/ stretch mysql-5.7" > /etc/apt/sources.list.d/mysql.list# wget -O /tmp/RPM-GPG-KEY-mysql https://repo.mysql.com/RPM-GPG-KEY-mysql# apt-key add /tmp/RPM-GPG-KEY-mysql# apt update# apt install mysql-serverIn the latest stable version of Debian, if you ask to install mysql-server, you now get installed mariadb automatically, with no (evident) way of installing Oracle’s MySQL. Any major version upgrade has to be done carefully (not only for MariaDB, but ... Read More

Feed: Planet MySQL. Author: Valeriy Kravchuk. This is a "Howto" kind of post, and some speculations and historical references aside, it will show you how to build MariaDB ColumnStore (current version 1.0.9) from GitHub source, how to install and configure it for basic usage, as well as how to resolve some minor problems you may get in the process. Keep reading and eventually you'll get the real Howto below :) * * * I try not to care about any software issues besides good old MySQL, InnoDB storage engine internals, query optimization and some MyRocks or a little bit of ... Read More

Feed: Planet MySQL. Author: Yngve Svendsen. Debian logo by Software in the Public Interest, Inc. (CC-BY-SA) MySQL and Debian 9 “Stretch” Debian 9 (“Stretch”) was released on June 17, and we congratulate the Debian community on another iteration of a central Linux distro. Now, the Debian release team some time ago decided not to ship MySQL as part of the distro, instead replacing it with one of the downstream forks. The MySQL team is absolutely committed to making sure that the vast MySQL user base can continue to use Debian as a platform, and we are directing a lot of attention to making ... Read More

Feed: Percona Database Performance Blog. Author: Kenny Gryp. Kenny Gryp and Ramesh Sivaraman  | June 23, 2017 |  Posted In: Group Replication, High-availability, InnoDB, Percona XtraDB Cluster PREVIOUS POST Thank you for attending the Wednesday, June 21, 2017 high availability webinar titled Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication. In this blog, I will provide answers to the Q & A for that webinar. You can find the slides and a recording of the webinar here. Is there a minimum MySQL server version for Group Replication? MySQL Group Replication is GA since MySQL Community 5.7.17. This is the lowest version that you ... Read More

Feed: Planet MySQL. Author: Wagner Bianchi. Most of the time when you start a database design you don’t imagine how your applications need to scale. Sometimes, you need to shard your databases among some different hosts and then, on each shard you want to split reads and writes between master and slaves. This blog is about MariaDB MaxScale being able to handle different databases across shards, and splitting up reads and writes into each of the shards to achieve the maximum level of horizontal scalability with MariaDB Server. After reading this blog you will be able to: Know how MariaDB ... Read More

Feed: Percona Database Performance Blog. Author: Vadim Tkachenko. Vadim Tkachenko  | June 22, 2017 |  Posted In: Benchmarks, MySQL, Performance Schema PREVIOUS POST In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test. We have mentioned ClickHouse in some recent posts (ClickHouse: New Open Source Columnar Database, Column Store Database Benchmarks: MariaDB ColumnStore vs. Clickhouse vs. Apache Spark), where it showed excellent results. ClickHouse by itself seems to be event-oriented RDBMS, as its name suggests (clicks). Its primary purpose, using Yandex Metrica (the system similar to Google Analytics), also points to ... Read More

Feed: Planet MySQL. Author: MariaDB. The 2.1.3 GA release of MariaDB MaxScale, introduces the following key features for the secure setup of MaxScale Binlog Server: The MaxScale binlog server can optionally encrypt the events received from the master server: the setup requires a MariaDB (from 10.1.7) master server with encryption active and the mariadb10-compatibility=On option set in maxscale.cnf. This way both master and MaxScale will have encrypted events stored in the binlog files. How does the Binary log encryption work in MariaDB Server and in MaxScale? Let’s look at MariaDB Server 10.1 or 10.2 implementation first. The encryption is related to ... Read More