In July, I first wrote that we are currently working on a new data dictionary for MySQL. We have since shipped a labs release where you can try it out for yourself and then send us feedback!
Today, I wanted to write about our upgrade plan from the old data dictionary to the new data dictionary. Or more specifically, explain one of the nuances that we currently have with encoding characters that are not safe on all filesystems.
To quote from the MySQL manual:
For example, if a …
[Read more]
By default in MySQL 5.6, each time MySQL is
started (regular start or crash recovery), it iterates through
all the binlog files when GTIDs are not enabled. This can take a
very long time if you have a large number of binary log files.
MySQL and Percona Server 5.6.21+ have a fix with the
simplified-binlog-gtid-recovery option. Let’s
explore this issue.
Understanding the issue
It was first reported by Yoshinori @ Facebook (bug #69097).
Let’s start by looking at a MySQL 5.6 instance where binary logging is enabled but GTIDs are disabled.
If we restart MySQL with strace, we’ll see:
# strace -e open service mysql start
[...]
open("/var/lib/mysql5621/mysql-bin.000004", O_RDONLY) = 13 …[Read more]
Many of VividCortex’s customers have strict policies about Internet access from and to their database servers. As a longtime consultant who worked on many servers that lacked a direct connection to the Internet, I anticipated this. Since the beginning, VividCortex has been designed to work in deployment scenarios without requiring direct Internet access, and requiring no inbound access at all.
At the same time, the best way to trust what an agent-based system is sending off your servers is to inspect it. But VividCortex is designed for end-to-end encrypted access; our APIs are 100% JSON over HTTPS, with no non-HTTP access permitted anywhere on any of our web properties. How can a customer inspect the traffic from agents to APIs if it’s encrypted?
It turns out that an HTTP proxy is the solution to both of these situations. You simply configure the agents to talk to the proxy, and the proxy relays traffic from and to the API. …
[Read more]Hey,
Did you check the mysql.log file for errors ? Its the best place to figure out silly mistakes that we generally make.
At Data2Day 2014 in Karlsruhe I talked about the Ceph Storage Cluster and us using it to store documents in CenterDevice. These are the slides (German) I used. If you are interested in Ceph and/or look for help implementing it, don't hesitate to contact me.
Permalink: http://bit.ly/1rNFRsO
The stripped down stored procedure shown below will accept any
Data Manipulation Language statement as its parameter and
automatically log the statement and create table backup copies
before the statement is executed. The logging functionality is
similar to MySQL's binary log but exclusive to DML statements and
is useful for table data recovery operations, such as undoing the
last table data change or to revert databases back to a certain
point in time. All this is done exclusively using stored routines
(procedures and functions).
Its assumed that the databases and tables that will be used are
already formed to specific business requirements since DDL
statements will not be logged by the stored procedure. Though
logging of table data changes can also be achieved using
triggers, it is not practical to alter each and …
December 1, 2014 By Severalnines
MariaDB 10 supports multi-source replication, and each MariaDB Galera node can have up to 64 masters connected to it. So it is possible to use a MariaDB Cluster as an aggregator for many single-instance MariaDB master servers.
In this blog post, we are going to show you how to setup multi-source replication with MariaDB Galera Cluster, where one of the Galera nodes is acting as slave to 3 MariaDB masters (see diagram below). If you would like to set this up with Percona XtraDB Cluster or Galera Cluster (Codership), please read this post instead.
MariaDB GTID vs MySQL GTID
MariaDB has a different implementation of Global Transaction ID (GTID), and is enabled by default starting from MariaDB 10.0.2. Multi-source replication in MariaDB works …
[Read more]
If you have a look on the last mysql 5.7.4 version or later you
will probably see that there are several security improvements.
The list of added security features and improvements can be seen
on the following page: http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
There are three main improvements that are shortly described in
this blog:
1. Nonempty plugin column
2. Password lifetime policy
3. mysql_install_db secured
Nonempty plugin column
As of MySQL 5.7.2, the server requires account rows in the
mysql.user table to have a nonempty
plugin column value and disables accounts with an
empty value. The following error will occor when trying to
connect with user having empty plugin colum:
2014-11-30T10:41:04.943384Z …
I spent the last 4 years at SkySQL/MariaDB working on versions of
MySQL that could be “suitable for the cloud”. I strongly
believed that the world needed a version of MySQL that could work
in the cloud even better than its comparable version on bare
metal. Users and administrators wanted to benefit from the use of
cloud infrastructures and at the same time they wanted to achieve
the same performance and overall stability of their installations
on bare metal. Unfortunately, ACID-compliant databases in the
cloud suffer from the issues that any centrally controlled and
strictly persistent system can get when hosted on highly
distributed and natively stateless infrastructures.
In this post I am not going to talk about the improvements needed
for MySQL in the cloud - I will tackle this topic in
a future post. Today I'd like to focus on the business side
of RDS and Aurora.
In the last 4 years I had endless discussions over …
This Log Buffer Edition brings some freshly picked blog posts
right out of the gardens of Oracle, SQL Server and MySQL.
Oracle:
Suppose you have a process A that you want to run faster. This process doesn’t commit (much), so it doesn’t wait on log file sync. However, there is another multi-threaded process, B, that commits very frequently, and spends a lot of time on “log file sync”.
New Solaris 11 CPU package to install and track CVE security fixes.
Upgrade/Migrate/Consolidate to Oracle 12c and Parallel Multitenant Upgrade Internals.
CVE metadata in Solaris …
[Read more]