Get Started for FREE
Sign up with Facebook Sign up with X
I don't have a Facebook or a X account
 Your new post is loading...
Scoop.it!
Tutorial delivered at Percona Live London 2014, where we explore new features and techniques for faster queries with MySQL 5.6 and 5.7 and MariaDB 10, includin…
stephane gault's insight:
Query Optimization with MySQL 5.7 and MariaDB 10
No comment yet.
Sign up to comment
Scoop.it!
If you’ve been studying complex systems you know what minor changes might cause consequences of much greater proportions, sometimes causing some effects that are not easily explained at first.
stephane gault's insight:
Very nice analysis on what can hide changes and history list.
Scoop.it!
You might have encountered situations where you had to kill some specific select queries that were running for long periods and choking the database. This post will go into more detail with an example of report query offloading.
stephane gault's insight:
Very handy tool
Scoop.it!
Many organizations are interested in Percona XtraDB Cluster (PXC) as a replacement for conventional MySQL® master/slave architectures to eliminate replicatio...
stephane gault's insight:
Detailed key points to figure out if you want to go that path.
Scoop.it!
Galera replication for MySQL brings not only the new, great features to our ecosystem, but also introduces completely new maintenance techniques. Are you concerned about adding such new complexity to your MySQL environment?
stephane gault's insight:
Operations with a Percona Xtradb Cluster outage, how to recover and restart nodes. You'll always have a backup anyway (XtraBackup fast & secure).
Scoop.it!
Jervin Real shares two ways of achieving high availability with the mysqlnd_ms extension using the mysqlnd plugin, MySQL Master Slave.
stephane gault's insight:
Good way to achieve HA in an Master Slave setup.
|
Scoop.it!
This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) on Galera-based clusters such as Percona XtraDB Cluster (PXC).
stephane gault's insight:
Very complete setup guide to PXC. Clever use of Global Transaction IDs (GTIDs) on Galera-based clusters such as Percona XtraDB Cluster.
Scoop.it!
By default in MySQL 5.6, each time MySQL is started (regular start or crash recovery), it iterates through all the binlog files when GTIDs are not enabled ...
stephane gault's insight:
MySQL 5.6 fix for faster start of Percona/MySQL server.
Scoop.it!
We are pleased to announce the third release in the 0.6 series of mydumper, a tool for performing logical MySQL backups. In this release, we focused on simplifying compiling the code and added new features for making logical backups.
stephane gault's insight:
Very useful tool
Scoop.it!
MySQL upgrades are necessary tasks and we field a variety of questions here at Percona Support regarding MySQL upgrade best practices. This post highlights recommended ways to upgrade MySQL in different scenarios.
stephane gault's insight:
dump, with xtrabackup is mandatory before any upgrade ! Logical AND FS backup, one for the consitency one for fast operations.
Scoop.it!
Here on the Percona Support team we often ask customers to retrieve disk stats to monitor disk IO and to measure block devices iops and latency. There are a number of tools available to monitor IO on Linux.
stephane gault's insight:
Very accurate way to find if your disks are the bottleneck (often the case). Scoopit Love the percona toolkit, very powerfull to monitor and debug !
Scoop.it!
|
