Category: MySQL & MariaDB

Feed: Planet MySQL; Author: MySQL Server Dev Team; The newest release of MySQL 8.0.14 includes the ability to control the number and location of UNDO tablespaces using SQL. Users can now manage UNDO tablespaces using SQL from the MySQL client. Background More undo tablespaces help busy systems handle a larger number of read-write concurrent transactions by having more rollback segments available to provide undo logs to those transactions.  Users can now create up to  127 UNDO tablespaces and the minimum number of UNDO tablespaces required for MySQL 8.0 is 2. UNDO logs are no longer stored in the InnoDB system ... Read More

Feed: Planet MySQL; Author: Airton Lastori; The MySQL Enterprise Tools Development Team is pleased to announce the maintenance release of MySQL Enterprise Monitor 8.0.14 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. If you are not familiar with MySQL Enterprise Monitor, it is the best-in-class tool for monitoring and management of your MySQL assets and is part of MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition subscriptions. You are invited to give it a try using our 30-day free customer trial ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB replication can be used to replication between MariaDB Galera Cluster and MariaDB Server. This article will discuss how to do that. Configuring the Cluster Before we set up replication, we need to ensure that the cluster is configured properly. This involves the following steps: Configuring Wsrep GTID Mode If you want to use GTID replication, then you also need to configure some things to enable wsrep GTID mode. For example: wsrep_gtid_domain_id needs to be set to the same value on all nodes in the cluster, so that each cluster node uses ... Read More

Feed: Planet MySQL; Author: João Gramacho; The encrypted binary log file format introduced in MySQL version 8.0.14 was designed to allow a “manual” decryption of the file data when the value of the key that encrypted its file password is known. Each encrypted binary (or relay) log file is composed by an encrypted binary log file header and the encrypted binary log content (the file data). As shown in this blog post, encrypted binary log files have a “magic header” (file’s first four bytes) of 0xFD62696E to differentiate them from plain binary log files (that has 0xFE62696E as magic header) ... Read More

Feed: Planet MySQL; Author: João Gramacho; Starting in version 8.0.14, MySQL server can encrypt all new binary and relay log files on disk. In order to do so, you just need to enable the new binlog_encryption option (and also ensure that you have a keyring). Once enabling the option in a client session, the server will rotate both binary and relay logs to start using a new encrypted binary log file format. Only the data at rest is encrypted. The replication stream sent to replicas (and to mysqlbinlog client program) wasn’t changed. First of all, you need to have keyring ... Read More

Feed: Planet MySQL; Author: Mark Callaghan; My goal for the year is more time learning math and less time running MySQL benchmarks. I haven't done serious benchmarks for more than 12 months. It was a great experience but I want to learn new things. MySQL 8.0.14 has been released with fixes for a serious bug I found via the insert benchmark. I won't confirm whether it has been fixed. I hope someone else does.My tests and methodology are described in posts for sysbench, linkbench and the insert benchmark.  I hope the upstream distros (MySQL, MariaDB, Percona) repeat my tests and methodology ... Read More

Feed: Planet MySQL; Author: Dave Stokes; The MySQL Track for the Southern California Linux Expo 17x has been published! On Friday march 9th you can learn about the MySQL Document Store, How to Deploy MySQL in Kubernetes, lean how Facebook achieves consistency with MySQL, MySQL Query Optimization, Analytics with MySQL, and MySQL Security.  There are actually four days of the expo but the MySQL Track is on Friday, but you should stay around for the full weekend.  And MySQL is a sponsor and we will have a big booth with lots of swag, Be sure to stop by to say ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST A common challenge with continuously deployed applications is that new and modified SQL queries are constantly being introduced to the application. Many companies choose to use a database monitoring system (such as PMM) to identify those slow queries. But identifying slow queries is only the start – what about actually optimizing them? In this post we’ll demonstrate a new way to both identify and optimize slow queries, by utilizing the recent integration of Percona Monitoring and Management with EverSQL Query Optimizer via Chrome browser extension. This integration allows you to identify ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; As listed in the release announcement of the latest MySQL InnoDB Cluster release, 8.0.14 brings exciting new features! This blog post is the first of a series detailing every single new feature added, starting by: “Changing cluster topology modes ‘live‘”. Cluster topology modes The AdminAPI provides the means to create an InnoDB cluster to run on single-primary mode or multi-primary mode. By default, a cluster setup runs in single-primary mode, i.e. the cluster has a single-primary server that accepts read and write queries (R/W), meanwhile all the remaining members accept only read ... Read More

Feed: Planet MySQL; Author: TwinDB; Omnibus as a Solution for Python Dependency Hell Python has always been an exemplar of good coding style for me. It’s impressive how concise unit tests can be, how flexible mocks are. Really, it’s a great pleasure to write Python code. Up until the point when you need to deploy it. From then on you embark on a rollercoaster to go through a variety of tools and approaches. This article is supposed to help you sail over Python dependency hell, stay alive and still enjoy writing in this awesome language. There is a plethora of ... Read More