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 me know what you think.
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.…
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 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 South America.
The ICMP round-trip time between the two regions is a steady 316 ms:
root@ip-172-31-4-77:/home/ubuntu# ping ec2-54-94-217-199.sa-east-1.compute.amazonaws.com
PING ec2-54-94-217-199.sa-east-1.compute.amazonaws.com (54.94.217.199) 56(84) bytes of data.
64 bytes from ec2-54-94-217-199.sa-east-1.compute.amazonaws.com …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 http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2015-07-29T07:20:05.895529Z 2 [Warning] InnoDB: 1048576 bytes should have been written. Only 557056 bytes written. Retrying again to write the remaining bytes.
2015-07-29T07:20:05.905149Z 2 [Warning] InnoDB: 491520 bytes should have been written. Only 106496 bytes written. Retrying again to write the remaining …[Read more]
After installing a MySQL database server, like the one I posted earlier, if it's going to be a production environment than you should consider securing the instance by eliminating some of the basic vulnerabilities that come with a generic install. Fortunately MySQL and MariaDB already come with a tool for that purpose, called mysql_secure_installation. This program enables to perform the
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:
DB1 is our main master attending mostly
writes from several applications, it also needs to serve read …
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 database
changes occurred on a MySQL Server (typically
called Master) that enabled binary logging using --log-bin.
On a Master server, the files that are related to binary logging
are binary log files (files with binlog_base_name.6_digit
serial_number) and a binary log index file (file with …
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 looking at the same time. This is especially helpful when trouble shooting, optimizing certain queries, collaborating after a code deploy… the list goes on.
The current time zone will be shown in the timepicker for easy reference, and every time we display a date, we will also …
[Read more]The average American consumer isn’t usually interested in “buying” a big database. But thanks to the recent boom in the popularity of subscription music services like Spotify, databases are competing for folks’ cash more directly than ever before. After all, what are these services other than giant banks of media, made accessible and sleek? The summer of 2015 has brought the battle for music-lovers’ wallets to fever pitch, with the launch of Apple Music and Tidal, both poised to challenge the reign of top-dog Spotify.
In terms of content, all three services are pretty similar. They share a ton of overlap. Unless a consumer has an overwhelming love for Mrs. Carter or Miss Swift, or …
[Read more]
