Tag: Percona Server

Feed: Planet MySQL; Author: Severalnines; RDS is a Database as a Service (DBaaS) that automatically configures and maintains your databases in the AWS cloud. The user has limited power over specific configurations in comparison to running MySQL directly on Elastic Compute Cloud (EC2). But RDS is a convenient service, as long as you can live with the instances and configurations that it offers. Amazon RDS currently supports various MySQL and MariaDB versions as well as the, MySQL-compatible Amazon Aurora DB engine. It does support replication, but as you may expect from a predefined web console, there are some limitations. Amazon ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; David Ducos | June 19, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, open source databases, Percona Server for MySQL PREVIOUS POST Since MySQL 5.7.5, we have been able to resize dynamically the InnoDB Buffer Pool. This new feature also introduced a new variable — innodb_buffer_pool_chunk_size — which defines the chunk size by which the buffer pool is enlarged or reduced. This variable is not dynamic and if it is incorrectly configured, could lead to undesired situations. Let’s see first how innodb_buffer_pool_size , innodb_buffer_pool_instances  and innodb_buffer_pool_chunk_size interact: The buffer pool can hold several instances and each ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles | June 8, 2018 |  Posted In: MariaDB, MongoDB, MyRocks, MySQL PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Some big news out from Microsoft about their acquisition of GitHub for $7.5 billion. GitHub hosts many projects, including from the MySQL ecosystem, but maybe more interesting is that their DBA team is awesome, give great talks, and are generally prolific writers. Some of the cool tools the MySQL world has gotten thanks to the excellent team include (but are not limited ... Read More

Feed: Planet MySQL; Author: Dave Stokes; This year the Zero to DBA Hero track at the Southeas  Llinuxfest expands to a second day.  The event is free to attend but it helps if you pre register.  Here is the agenda of that you will see in Charlotte June 8th, 9th, and 10th. MySQL Talks at SELF – Zero to DBA Hero Track Linode Ballroom Friday 9am 20 years of MySQL, 20 years of PHP, and 10 Years of SELF -- What the heck has been going on? Dave Stokes 10:15 Introducing the MySQL Document Store Charles Bell, PhD 11:30 Performance Analysis and ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles | June 1, 2018 |  Posted In: AWS, Events and Announcements, MariaDB, MongoDB, MySQL, MySQL 8.0, open source databases, Percona Server for MySQL, PostgreSQL, ProxySQL PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Shortly after the last dispatch, I jetted off for a spot of vacation (which really meant I was checking out the hype behind Blockchain with a database developer lens at the Blockchain Week NYC), and then some customer visits in Seoul, which explains the short hiatus. Here’s to making ... Read More

Feed: Planet MySQL; Author: MinervaDB; We are are an vendor neutral and independent open source database technologies consulting, support and remote DBA services provider with several customers using MySQL GA, MySQL Enterprise, InnoDB/XtraDB, Percona Server, MariaDB, MyRocks and ClickHouse. The customers continue doing business with us for being an technology / vendor agnostic company. We spend considerable amount of time doing research on open source database technologies, Often customers ask us about the performance comparison between InnoDB and MyRocks so we decided to write this post to compare performance between InnoDB (MySQL 8.0) and MyRocks (MariaDB 10.3.7) using Sysbench 1.0.14:Software Infrastructure ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dmitriy Kostiuk | May 31, 2018 |  Posted In: Events and Announcements, MyRocks, MySQL, Percona Live, Percona Server for MySQL, Percona Software, Security, TokuDB PREVIOUS POST Percona announces the GA release of Percona Server for MySQL 5.7.22-22 on on May 31, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.7.22, including all the bug fixes in it, Percona Server for MySQL 5.7.22-22 is the current GA release in the Percona Server for MySQL 5.7 series ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dmitriy Kostiuk | May 30, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.6.40-84.0 on May 30, 2018 (downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.40, including all the bug fixes in it, Percona Server for MySQL 5.6.40-84.0 is now the current GA release in the 5.6 series. All of Percona’s software is open-source and free. New Features A new string variable version_suffix allows to change suffix for the Percona Server version string returned by the read-only version variable. This allows to ... Read More

Feed: Planet MySQL; Author: Alexander Rubin; Alexander Rubin | May 25, 2018 |  Posted In: Containers, High-availability, Insight for DBAs, Insight for Developers, MySQL, Percona Server for MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL, Technical Webinars, XtraDB Cluster PREVIOUS POST Please join Percona’s Principal Architect Alex Rubin as he presents MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together to give you a highly available cluster database environment on Tuesday, May 29th at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). In this webinar, Alex will discuss how to deploy a highly available MySQL database environment on Kubernetes/Openshift using Percona XtraDB ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Michael Coburn | May 23, 2018 |  Posted In: Amazon RDS, AWS, Database Monitoring, Events and Announcements, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM PREVIOUS POST Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible. In PMM Release 1.11.0, we deliver the following changes: Configurable MySQL Slow Log Rotation – enable or disable rotation, and specify ... Read More