Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 71 to 80 of 33479 10 Older Entries
Tutorial Introduction to working with Groups in MySQL Fabric
Employee +1 Vote Up -0Vote Down

<?xml version="1.0" encoding="iso-8859-1"?>Tutorial Introduction to working with Groups in MySQL Fabric Tutorial Introduction to working with Groups in MySQL Fabric Table of Contents

  [Read more...]
MySQL Cluster on POWER8
+0 Vote Up -0Vote Down

So, I’ve written previously on MySQL on POWER, and today is a quick bit of news about MySQL Cluster on POWER – specifically MySQL Cluster 7.3.7.

I ran into three main issues in getting some flexAsync benchmark results. One of them was the fact that I wanted to do this in the middle of all the POWER8 machines I usually use moving buildings (hard to run benchmarks when computers are packed up in boxes on a truck).

The next issue was that ndbmtd (the multi-threaded data node) needs memory barriers for the magic message passing stuff between threads. So, that’s pretty easy (about an eight line patch).

The next issue was in the …

  [Read more...]
The Story of One Contribution
Employee_Team +1 Vote Up -0Vote Down

The MySQL Server 5.7.5 Development Milestone Release includes support for acquiring multiple user-level locks within the same connection. The implementation of this feature is based on a contributed patch by Konstantin Osipov. This post tells the story about what happened with this patch on its way into the MySQL Server codebase.

If you are more interested in using this new functionality and the feature itself, rather than in the history behind it, then it is better to simply read the …

  [Read more...]
Encrypting Data In MySQL With Go
+1 Vote Up -0Vote Down

A SaaS product needs to use security measures you might not ordinarily use in an on-premises solution. In particular, it’s important that all sensitive data be secured. Encryption plays an important role in information security. At VividCortex, we encrypt data in-flight and at-rest, so your sensitive data is never exposed.

We use Go and MySQL extensively at VividCortex and thought other Go programmers might be interested to see how we’ve integrated encryption into our services layer (APIs).

Encryption Techniques

At a high level, you can think of two kinds of data encryption inside of MySQL or any similar data store. I’ll …

  [Read more...]
Impressions from MongoDB Day London 2014
+0 Vote Up -0Vote Down

I visited MongoDB Day in London on November 6. Here are a few observations:

App-Developer Centric. It is interesting to see how much MongoDB is about developers; the ops side is something which is a necessary evil developers have to deal with. The ops topics covered in principle that there are no topics about choices of operating systems or hardware for MongoDB beyond flash and more memory.

Development Stacks. Being application centric there was good coverage of the MongoDB-powered …

  [Read more...]
Semi-automatic slave/master promotion via Pseudo GTID
+0 Vote Up -0Vote Down

Orchestrator release 1.2.7-beta now supports semi-automatic slave promotion to master upon master death, via Pseudo GTID.

When the master is dead, orchestrator automatically picks the most up-to-date slaves and …

  [Read more...]
Dynamic compound statements in MariaDB
+0 Vote Up -0Vote Down

A long-ago-discussed and much-requested feature, "dynamic compound statements", is working at last.

It's been eleven years since the original discussion of dynamic compound statements for MySQL, as you can see by looking at the worklog task on the wayback machine. (As usual, you have to click the "high level architecture" box to see the meat of the specification.) The essential idea is that one can directly enter compound statements like BEGIN ... END and conditional statements like "IF ... END IF" and looping statements …

  [Read more...]
Disabling InnoDB in MySQL 5.6 and MariaDB 10.0
+0 Vote Up -0Vote Down

There are a few circumstances where one will not want to run with only MyISAM tables. In this case, it can be beneficial to completely disable InnoDB.

As InnoDB has become more prevalent, disabling it in MySQL requires a little more effort than before.

In MariaDB 10.0, you can still completely disable it as you have done in the past (just add the –skip-innodb option, specify default-storage-engine=MyISAM, and comment out other InnoDB options):

[mysqld]
skip-innodb
default-storage-engine=MyISAM

Alternatively, instead of –skip-innodb, you can instead use “innodb=OFF”:

[mysqld]
skip-innodb …
  [Read more...]
Resolving “Unknown storage engine ‘InnoDB’” Error when Running MyISAM-only and Upgrading to MySQL 5.6 or MariaDB 10.0
+0 Vote Up -0Vote Down

I know, what, MyISAM-only? Yes, it’s true, and it occurs more than you might think.

If you do run MyISAM-only, it’s common to have disabled InnoDB altogether (–skip-innodb) to avoid allocating any RAM to it, and to avoid unnecessary files required for backups, and so forth. (See this post if interested in disabling InnoDB in MySQL 5.6 and/or MariaDB 10.0.)

One improvement in MySQL 5.6 and MariaDB 10.0 is the addition of some system tables. The 2 that are in …

  [Read more...]
#DBHangOps 11/13/14 -- More Orchestrator, Dealing with logical corruption, and more!
+0 Vote Up -0Vote Down

#DBHangOps 11/13/14 -- More Orchestrator, Dealing with logical corruption, and more!

Hello everybody!

Join in #DBHangOps this Thursday, November, 13, 2014 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

  • More uses of Orchestrator for MySQL
  • Dealing with logical corruptions (a.k.a. a bug in my application changed data it shouldn't have...)
  • Mixing data and metadata

You can check out the event page at …

  [Read more...]
10 Newer Entries Showing entries 71 to 80 of 33479 10 Older Entries

Planet MySQL © 1995, 2014, 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.