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 …[…] PlanetMySQL Voting: Vote UP / Vote DOWN Full article:MySQL Cluster: Una introducción en Español. […]
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:
Slave election is a popular HA architecture, first MySQL
MariaDB toolkit to manage switchover and failover in a correct
way was introduce by Yoshinori
Matsunobu into MHA.
Failover and switchover in asynchronous clusters require
caution:
- The CAP theorem need to be satisfy. Getting strong consistency,
require the slave election to reject transactions ending up in
the old master when electing the candidate master.
- Slave election need to take care that all events on the old
master are applied to the candidate master before switching
roles.
- Should be instrumented to found a good candidate master and
make sure it's setup to take the master role.
- Need topology detection, a master role can't be pre defined, as
the role …
Setting up environments, starting processes, and monitoring these processes on multiple machines can be time consuming and error prone - stale settings from previous test runs, wrong configurations, wrong commands, package conflicts, etc.. quite a few things can go wrong. If you are using Galera Cluster, you would probably want application developers to have a proper development environment on their local computers. Proper here means testing your code on a local Galera Cluster, not on a single instance MySQL. Galera Cluster differs from a single instance MySQL, so this allows you to catch these differences early in the project. But how can you quickly roll out a mini test clusters to your application developers, without having them waste time setting these up? This is where Vagrant comes in.
Vagrant is a system that allows you to easily create and move development environments from one machine to another. Simply define what type of VM you …
[Read more]Delémont/Neuchâtel, 22.01.2015. La SSII suisse dbi services et la Haute école de gestion Arc à Neuchâtel (HEG Arc) viennent de lancer un projet d’intégration des jeunes informaticiens à la vie d’entreprise: Proposée gratuitement, la «Database Excellence Academy» va permettre à cinq jeunes diplômés en Informatique de gestion de participer à une série de formations pratiques de 3 à 4 jours portant sur les technologies de bases de données Oracle, Microsoft SQL Server et MySQL. Il s’agit d’ateliers assurés par des experts reconnus de dbi services dans lesquels les participants apprendront à gérer l’outil informatique des administrateurs de …
[Read more]The press, be it the general daily newspaper or the computer magazines, is currently informing the public about an upcoming leap second, which will be taken in the night from June 30 to July 1 at 00:00:00 UTC. While we Europeans will enjoy our well-deserved sleep then, this will be at 5 PM (17:00) local time on June 30 for Califormia people, and during the morning of July 1 for people in China, Japan, Korea, or Australia. (Other countries not mentioned for the sake of brevity.) This is different from last time, when the leap second was taken in the night from Saturday to Sunday (2012-July-1 00:00:00 UTC), so it was a weekend everywhere on the globe.
We have got several requests from our customers about this upcoming leap second, whether they need to take any special precautions or whether they "are safe". Well, obviously nobody is "safe" from the leap second in the sense that it would circumvent them, everybody will encounter it on their …
[Read more]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]