Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34726 10 Older Entries
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...]
Become a MySQL DBA blog series - Database upgrades
+0 Vote Up -0Vote Down

Database vendors typically release patches with bug/security fixes on a monthly basis, why should we care? The news is full of reports of security breaches and hacked systems, so unless security is not a concern, you might want to have the most current security fixes on your systems. Major versions are rarer, and usually harder (and riskier) to upgrade to. But they might bring along some important features that make the upgrade worth the effort.

In this blog post, we will cover one of the most basic tasks of the DBA - minor and major database upgrades.  

This is the sixth installment in the ‘Become a MySQL DBA’ blog …

  [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.