<?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...]
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 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...]
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).
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...]
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...]
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...]
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...]
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!
Join in #DBHangOps this Thursday, November, 13, 2014 at 11:00am pacific (18:00 GMT), to participate in the discussion about:
You can check out the event page at …[Read more...]