Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 35120 10 Older Entries
Percona Live Amsterdam 2015: Tip to Stay Dry
+1 Vote Up -0Vote Down

Or should I say to: "not to get soaked"...

The Amsterdam weather forecasts for next week is out  and it does not look so good during Percona Live MySQL and NoSQL Conference:

Of course, this is not a problem during talks, and I take this opportunity to invite you to my talks:

Riding the Binlog: an in Deep Dissection of the Replication Stream(22 September 11:20AM - 12:10PM @ Matterhorn 3)

Clarification on “Call me Maybe: MariaDB Galera Cluster”
+2 Vote Up -0Vote Down

Recently Aphyr (Kyle Kingsbury) published

The article is technically valid, I am not going to dispute a conclusion Aphyr made, but it is also quite technically involved, so users who just jump to conclusion may get the wrong impression and we’re left with more questions than ever.

So, let me state what is the real conclusion of this article:
“Galera cluster does not support SNAPSHOT ISOLATION LEVEL, in contract to what was stated in the …

  [Read more...]
MySQL Aurora CPU spikes
+0 Vote Up -0Vote Down

Recently we encountered an issue with aurora, where our cpu started spiking every X minutes. (X < 30)

we had like 20-30 connections, out of which majority were inserts and a few selects.

every time the spike occurred our inserts would start waiting and waiting….

here is innotop output

we checked our code. nothing major had changed.

The mysql error log had this mysterious message which i could …

  [Read more...]
Plenty of 9s for highly available MySQL, MariaDB, MongoDB & Postgres databases at Percona Live Europe next week
+1 Vote Up -0Vote Down

Getting new t-shirts printed as give-aways for the much anticipated Percona Live Europe Conference in Amsterdam next week is not unlike creating and spinning up lots of MySQL instances. Some might prefer to do so themselves, manually, while others will look at automating most of the required steps (as it takes quite a bit of time to produce 100s of t-shirts by hand …). 

Given the database automation & management folks that we are at Severalnines, we went for automation …

  [Read more...]
Webinar: Introduction to MySQL SYS Schema follow up questions
+1 Vote Up -0Vote Down

Thanks to all who attended my webinar Introduction to MySQL SYS Schema. This blog is for me to address the extra questions I didn’t have time to answer on the stream.

Can i have the performance_schema enabled in 5.6 and then install the sys schema? Or they are one and the same?

You need to have enabled the performance_schema in order to use it through the sys schema. They are different entities. In general, performance_schema collects and stores the data, and sys schema reads and presents the data.

The …

  [Read more...]
Protecting MySQL Passwords With the sha256_password Plugin
Employee_Team +2 Vote Up -0Vote Down

Over the years, MySQL has used three different mechanisms for securing passwords both for storage and for transmission across networks. This blog post aims to provide a brief history of the various mechanisms and highlight reasons to migrate accounts to use the sha256_password mechanism introduced in MySQL Server 5.6.…

MySQL Health Check Script
+0 Vote Up -0Vote Down

Ever get called out for a MySQL issue only to realize that there was no issue?  It was a false alarm from the monitor.  We sure have and it’s frustrating, especially at 3:00 or 4:00 in the morning!

Many DBAs work in an environment where there is some sort of first level support that gets assigned tickets first.  Unfortunately, many of the times these groups are, shall we say, less than skilled in MySQL.  As a result, they quickly escalate the ticket onto the primary on-call DBA, even when there is really nothing wrong.

Much of the time, there are multiple types of MySQL topology in these environments: standalone, galera cluster, …

  [Read more...]
ProxySQL tutorial : seamless replication switchover in less than one second
+0 Vote Up -0Vote Down

In the previous blog post we setup a replication topology with one master and 2 slaves, and we installed proxysql on a forth servers where the application should connect to.
The post was quite long, and we covered several topics, from installation and configuration of the cluster to installation of proxysql and creation of users and backends, from configuration of query rules for routing and their statistics to monitoring module and replication lag.

But ProxySQL can do more than this.
Among the most interesting features of …

  [Read more...]
Percona Server 5.6.26-74.0 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Server 5.6.26-74.0 on September 15, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories.

  [Read more...]
MySQL Group Replication – 0.5.0 Labs Release
Employee_Team +0 Vote Up -0Vote Down

Hi all, keeping our steady release cycle, it is time again to do another preview release of MySQL Group Replication, the plugin that brings multi-master update everywhere to MySQL, like we described in Hello World post.

We are very proud to do the fourth preview release of MySQL Group Replication, version 0.5.0 based on MySQL Server 5.7.8, which introduces new exciting features, please enjoy the highlights!…

10 Newer Entries Showing entries 61 to 70 of 35120 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.