The MySQL server supports a variety of client connection methods. To summarize: you have TCP/IP (v4 and v6) on all OSes (with or without TLS/SSL encryption), Unix Domain Sockets on Unix/Linux, and Named Pipes and/or Shared Memory on Windows.
Each of these connection methods has its own set of pros and cons: speed, security, portability, and ease-of-use.…
Why Should I Be Reading This?
To better understand how the MySQL Server functions, how to monitor the relevant server events, and find out what’s new in MySQL 5.7.8.
What’s Special About the Audit Plugin API?
Picking the right API for your new plugin is probably the most important design decision a plugin author will need to make.…
In this post I will try to explain the new MySQL binlog_error_action server
option. This new option is available from MySQL 5.6.22 and later.
Background:
——————–
As part of MySQL replication all data changes that happen on the
master server are recorded into a binary log so that they can be
sent to slave and replayed there. If an error occurs that
prevents mysqld from writing to the binary log (disk full,
readonly file system, etc.) then the logs are simply disabled and
operations continue on the master. This error mainly occurs
during rotation of the binary log or while opening a binary log
file.
This problem creates a serious potential for data loss …
[Read more]I'm happy to announce the release of mylvmbackup version 0.16. The source package is now available for download from http://lenzg.net/mylvmbackup/ and https://launchpad.net/mylvmbackup.
Installation packages for a number of platforms can be obtained from the openSUSE Build Service.
Version 0.16 adds support for sending out SNMP traps in case of backup successes or failures. I'd like to thank Alexandre Anriot for contributing this new feature and his patience with me.
Please see the ChangeLog and bzr …
[Read more]You’ve already read it in What’s new in 5.7 (So Far) — the MySQL server now has new-and-improved supported for syslog (on unix-like systems) and EventLog (on Windows). In the next few paragraphs, we’ll take a look at what they are, what has changed, and how they can make your life easier.
The MySQL server supplies information in two main ways:
SELECT, SHOW, etc.;
and even a successful statement may be qualified by a set of
warnings or notices. If the statement fails for some reason then
we’ll receive an error regarding the failure.
Introduction
InnoDB is a general-purpose storage engine that balances high reliability and high performance. It is a transactional storage engine and is fully ACID compliant, as would be expected from any relational database. The durability guarantee provided by InnoDB is made possible by the redo logs.
This article will provide an overview of the redo log subsystem or log subsystem of InnoDB. We will look at the following details:
There are many thing changed in MySQL 5.6 which are related to
passwords:
But that's not what this blog post is about.
This blog post is a great new feature: Hiding passwords from your
log files, automatically.
MySQL 5.6 will by default hide passwords from the general log.
This is not just obfuscation as only the one-way hash will be put
in the log files. By setting log-raw=OFF you can disable password
hiding for the general log. The log-raw setting will only
influence the general log, so the passwords in the slow query log
and the binary logs will still be hidden.
With MySQL 5.5 this could be done manually by …
As a follow up to the previous post about logstash, here are a couple of related init scripts for anyone implementing the OpenSource Log Analytics setup that is explained over at divisionbyzero. These have been tested on CentOS 6.3 and are based on generic RC functions from Redhat so they will work with Redhat, CentOS, Fedora, Scientific Linux, etc.
This post shows the construction process of the Syslog Audit plugin that was presented at MySQL Connect 2012. It is based on an environment that has the appropriate development tools enabled including gcc,g++ and cmake. It also assumes you have downloaded the MySQL source code (5.5.16 or higher) and have compiled and installed the system into the /usr/local/mysql directory ready for use.
The information provided below is designed to show the different components that make up a plugin, and specifically an audit type plugin, and how it comes together to be used within the MySQL service. The MySQL Reference Manual contains information regarding the plugin API and how it can be used, so please refer there for more detailed information. The code in this post is designed to …
[Read more]MySQL 5.1 or newer can sometimes start throwing a strange message into an error log. The message states that a query was unsafe for binary logging along with some additional information. What does it mean? Is it a problem?
From time to time you might spot MySQL error log filling with the following warning:
“[Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted. Statement: DELETE FROM score WHERE user_id = 12345 AND created = ’2012-04-15′ LIMIT 1″
If binary logging is enabled and the log format is set to
STATEMENT, MySQL generates such message when it
considers that a query is ambiguous and could behave differently
each time it executes against the same data set. Such situation
could happen, for example, on a …