(Chris Calender) 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.
Tag: Open Source
Tutorial Introduction to working with Groups in MySQL Fabric
(Narayanan Venkateswaran) This blog deals with working with high availability in Fabric. It focuses on Creating MySQL Fabric groups, adding servers and working with the servers in the Fabric groups. The blog also includes an example that can be run to insert data and fetch from a Fabric group.
Encrypting Data In MySQL With Go
(Baron Schwartz) 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,
Resolving ‘Unknown storage engine ‘InnoDB’ Error when Running MyISAM-only and Upgrading to MySQL 5.6 or MariaDB 10.0
(Chris Calender) I know, what, MyISAM-only? Yes, it’s true, and it occurs more than you might think. 🙂
Active-Active Replication, Performance Improvements & Operational Enhancements – some of what’s available in the new MySQL Cluster 7.4.2 DMR
(Andrew Morgan) Oracle have just made availble the new MySQL Cluster 7.4.2 Development Milestone Release – it can be downloaded from the development release tab here. Note that this is not a GA release and so we wouldn’t recommend using it in production.
Resizing the InnoDB Buffer Pool Online
(Yasufumi Kinoshita) As described in the MySQL 5.7 manual here, we can now resize the buffer pool without restarting the mysqld process starting with MySQL 5.7.5.
Inside Distributed Architectures: Seeing In-Flight Requests And Blockers in Realtime
(Baron Schwartz) VividCortex’s SaaS backend is a service-oriented architecture, which means that in addition to our external APIs that our agents and web UI use, we also have internal APIs. Deploy a bunch of API servers across a cluster of machines, hook everything up and make all the parts talk to
Throttling MySQL Enterprise Backup with cgroups
(Daniel van Eeden) Today I encountered a situation where MySQL Enterprise Backup caused to much load on the I/O subsystem of the server to cause the application to be so slow that it wasn’t usable any longer. So I wanted to limit the mysqlbackup process so it wouldn’t cause any more issues.
Data inconsistencies on MySQL replicas: Beyond pt-table-checksum
(Stephane Combaudon) Percona Toolkit’s pt-table-checksum is a great tool to find data inconsistencies between a MySQL master and its replicas. However it is sometimes not enough to know that there are inconsistencies and let pt-table-sync fix the issue: you may want to know which exact rows are diff
MySQL Query Performance Statistics In The Performance Schema
(Baron Schwartz) We’ve recently added the ability to monitor MySQL query performance statistics from MySQL’s PERFORMANCE_SCHEMA, and there were a number of lessons learned. There are definitely right and wrong ways to do it.