Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Percona announces the release of Percona XtraDB Cluster 5.6.35-26.20 on March 10, 2017. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.6.35-26.20 is now the current release, based on the following:
All Percona software is open-source and free. Details of this …
[Read more]As we saw earlier, it might be challenging for companies to move their data out of RDS for MySQL. In the first part of this blog, we showed you how to set up your target environment on EC2 and insert a proxy layer (ProxySQL) between your applications and RDS. In this second part, we will show you how to do the actual migration of data to your own server, and then redirect your applications to the new database instance without downtime.
Copying data out of RDS Related resources MySQL in the Cloud - Online Migration from Amazon RDS to EC2 instance (part 1) …
[Read more]In our previous blog, we saw how easy it is to get started with RDS for MySQL. It is a convenient way to deploy and use MySQL, without worrying about operational overhead. The tradeoff though is reduced control, as users are entirely reliant on Amazon staff in case of poor performance or operational anomalies. No access to the data directory or physical backups makes it hard to move data out of RDS. This can be a major problem if your database outgrows RDS, and you decide to migrate to another platform. This two-part blog shows you how to do an online migration from RDS to your own MySQL server.
We’ll be using EC2 to run our own MySQL Server. It can be a first step for more complex migrations to your own private datacenters. EC2 gives you access to your data so xtrabackup can be used. EC2 also allows you to setup SSH tunnels and it removes …
[Read more]Codership QA Engineer
The QA Engineer/release manager will be responsible for working with the development team at Codership and create and execute tests, make builds of Galera Cluster and develop and extend test automation frameworks.
You will be also working closely with MariaDB development and quality assurance teams to prioritize software bug fixes.
Tasks
Desired Skills and Experience
In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Access Privileges Issues webinar.
First, I want to thank everybody for attending the February 23 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I wasn’t able to answer during the webinar, with responses:
Q: Should the root@localhost user be given ALL privileges or Super privileges? Does All include Super privileges also?
A: Yes, you should have a user with all privileges. Better if this …
[Read more]So you’re interested in the “new” MySQL Group Replication feature but are concerned that configuring it is going to be difficult. Let me soothe those concerns with this blog post. Yes, the MySQL team has recently been discussing other methods to configure Group Replication using the RC release of MySQL Shell and how it can be used… Read More »
Dear MySQL users,
MySQL Connector/J 6.0.6 m5 Development Release is a developer
milestone
release for the 6.0.x series.
This release includes the following new features and changes,
also described
in more detail on
https://dev.mysql.com/doc/relnotes/connector-j/6.0/en/news-6-0-6.html
As always, we recommend that you check the “CHANGES” file in the
download
archive to be aware of changes in behavior that might affect your
application.
To download MySQL Connector/J 6.0.6 m5, see the
“Development
Releases” tab at http://dev.mysql.com/downloads/connector/j/
Enjoy!
Changes in MySQL Connector/J 6.0.6 (2017-03-10, Milestone 5)
Version 6.0.6 Milestone is the fifth development …
[Read more]Intro
In a set of blog posts I will explain to you how different attacks on the network traffic of MySQL look like and what you can do to secure your systems againt these kinds of attacks.
How to gain access
To gain access to MySQL network traffic you can use tcpdump, dumpcap, snoop or whatever the tool to capture network packets on your OS is. This can be on any device which is part of the connnection: the server, the client, routers, switches, etc.
Besides application-to-database traffic this attack can also be done on replication traffic.
Results
This allows you to extract queries and result sets.
The default password hash type mysql_new_password
uses a nonce to protect against password sniffing. But when you
change a password this will be sent accross the wire by default.
Note that MySQL 5.6 and newer has …
In this blog post, we’ll discuss services monitoring using probabilistic fault detection.
Let’s admit it, the task of monitoring services is one of the most difficult. It is time-consuming, error-prone and difficult to automate. The usual monitoring approach has been pretty straightforward in the last few years: setup a service like Nagios, or pay money to get a cloud-based monitoring tool. Then choose the metrics you are interested in and set the thresholds. This is a manual process that works when you have a small number of services and servers, and you know exactly how they behave and what you should monitor. These days, we have hundred of servers with thousands of services sending us millions of metrics. That is the first problem: the manual approach to configuration doesn’t work.
That is not the only problem. We know that no two servers perform the same because no two servers have exactly the …
[Read more]This tutorial explains how to install ISPConfig 3 latest development version using a Debian stretch repository with its respective Debian packages. The objective of this tutorial is more for experimental and testing purposes than for productive environments.
