In this blog post, we’ll discuss services monitoring using probabilistic fault detection.

Let’s admit it, the task of monitoring services is one of the most difficult. It is time-consuming, error-prone and difficult to automate. The usual monitoring approach has been pretty straightforward in the last few years: setup a service like Nagios, or pay money to get a cloud-based monitoring tool. Then choose the metrics you are interested in and set the thresholds. This is a manual process that works when you have a small number of services and servers, and you know exactly how they behave and what you should monitor. These days, we have hundred of servers with thousands of services sending us millions of metrics. That is the first problem: the manual approach to configuration doesn’t work.

That is not the only problem. We know that no two servers perform the same because no two servers have exactly the …

This tutorial explains how to install ISPConfig 3 latest development version using a Debian stretch repository with its respective Debian packages. The objective of this tutorial is more for experimental and testing purposes than for productive environments.

In this post we are going to learn how to get last single record from MySQl database table using Codeigniter database libraryWe sometime require to get only single row result in our Codeigniter application In this post you can see how to get whole last record using Codeigniter db query Few day

In this post we are going to learn how to get last single record from MySQl database table using Codeigniter database libraryWe sometime require to get only single row result in our Codeigniter application In this post you can see how to get whole last record using Codeigniter db query Few day

We saw yesterday that the new MySQL Shell was out and how we could create a MySQL InnoDB Cluster manually using the Shell.

Today, I would like to show you how easy it is to create recipes to automate all the process. I have created a Puppet module that can be used as Proof-of-concept (You might need more features to use it in production, feel free to fork it).

The module can be found on this github repo.

When using Puppet, I really like to put all configuration in hiera.

Environment

We have 3 GNU/Linux servers: mysql1, mysql2 and mysql3.

We won’t install anything related to MySQL manually, everything will be handled by Puppet.

Nodes definition …

Welcome to another post in the series of Percona Live featured talk blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database environment. Make sure to read to the end to get a special Percona Live 2017 registration bonus!

In this Percona Live featured session, we’ll meet Bogdan Munteanu, Software Engineer at Dropbox. His session is Edgestore Multi-tenancy & Isolation. Edgestore is Dropbox’s distributed metadata store, used by hundreds of products, services and …

 Earlier this week,  MySQL Shell 1.08 has been released. This is the first Release Candidate of this major piece of MySQL InnoDB Cluster.

Some commands have been changed and some new ones were added.

For example the following useful commands were added:

• dba.checkInstanceConfiguration()
• cluster.checkInstanceState()
• dba.rebootClusterFromCompleteOutage()

So let’s have a look on how to use the new MySQL Shell to create a MySQL InnoDB Cluster.

Action Plan

We have 3 blank Linux servers: mysql1, mysql2 and mysql3 all running rpm based Linux version 7 (Oracle Linux 7, CentOS 7, …).

We will install the required MySQL yum repositories and install the needed packages …

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.30. This is a Stable (GA) release. See the release notes and changelog for details. Download MariaDB 10.0.30 Release Notes Changelog What is MariaDB 10.0? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

The post MariaDB 10.0.30 now available appeared first on MariaDB.org.

Find Galera Cluster developers and experts in our booth.  We would be happy to hear your Galera Cluster story.

Galera presentations in MI17:

Deep Dive: Adding Replication and Scaling with Galera

Wednesday, April 12 1:10 pm – 2:00 pm.

Seppo  Jaakola, Codership CEO

Data inconsistency is the worst problem that can happen for a synchronous database cluster. At some point it will appear during replication processing, simply because the application of replication events is not possible in some cluster nodes due to missing rows, excessive rows or wrong values in the row columns. As a result, this usually stops the replication process ...READ MORE

Step-by-step: Clustering with Galera and Docker Swarm

Wednesday, April 12 2:10 pm – 3:00 pm

…

MySQL Cluster Manager 1.4.2 is now available for download from My Oracle Support.

In this blog post we will highlight some of the details of the MCM 1.4.2 release.

Progress reporting
First, some eye candy. With MCM 1.4.2 we added simple progress reporting.…