Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 11 to 20 of 36163 10 Older Entries
Percona XtraBackup 2.4.3 is now available
+0 Vote Up -0Vote Down


Percona
is glad to announce the GA release of Percona XtraBackup 2.4.3 on May 23rd, 2016. Downloads are available from our download site and from apt and yum repositories.


  [Read more...]
Windows Nano Server Technical Preview 5 and MySQL
Employee_Team +0 Vote Up -0Vote Down

Windows Nano Server is a deployment option of the upcoming Windows Server 2016. It is a “headless” version of Windows Server, pared back to provide the bare essentials necessary to host server / “born in the cloud” applications such as MySQL.…

MySQL slave promotion with- and without using GTID
+0 Vote Up -0Vote Down

MySQL Replication can be fragile: whenever it encounters a connectivity error, it will retry and if it is a serious error, it will simply stop. Obviously in the latter case, you will need to repair the broken replication yourself.

The most common problems with replication are when it stops due to either master failure or network problems. In case the master fails, the whole topology becomes read-only and this means the write queries cannot be applied anymore. This is where normally you would promote one of the replicas to become the new master. To illustrate the difference in promotion between GTID and non-GTID cases, we will go through the …

  [Read more...]
Introduction to Troubleshooting Performance – Troubleshooting Slow Queries webinar: Q & A
+0 Vote Up -0Vote Down

In this blog, I will provide answers to the Q & A for the Troubleshooting Slow Queries webinar.

First, I want to thank you for attending the April 28 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I wasn’t …

  [Read more...]
Downsizing to SSDs
+1 Vote Up -0Vote Down

System management can be a big deal. At Etsy, we DBAs have been feeling the pain of getting spread too thin. You get a nice glibc vulnerability and have to patch and reboot hundreds of servers. There goes your plans for the week.

We decided last year to embark on a 2016 mission to get better performance, easier management and reduced power utilization through a farm reduction in server count for our user generated, sharded data.

Scoping the Problems

Taking on a massive project to replace your entire fleet of hardware is not an easy sell, especially when on the surface it seems like everything is fine. As DBAs, we experienced …

  [Read more...]
Percona XtraDB Cluster 5.6.29-25.15 is now available
+0 Vote Up -0Vote Down


Percona
is glad to announce the new release of Percona XtraDB Cluster 5.6 on May 20, 2016. Binaries are available from the downloads area or our software repositories.

Percona XtraDB Cluster 5.6.29-25.15 is now the …


  [Read more...]
Become a ClusterControl DBA: Operational Reports for MySQL and MariaDB
+0 Vote Up -0Vote Down

The majority of DBA’s perform health checks every now and then. Usually, it would happen on a daily or weekly basis. We previously discussed why such checks are important and what they should include.

To make sure your systems are in a good shape, you’d need to go through quite a lot of information - host statistics, MySQL statistics, state of backups, logs and so forth. Such data should be available in every properly monitored environment, although sometimes it is scattered across multiple locations - you may have one …

  [Read more...]
Source of Truth or Source of Madness?
+0 Vote Up -0Vote Down

This year at Etsy, we spun up a “Database Working Group” that talks about all things data. It’s made up of members from many teams: DBA, core development, development tools and data engineering (Hadoop/Vertica). At our last two meetings, we started talking about how many “sources of information” we have in our environment. I hesitate to call them “sources of truth” because in many cases, we just report information to them, not action data based on them. We spent a session whiteboarding all of of these sources and drawing the relationships between …

  [Read more...]
Fixing MySQL scalability problems with ProxySQL or thread pool
+1 Vote Up -0Vote Down

In this blog post, we’ll discuss fixing MySQL scalability problems using either ProxySQL or thread pool.

In the previous post I showed that even MySQL 5.7 in read-write workloads is not able to maintain throughput. Oracle’s recommendation to play black magic with

innodb_thread_concurrency

 and

innodb_spin_wait_delay

 doesn’t always help. We need a different solution to deal with this scaling problem.

All the conditions are the same as in my …

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


Percona is glad to announce the release of Percona Server 5.5.49-37.9 on May 19, 2016. Based on MySQL 5.5.49, including all the bug fixes in it, Percona Server 5.5.49-37.9 is now the current stable release in the 5.5 series.

Percona Server is open-source and free. Details of the release can be found in the 5.5.49-37.9 milestone on …


  [Read more...]
10 Newer Entries Showing entries 11 to 20 of 36163 10 Older Entries

Planet MySQL © 1995, 2016, 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.