The latest from the MySQL community

#DBHangOps 08/06/15 -- Orchestrator and Binlog Servers and more!

Hello everybody!

Join in #DBHangOps this Thursday, August, 06, 2015 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

• Orchestrator and Binlog Servers from Shlomi Noach
• Configuration vs. Orchestration

You can check out the event page at https://plus.google.com/events/ci32euumljnmivfo8kkh9j8kum8 on Thursday to participate.

As always, you can still watch the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google hangout on Thursday!

See all of you on Thursday!

You can catch a …

Baron Schwartz will be speaking on Building Microservices with Go at OSCON EU on October 26th.

Below is an overview;

Go is great for building HTTP and RPC services. VividCortex’s infrastructure is Go-based, and there are a lot of lessons to learn from the experience building it. Here are some of the things we needed to do above and beyond what the standard libraries provide:

• Using net/http effectively
• Building an actually sane REST framework in Go
• Dealing with garbage collection
• Building a build system
• Continuous integration and deployment
• Running services (daemons)
• Runtime inspection of all in-flight requests
• Interacting with databases, caches, and queues
• Building staging and development environments

Baron Schwartz will be speaking on Building Microservices with Go at OSCON EU on October 26th.

Below is an overview;

Go is great for building HTTP and RPC services. VividCortex’s infrastructure is Go-based, and there are a lot of lessons to learn from the experience building it. Here are some of the things we needed to do above and beyond what the standard libraries provide:

• Using net/http effectively
• Building an actually sane REST framework in Go
• Dealing with garbage collection
• Building a build system
• Continuous integration and deployment
• Running services (daemons)
• Runtime inspection of all in-flight requests
• Interacting with databases, caches, and queues
• Building staging and development environments

This is getting more and more common, so I wanted to provide the steps required to get LDAP authentication working with MariaDB PAM plugin.

Unless you’re already familiar with setting up the MariaDB PAM plugin, I’d first recommend getting this to work with a standard Linux user (steps 1-4), then once all is working fine, progress to the LDAP users (steps 5-10). (And if you do not want to test this for the Linux user account, then you may skip steps #2 and #3.)

1. Enable plugin by running the following from the command line client:

   INSTALL SONAME 'auth_pam';

   You should see an entry like this afterward in SHOW PLUGINS:

       | pam | ACTIVE | AUTHENTICATION | auth_pam.so | GPL |

2. Create the mysql user account (note it does not have a password, as it will obtain this from your Linux user, and eventually the LDAP account) and provide it with the GRANTS you want it to …

MySQL 5.7.8-rc2 was released today, and features a new server utility called mysqlpump. This utility contains a number of major improvements over mysqldump including:

• Parallel processing of databases, and of objects within databases, to speed up the dump process
• For dump file reloading, faster secondary index creation for InnoDB tables by adding indexes after rows are inserted
• Better control over which databases and database objects (tables, views, stored programs, user accounts) to dump
• Dumping of user accounts as account-management statements (CREATE USER, GRANT) rather than as inserts into the mysql system database
• Capability of creating compressed output
• Progress indicator

What I wanted to caution however, is that mysqlpump is not currently consistent. …

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