As a continuation of previous post, now, I will show how to make a mysql plugin for ldap authentication.

Get the mysql-server source code at http://dev.mysql.com/downloads/mysql/ (http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.27.tar.gz/from/http://cdn.mysql.com/)

Installing necessary packages

yum groupinstall 'Development Tools'
yum install cmake ncurses-devel

Download source code, build and start MySQL Server

wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.27.tar.gz/from/http://cdn.mysql.com/
tar -xzf mysql-5.5.27.tar.gz
cd mysql-5.5.25

# Preconfiguration setup
groupadd mysql
useradd -r -g mysql mysql

# Beginning of source-build specific instructions
cmake .
make
make install

# Postinstallation setup
chown -R mysql .
chgrp -R mysql .
./scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data

cp support-files/mysql.server …

 I will be presenting MySQL Replication with the MySQL 5.6 features at the Ohio LinuxFest 2012 Friday September 28th. I will only be attending the Friday sessions because I will be flying off to MySQL Connect as well. I look forward to the both of these events. It will be a great opportunity to meet with the MySQL Community.

Disclaimer: I went to this group because as soon as I heard about a “Virtual Self-Study Group,” I realized I wanted to see it happen for beginning MySQL administration, writing queries, and optimizing queries.

At Northeast PHP.

slides are available

Gene Babon decided he was going to make an online, virtual self-study group so that folks could learn beginning PHP. He has since gone on to create virtual self-study groups for learning HTML5 and JQuery.

Define the problem: There is a talent shortage and a skills gap. [and we have this in the MySQL community as well]

Offering a solution
Maximize the “downtime” in the non-meetup, non-conference time for a virtual group.

How a virtual meetup …

This week, we talk about the MySQL Connect format, and present our "Guide to MySQL Connect for Developers" and the few tech talks we think both DBAs and developers will find useful. In Ear Candy, we talk about how InnoDB stores the binary log position of the last successfully executed statement in its recovery logs. In At the Movies, we highlight Andrew Aksyonoff's talk on Sphinx at SkySQL's MySQL solutions day last April.

Events
FrOSCon will be held Saturday and Sunday, August 25th - 26th at the University of Applied Sciences Bonn-Rhein-Sieg in Germany. Registration is a small fee for personal attendees, only 5 euros. It is more for corporate attendees. There will be a MySQL and friends room this year, as in years past.

read more

Keith Larson: Thank you for allowing me to do this interview with you. What have you and Continuent been up to lately?

Giuseppe Maxia:  Hi Keith. It's my pleasure.  I (and the whole team at Continuent) have been quite busy releasing version 1.5.1 of our flagship clustering and HA product, Tungsten Enterprise. Apart from the pleasure of the growing business that makes us all very happy, we enjoy the rare geeky joy of working at a product at the highest levels of innovation and technical effectiveness.

 I am also happy, at a personal level, because my current job keeps me in touch with the MySQL community. The products that we develop, both the open source and the commercial solutions, depend heavily on the ubiquity of MySQL. When I dedicate some time to the MySQL community, I am doing at the same time something that I like and that is ultimately beneficial for my company's business. For this reason, my …

The linux command line is a familiar place for many MySQL DBAs. While we are comfortable with the command line, MySQL Workbench is still worth a look. The latest release at the time of this posting is 5.2.41 .

Workbench development has been rapid as of late. The MySQL Utilities are a series of customizable Python scripts and they will allow you to really take advantage of the new MySQL 5.6 upcoming features.  They come with MySQL Workbench or available via Launchpad. They have been getting a lot of attention lately because of the great features they offer.

MySQL Workbench now also offers a Data Migration Wizard. I got some time to test this new feature so I have included a simple …

I have the goal of authenticate MySQL users with an LDAP server, currently, employees of my company are authenticated in several services (ftp, ssh, svn) through my LDAP server, except MySQL. (As you can imagine, I need to add manually every user in MySQL, a very tedious task).

In this post I only leave the example with LDAP authentication.

Installing necessary packages

yum groupinstall 'Development Tools'
yum install openldap-devel

Source ldapClient.c

#include <stdio.h>
#include <ldap.h>
/* LDAP Server settings */
#define LDAP_SERVER "ldap://nafiux.com:389"
int
main( int argc, char **argv )
{
LDAP        *ld;
int        rc;
char        bind_dn[100];

/* Get username and password */
if( argc != 3 )
{
perror( "invalid args, required: username password" );
return( 1 );
}
sprintf( bind_dn, "cn=%s,ou=People,dc=nafiux,dc=com", argv[1] );
printf( "Connecting as %s...\n", …

I have had a few short weeks due to vacation time, so I have not posted one of these in a while. In the past few weeks I have done a lot of puppet configuration, including adding a MariaDB package install/configuration to our setup. I hope to consolidate our puppet configs to have only one MySQL manifest, right now there are three in use. Another theme to our work has been cleaning up legacy users and databases. Here is what the database team has accomplished in the past few weeks:

• Helped upgrade the firmware on a staging server (only to find out it had already been upgraded…isn’t that always the way?)
  
• Updated the downtime window for our db backup servers because we are adding more servers to it, and thus the backups are taking longer.
  
• Updated several Bugzilla bugs that had malformed …

In my quest to understand spatial GIS functionality, I have come to the ultimate goal: evaluation the actual database products themselves.

PostgreSQL / PostGIS

PostGIS is a variant of PostgreSQL with spatial extensions. The main reason for maintaining the GIS feature set outside of PostgreSQL proper seems to be licensing: the spatial extensions are LGPL GPL licensed.

PostGIS is widely recognized as the most mature and feature-rich GIS implementation for SQL databases (and perhaps any database), matched only by the costly Spatial extension for the Oracle Enterprise database. (See comparisons in the links below.)

read more

Recently I had a case when a customer deleted the InnoDB main table space – ibdata1 – and redo logs – ib_logfile*.

MySQL keeps InnoDB files open all the time. The following recovery technique is based on this fact and it allowed to salvage the database.

Actually, the files were deleted long time ago – 6 months or so. As long as file is open physically it still exits in the file system and reachable to processes which have opened it.

Thus, from user perspective nothing has changed after the deletion. By the way, this is a good reason to monitor existence of these files!
But after the restart InnoDB will detect that there is neither system table space nor log files, so it will create empty ones. The InnoDB dictionary will be empty and InnoDB won’t be able to use a bunch of existing ibd files. This situation will be a job for …