It’s important to monitor the (database) backups after you set-it-up. In this post we will answer a few how to monitor MySQL Database backups solutions – monitoring methods. We should…
The post How to monitor MySQL backups first appeared on Change Is Inevitable.
Recently a friend asked about Installing Percona Monitoring Tools for Nagios as he was facing a few issues. I managed to set-it-up on my ubuntu VM. Sharing the the work-log…
The post Install Percona Monitoring Tools for Nagios – MySQL Plugins first appeared on Change Is Inevitable.
Like any good, thus lazy, engineer I don’t like to start things manually. Creating directories, configuration files, specify paths, ports via command line is too boring. I wrote already how I survive in case when I need to start MySQL server (here). There is also the MySQL Sandbox which can be used for the same purpose.
But what to do if you want to start Percona XtraDB Cluster this way? Fortunately we, at Percona, have engineers who created automation solution for starting PXC. This solution uses Docker. To explore it you need:
pxc-docker repository:git clone https://github.com/percona/pxc-docker …MariaDB 5.5.44 was recently released (it is the latest MariaDB 5.5), and is available for download here:
https://downloads.mariadb.org/mariadb/5.5.44/
This is a maintenance release, and no major changes, so there are only several noteworthy items (but one of those being a security fix and five potential crashing bug):
MariaDB 10.1.5 was recently released, and is available for download here:
https://downloads.mariadb.org/mariadb/10.1.5/
This is the 3rd beta, and 6th overall, release of MariaDB 10.1. There were not many major changes in this release, but a few notable items, as well as many overall bugs fixed (I counted 306).
Since it’s beta, I’ll only cover the major changes and additions, and omit covering general bug fixes (feel free to browse them all here).
To me, these are the highlights:
Applications often become impacted by MySQL performance. Optimization is the obvious solution but where to start? Join me on July 2 at 11 a.m. Pacific and I’ll show you how to optimize MySQL in a practical way – spending time on what gives you the best return. Many of you have heard me talk on this topic before and this updated presentation will get you up to speed on the latest areas to consider when improving MySQL performance.
I’ll be pointing out the most important things you need to get right for each of the following:
I’ll also share some tools and techniques to focus on the queries most important for your application. At the end of this webinar, aptly titled “ …
[Read more]
The MySQL 5.7.6 release notes describe a
change to the binary log group commit algorithm that
can improve the performance of write intensive applications when
the binary log is enabled (noted with Bug #19424075). This
change is probably inspired by the experiment reported
in MySQL bug #73202.
There is a long history of tweaking the binary log group commit
algorithm and the InnoDB storage engine to scale performance.
Mark Callaghan describes the work done on this problem at Facebook. …
MySQL Cluster: El ‘qué’ y el ‘cómo’.
Para aquellos que encuentran mucho sobre MySQL en Inglés pero
poco en Español: mi pequeña aportación.
En el enlace tenéis información sobre qué es MySQL Cluster y cómo
funciona. Incluso con ejemplos técnicos para romper las barreras
y ayudar a simplificarlo (espero).
¡A disfrutar!
The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.20 and MariaDB Galera Cluster 5.5.44. These are Stable (GA) releases.
Download MariaDB Galera Cluster 10.0.20
Release Notes Changelog What is MariaDB Galera Cluster?
[Read more]
When I joined Pinterest, my first three weeks were spent in Base
Camp, where the newest engineering hires work on real production
issues across the entire software stack. In Base Camp, we learn
how Pinterest is built by building it, and it’s not uncommon to
be pushing code and making meaningful contributions within just a
few days. At Pinterest, newly hired engineers have the
flexibility to choose which team they’ll join, and working on
different parts of the code as part of the Base Camp experience
can help with this decision. Base Campers typically work on a
variety of tasks, but my project was a deep dive into a MySQL
performance optimization project.
Pinterest, MySQL and AWS, oh my!
We work with MySQL running entirely inside Amazon Web Services (AWS). Despite using fairly high-powered instance types with RAID-0 SSDs and a fairly simple workload (many point selects by PK or simple ranges) that peaks around 2,000 …
[Read more]