Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 956 10 Older Entries

Displaying posts with tag: Uncategorized (reset)

Getting started MySQL Group Replication on Ubuntu with MySQL Sandbox
+1 Vote Up -0Vote Down

Welcome to next topic dedicated to Group Replication plugin. Today’s topic is to get started with Group Replication. As you remember we set up our environment using MySQL Sandbox on Ubuntu 14.04 and also we have compiled plugin with MySQL 5.7.8-rc on Ubuntu 14.04. Please refer to this topics respectively:

  1. MySQL Sandbox creating test environment
  2. Compiling MySQL …
  [Read more...]
AWS CloudFormation Now Supports Aurora, Amazon’s MySQL Compatible Database
+0 Vote Up -0Vote Down

AWS CloudFormation now supports Amazon Aurora!



Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity …

  [Read more...]
Compiling MySQL Group Replication plugin with MySQL 5.7.8-rc2 on Ubuntu
+0 Vote Up -0Vote Down

MySQL Group Replication plugin is in and is available for EL6 x86_64 version Linux. But most of us have Ubuntu desktops where it should be easier to test this new thing, especially with MySQL Sandbox. After getting source code we should have compile this plugin with MySQL from source. So let’s begin. Extract both mysql group replication archive and mysql source archive:

sh@shrzayev:~/Sandboxes$ ls -l
total 650732
drwxr-xr-x 34 sh sh      4096 İyl 20 17:25 mysql-5.7.8-rc
-rw-rw-r--  1 sh sh  49762480 Avq 20 16:19 mysql-5.7.8-rc.tar.gz
drwxrwxr-x  3 sh sh      4096 Sen 28 12:08 mysql-group-replication-0.5.0-dmr …
  [Read more...]
MariaDB/MySQL: ON REPLACE triggers
+0 Vote Up -0Vote Down

There are several reasons why, generally, in MySQL/MariaDB one should not use REPLACE as a shortcut for SELECT + (UPDATE or INSERT). One of these reasons is the way REPLACE fires triggers. Of course it does not fire UPDATE triggers, and there is no such thing as a REPLACE trigger; DELETE and INSERT triggers are fired instead. What is not obvious is the order in which REPLACE activates triggers (UPDATE: this beavior was undocumented; I documented it …

  [Read more...]
ARIN Reaches IPv4 Depletion | Team ARIN
+0 Vote Up -0Vote Down

ARIN is the American Registry for Internet Numbers, the organisation that hands out the blocks IP addresses.

Each region has its own, for instance Australia/Pacific has APNIC. Naturally, they work very closely together.

Open Query can assist you with planning and deployment of IPv6 capabilities on your front-end servers, as well as at the back-end if you wish. Not all hosting providers support IPv6, but many good ones do. MySQL/MariaDB can operate in a native IPv6 or dual stack environment. Open Query enabled its own front-end servers for …

  [Read more...]
Using Perl to retrieve direct messages from Twitter, insert messages into a MySQL database and then delete the messages
+0 Vote Up -0Vote Down

In two earlier posts, I gave some examples on how to use Perl to send tweets stored in a MySQL database to Twitter, and then how to automatically reply to your retweets with a “thanks”. In this post, I will show you how to automatically download your direct messages from Twitter, …

  [Read more...]
MySQL Aurora CPU spikes
+0 Vote Up -0Vote Down

Recently we encountered an issue with aurora, where our cpu started spiking every X minutes. (X < 30)

we had like 20-30 connections, out of which majority were inserts and a few selects.

every time the spike occurred our inserts would start waiting and waiting….

here is innotop output

we checked our code. nothing major had changed.

The mysql error log had this mysterious message which i could …

  [Read more...]
MySQL Group Replication – 0.5.0 Labs Release
Employee_Team +0 Vote Up -0Vote Down

Hi all, keeping our steady release cycle, it is time again to do another preview release of MySQL Group Replication, the plugin that brings multi-master update everywhere to MySQL, like we described in Hello World post.

We are very proud to do the fourth preview release of MySQL Group Replication, version 0.5.0 based on MySQL Server 5.7.8, which introduces new exciting features, please enjoy the highlights!…

Recovery Enhancements for Group Replication
Employee_Team +0 Vote Up -0Vote Down

One of the key features of MySQL Group Replication is its distributed recovery mechanism. Whenever a new member joins a server group, making use of this plugin component, it reaches to a suitable donor and fetches the data that it misses up until the point it is declared online.…

MySQL Group Replication: Auto-increment configuration/handling
Employee_Team +0 Vote Up -0Vote Down

In 0.5.0 version of MySQL Group Replication plugin, we have introduced the Auto-increment configuration/handling feature through which auto increment variables (auto_increment_increment and auto_increment_offset) are auto configured by the plugin, so that different members of the group don’t generate duplicated auto increment values.…

Showing entries 1 to 10 of 956 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.