Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34732 10 Older Entries
Ansible and Loading MySQL Databases Part II
Employee +1 Vote Up -0Vote Down

Loading databases on virtual systems is not as straight forward as it should be. Last time the foundation for using Ansible was set down on our quest to be able to have fully functional database servers on virtual servers automatically. But that prompted a few of you to remind me that you do not always need Ansible.

Without Ansible
You can have Vagrant do the work. Modify the vagrant file to run a script to run a script when …

  [Read more...]
New! MySQL Connector/Arduino release-1.0.4 GA and Documentation
Employee +1 Vote Up -0Vote Down

After several iterations and a long period of community evaluation, I am happy to report I've released the newest, stable release of the MySQL Connector/Arduino. This library is designed to allow you to connect your Arduino via an Ethernet or WiFi shield to a MySQL database server running on your network (or the Internet!).

New Documentation!Best of all, I've written a reference manual that includes examples of how to use the connector in a variety of ways. Included in the document are advice on how to write your sketches, troubleshooting tips, and a long FAQ compiled from the many questions from my blogs.

Changes …



  [Read more...]
MySQL in a USB, with a little help of Fabric
Employee +1 Vote Up -0Vote Down

If you’ve wanted to see how well MySQL Fabric actually works and how easy it makes setting up replication and switching Masters & Slaves back and forth, with a sample use case of having the master stored in a USB stick, then feel free to have a look at:

http://www.slideshare.net/keithhollman5/mysql-fabric-in-a-usb

o la versión en Español:

http://www.slideshare.net/keithhollman5/mysql-fabric-en-un-usb

Please let …

  [Read more...]
New Optimizer Hints in MySQL
Employee_Team +1 Vote Up -0Vote Down

The MySQL optimizer has a well known special system variable—optimizer_switch—which allows control of various optimizer modes such as index condition pushdown (ICP), batched key access, etc. One big disadvantage of using the optimizer_switch, however, is that changing its value is an extra step in the query execution. Another disadvantage of the …

  [Read more...]
Can’t Be Any Faster Than That: A Real-Life Experiment with Latency in a Geo-distributed Environment
+1 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...]
See VividCortex in Your Server's 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...]
Showing entries 1 to 10 of 34732 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.