Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34726 10 Older Entries
Can’t Be Any Faster Than That: A Real-Life Experiment with Latency in a Geo-distributed Environment
+0 Vote Up -0Vote Down

Introduction

A question frequently asked is how much latency does Galera have in geo-distributed environments. After all, snail mail can also be used for database replication, but the latency will not be acceptable.

Let’s see how Galera performs.

A Two-Datacenter Setup

We will start by creating a two-node cluster using a pair of Amazon EC2 regions that are as far apart Internet-wise as it gets – Sydney and São Paulo. The underwater cable maps do not show a direct link between Australia and …

  [Read more...]
Pseudo GTID, ASCENDING
+0 Vote Up -0Vote Down

Pseudo GTID is a technique where we inject Globally Unique entries into MySQL, gaining GTID abilities without using GTID. It is supported by orchestrator and described in more detail here, here and here.

Quick recap: we can join two slaves to replicate from one …

  [Read more...]
Getting SIGABRT -> Assertion `is_binlog_empty()’ failed with MySQL 5.7.7-rc
+0 Vote Up -0Vote Down

What about inserting data to MySQL 5.7.7-rc-debug with GTID/binary log enabled. It is OK until you hit disk full condition while inserting data. It will crash on the way and likely you will lose MySQL. Error log indicates related problem:

2015-07-29T07:20:05.865708Z 2 [ERROR] InnoDB: posix_fallocate(): Failed to preallocate data for file ./sls2/sales.ibd, desired size 4194304 bytes. Operating system error number 28. Check that the disk is not full or a disk quota exceeded. Make sure the file system supports this function. Some operating system error numbers are described at …
  [Read more...]
Multi-source replication in MySQL 5.7 vs Tungsten Replicator
+0 Vote Up -0Vote Down

MySQL 5.7 comes with a new set of features and multi-source replication is one of them. In few words this means that one slave can replicate from different masters simultaneously.

During the last couple of months I’ve been playing a lot with this trying to analyze its potential in a real case that I’ve been facing while working with a customer.

This was motivated because my customer is already using multi-sourced slaves with Tungsten Replicator and I wanted to do a side-by-side comparison between Tungsten Replicator and Multi-source Replication in MySQL 5.7

Consider the following scenario:

  [Read more...]
About the new warnings generated during 'PURGE BINARY LOGS' execution
Employee +0 Vote Up -0Vote Down

In this blog, I will discuss about warnings that users might face if they are trying to purge active/in_use binary log which are introduced in MySQL-5.6.12/MySQL-5.7.2 releases.  Before jumping directly to that, I will be covering few basic things about PURGE BINARY LOGS command, about safe way to purge the binary logs on a replication forum. If you are good at basics on "PURGE BINARY LOGS" , you can choose to directly move to the section (at the end of the blog) where I was talking about these new warnings.

Introduction:
==========
A binary log file contains “events” that describe …



  [Read more...]
Updated Time Zone
+0 Vote Up -0Vote Down

Similar to databases, the modern IT team is often distributed. As remote work increases and employee locations span the globe, it becomes difficult to keep everyone on the same page. Our latest time zone update is a step toward this goal.

In the past, all the dates and graphs have been shown in the user’s time zone. VivdCortex has members in Charlottesville and Montevideo, which adds a level of complexity. If you have members in San Fransisco, Auckland, and London, communicating can get really complicated.

While this is still the defult behavior, you can also set a fixed time zone for an environment, ensuring every team member is …

  [Read more...]
on time in mysql processlist
+0 Vote Up -0Vote Down

There was one MySQL feature that I was always very afraid to ask for. I sure needed it for past 15 years of my MySQL practice, and yet I never got to it. I wanted MySQL processlist (‘SHOW PROCESSLIST’, later – information_schema.processlist) to have more accurate query execution time.

I submitted a patch for that to MongoDB (and it got merged and released really quickly). I couldn’t admit to myself and others that MySQL does not have this functionality, even though it is hard to reason about systems in production without such data.

When 99.999% of queries happen within 1s, …

  [Read more...]
Amazon Aurora has gone GA!
+0 Vote Up -0Vote Down

See Jeff Barr’s blog post:

https://aws.amazon.com/blogs/aws/now-available-amazon-aurora/


Yahoo at Percona Live
+0 Vote Up -0Vote Down

We had a great time meeting with folks from the industry and are excited about the innovations being pursued by the community and various companies. 

Videos of our keynote panel participation and talks are available now.


Percona Live 2015 Keynote Panel discussion - Ritesh Chhajer



High Availability using Percona XtraDB Cluster - Trey Raymond & Yashada …




  [Read more...]
MySQL for Visual Studio 1.2.4 has been released
Employee_Team +0 Vote Up -0Vote Down

MySQL for Visual Studio 1.2.4 has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Visual Studio 1.2.4. This is a maintenance release for 1.2.x, and it can be used for production environments.

MySQL for Visual Studio is a product that includes all of the Visual Studio integration functionality to create and manage MySQL databases when developing .NET applications.

This version is appropriate for using with MySQL server versions 5.5-5.6. The 5.7 server version is also compatible but is not fully supported, thus it should be used at your own discretion. …

  [Read more...]
Showing entries 1 to 10 of 34726 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.