I’ve had a look at a preview release of MySQL 5.7.8, some time before it became available to the general public (perks and duties of an Oracle ACE) and I found a few interesting things among the release notes and the tarball itself:

• There is a new tool named mysqlpump, which is intended as a replacement for mysqldump, with parallel processing, compression, progress watch, the long awaited ability of excluding databases or tables, and more.
• The json functionality has been fished out from the labs and added to the main distribution.

The MySQL Development team is very happy to announce that MySQL 5.7.8, the second 5.7 Release Candidate (RC2), is now available for download at dev.mysql.com (use the “Development Releases” tab).

We have fixed over 500 bugs in 5.7.8. This is on top of what we delivered in 5.7.7 and on top of bug fixes up-merged from 5.6.…

Hi,
I did the allow vulnerable ssl. Now I am getting the error
Debugger not attached
# Creating Auth-Type = digest
radiusd: #### Instantiating modules ####
/usr/local/etc/raddb/mods-enabled/redis[10]: Failed to link to module ‘rlm_redis’: /usr/local/lib/rlm_redis.so: cannot open shared object file: No such file or directory

Also, there is no rlm_redis in /usr/local/lib/. Sorry, But I am new to freeradius. Thank you for your help.

Percona is glad to announce the release of Percona XtraBackup 2.2.12 on August 3, 2015. Downloads are available from our download site or Percona Software Repositories.

Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups.

Bugs Fixed:

• Percona XtraBackup would segfault during the prepare …

After installing a MySQL database server and securing that installation with the mysql_secure_installation tool, you are locked out from remote access to perform any operation on the server. Since we all like the 'R' in RDBMS to stand for remote as well as relational, let's see how we can configure user credentials to provide remote access to the database server but still keep those credentials

In my recent benchmarks for MongoDB, we can see that the two engines WiredTiger and TokuMX struggle from periodical drops in throughput, which is clearly related to a checkpoint interval – and therefore I correspond it to a checkpoint activity.

The funny thing is that I thought we solved checkpointing issues in InnoDB once and for good. There are bunch of posts on this issue in InnoDB, dated some 4 years ago.  We did a lot of research back then working on a fix for Percona Server

• https://www.percona.com/blog/2011/04/04/innodb-flushing-theory-and-solutions/
• …

Combining Galera and asynchronous replication in the same MariaDB setup, aka Hybrid Replication, can be useful - e.g. as a live backup node in a remote datacenter or reporting/analytics server. We already blogged about this setup for Codership/Galera or Percona XtraDB Cluster users, but master failover did not work for MariaDB because of its different GTID approach. In this post, we will show you how to deploy an asynchronous replication slave to MariaDB Galera Cluster 10.x (with master failover!), using GTID with ClusterControl v1.2.10. 

Preparing the Master

First and foremost, you must ensure that the master and slave nodes are running on MariaDB Galera 10.0.2 or later. MariaDB replication slave requires at least a master with GTID among the Galera nodes. However, we would recommend users to configure …

VividCortex is sponsoring and exhibiting at AWS Re:Invent October 6 - 9 this year. We will be serving up hats and database monitoring demos, so come check us out!

Click here for more details and registration.

I have been working for a very large Australian website for over six years and during this period have been fortunate enough to hire many Infrastructure Operations Engineers that now work for that company. I want to detail the evolution of the hiring process and what I have driven it to over the last six years.
How was I hired This is the interview process I went through at my current company:

• A technical and cultural pre-screening from a recruiter
• A short phone interview with a small set of adhoc questions around technical skill set. How does DNS work?
• An hour long face to face interview with the hiring manager and another senior engineer testing both technical capability and culture fit
• Another hour long face to face interview with a HR representative testing cultural fit 
• Lastly, a reference check to confirm technical capability and cultural fit performed over …

http://dom.as/2015/07/30/on-order-by-optimization/

An insightful exploration by Domas (Facebook) on how some of the MySQL optimiser’s decision logic is sometimes naive, in this case regarding ORDER BY optimisation.

Quite often, “simple” logic can work better than complex logic as chasing all the corner cases can just make things worse – but sometimes, logic can be too simple.

Everything must be made as simple as possible, but no simpler.
— Albert Einstein / Roger Sessions