Here are the slides for my talk at Percona Live Europe in Amsterdam, 2015, for my “Performance Schema and Sys Schema in MySQL 5.7”:
Thanks for all that attended, and the good questions and feedback!
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Here are the slides for my talk at Percona Live Europe in Amsterdam, 2015, for my “Performance Schema and Sys Schema in MySQL 5.7”:
Thanks for all that attended, and the good questions and feedback!
Last week we released MySQL Router into our Labs and we need to provide a few extra details on how to actually use it.
Requirements
…
Long time has passed since the first time ProxySQL was announced
in October 2013 .
A lot of changes happened from that day: ProxySQL was initially
just a prototype, and had many many limitations.
Quickly these limitations became a showstopper for future
development, but that was expected from a simple prototype.
Since then it was completely rewritten, and after almost 2 years
I am glad to announce that ProxySQL is now a proxy with a long
list of features, stable and production ready.
Please join me and attend my session at Percona Live where I will present the new
exciting features of ProxySQL , a High Availability proxy
designed to solve real issues of MySQL setups from small to very
large production environments.
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache webserver on a Debian 8 (Jessie) server with PHP (mod_php) and MySQL / MariaDB support. A LAMP setup is a perfect basis for CMS systems like Joomla, Wordpress or Drupal.
In a previous blog post, we showed you how to install Kubernetes on CentOS 7. Since then, there’s been a number of changes and we’ve seen the first production-ready release. The “minion” term has been changed to “node” and thousands of bug fixes and new features introduced.
In this blog post, we’re going to play with Kubernetes application clustering and pods. We’ll use Wordpress as the application, with a single MySQL server. We will also have HAProxy and Keepalived to provide simple packet forwarding (for external network) with high availability capability. We assume a Kubernetes master and three Kubernetes nodes are already deployed on CentOS 7 using instructions described in our …
[Read more]Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on September 21st 2015. Binaries are available from downloads area or from our software repositories.
Based on Percona Server 5.6.25-73.1 including all the bug fixes in it, Galera Replicator 3.12, and on …
[Read more]Even with software like Percona Xtrabackup, logical backups remain an important component of a thorough backup strategy. To gather a logical backup in a timely fashion we rely on a tool called mydumper. In the Percona Managed Services department we’re lucky enough to have one of the project’s most active contributors and many of the latest features and bug fixes have been released to satisfy some of our own use cases. Compiling mydumper remains one of my personal bug bears and undoubtedly the highest barrier to entry for many potential adopters. There are a few conditions that make compiling it difficult, tiring or even prohibitive. The open source logical backup tool does not supply any official packages, however our friends over at …
[Read more]Having secured our MySQL server and created a personal account to allow for remote administration, we can take one step further on blocking unwanted access to our database server. For this example, we'll continue to use the Ubuntu 14.04.2 LTS Server installed and configured on the previous posts. After booting up the server, running a network check for connections, lists our server listening on
I am also getting this error when i create above soft
links,
radiusd: #### Instantiating modules ####
/usr/local/etc/raddb/mods-enabled/redis[10]: Failed to link to
module ‘rlm_redis’: /usr/local/lib/rlm_redis.so: cannot open
shared object file: No such file or directory
This post was written by Seppo Jaakola, CEO of Codership.
There appears to be great misunderstanding as to what MySQL transaction isolation levels Galera CLuster actually supports and how. This blog post tries to give answer to those uncertainties.
Galera Cluster provides SNAPSHOT ISOLATION between transactions running on separate cluster nodes. Transactions running on the same node are isolated by whatever was configured as the transaction isolation level in the MySQL configuration. So, if you have configured the default REPEATABLE READ isolation, transactions issued on the same node will behave under REPEATABLE READ semantics. However, for transactions issued on separate cluster nodes, the ‘first committer wins’ rule of SNAPSHOT ISOLATION is provided, and this will fix the lost update problem that generally hurts REPEATABLE READ isolation.
Therefore, it is not safe for the application to rely on SNAPSHOT …
[Read more]