Dear MySQL users,

The MySQL Workbench team announces availability of version 6.1.7 of its
flagship product. MySQL Workbench 6.1.7 is a periodic maintenance release
including 17 bug fixes. Additionally, the supported Linux distribution list has been
refreshed. Users of the product are recommended to upgrade to this version.

MySQL Workbench 6.1

With over 30 new features, this version has many significant
enhancements focusing on real-time performance assessment and analysis
from the SQL statement level to server internals and file IO. You can
see this from additions to the SQL Editor as well as new dashboard
visualization and reporting that take advantage of MySQL Server 5.6
and 5.7 Performance Schema, and enhancements to the MySQL Explain Plans.

Additionally Workbench 6.1 is leveraging work from various teammates in
MySQL Engineering by …

Understanding and installling the components of the LAMP stack are the first steps to learning the role of Linux, the Apache Server, MySQL and PHP in developing web applications. To learn more, take the MySQL and PHP - Developing Dynamic Web Application training course.  

You can take this 4-day, instructor-led course as a:

• Live-Virtual Event: Take this class from your own desk, no travel required. Choose from events already on the schedule to suit different time-zones. These events are delivered in English.
• In-Class Event: Travel to an education center to take this class, for example at

While working on data recovery cases I had been maintaining Data Recovery Tool for InnoDB. It proved to be useful in most of disaster scenarios, but still has some limitations:

• page_parser is slow. It scans a stream of bytes in order to find InnoDB pages. Being single-threaded it couldn’t leverage power of modern multi CPU servers. The same time customer’s databases tend to grow. It’s not uncommon to see over terabyte databases (I recovered once as large as 100 terabytes database!). Taking this into account recovery time quite often was painfully long.
• You have to recompile constraints_parser for every table. It takes long if there are many tables. To make it worse constraints_parser isn’t very smart about memory allocation, so a binary required about 250MB. Thus, to …

Today, we officially announced the fact that Blackbird.io has been acquired by Pythian.  I first met its founder, Paul Vallee, in 2007. Paul reached out to me about joining Pythian to found a San Francisco presence.  At the time, I was one year into PalominoDB, and was having such a good time being my own boss and building a business that I politely declined.  Since then, Paul and I have caught up at PerconaLive (O’Reilly’s MySQL conf for you old schoolers) regularly - using the time to catch up, share successes (and failures), and discuss the marketplace at large.  We’ve also competed, healthily and as good sports.  

Over those 6 years since that first contact, I’ve also fallen in love with the world of open-source data, both big and small.  I’ve enjoyed working on the IOUG mysql conference, presenting at Percona Live, Kaleidoscope, Velocity and more.  I’ve …

1. Backup script

#!/bin/sh
# Fri Jun 27 10:44:49 2014
# done by dragkh
# usage: 
# cat /etc/cron.d/backupmysql 
# 0  3  *  *  *       root    /root/bin/clean.backup.hyperion.mysql.mydumper.daily.sh >>  /var/log/clean.backup.${HOSTNAME}.mysql.mydumper.daily.log 2>&1
# 35  3  *  *  *       root    /root/bin/backup.hyperion.mysql.mydumper.daily.sh >> /var/log/backup.${HOSTNAME}.mysql.mydumper.daily.log 2>&1

ROOT_BACKUP_DIR="/home/mydumper"

seik_date () {
if [ -z $1 ]
then
# cdate=`date +%Y-%m-%d\ %H:%M:%S\ %Z`; export cdate; echo $cdate
cdate=`date -R`; export cdate; echo $cdate
else

if [ -z ${2} ]
then
cdate=`date +%Y-%m-%d.%H.%M.%S`; export cdate; echo $cdate
else
cdate=`date "+%Y-%m-%d %H:%M:%S"`; export cdate; echo $cdate
fi

fi
}


function check_dir {
 test ! -d "${1}" && mkdir -p "${1}"
}


function set_cpu_threads {
    # set the threads one less than the existing 
    threads=$(cat /proc/cpuinfo  |  grep processor | tail -1 | awk …

MySQL Utilities are a set of tools provided by Oracle to perform many kinds of administrative tasks. When GTID-replication is enabled, 2 tools can be used for slave promotion: mysqlrpladmin and mysqlfailover. We will review mysqlrpladmin (version 1.4.3) in this post.

Summary

• mysqlrpladmin can perform manual failover/switchover when GTID-replication is enabled.
• You need to have your servers configured with --master-info-repository = TABLE or to add the --rpl-user option for the tool to work properly.
• The check for errant transactions is …

What is GTID? 

4c2ad77f-697e-11e3-b2c3-c80aa9f17dc4

• This is the server’s 128 bit identification number (SERVER_UUID). It identifies where the transaction was originated. Every server has its own SERVER_UUID.

What problems GTID solves?

• It is possible to identify a transaction uniquely across the replication servers. Make the automation of failover process much easier. There is no need to do calculations, inspect the binary log and so on. Just MASTER_AUTO_POSITION=1.
• At application level, it is easier to do WRITE/READ split. After a write on the MASTER, you have a GTID so just check if that GTID has been executed on the SLAVE that you use for reads.
• Development of new automation tools isn’t a pain now.

How can I implement it?

Three variables are needed in ALL servers of the …

The North Texas MySQL Uxer Group will meet July 14th in the Oracle office in Irving at 6PM. Part of the topic will be MySQL query & server tuning with MySQL Workbench and part will be a surprise from Oracle ACE, Oracle MySQL ACE, and IOUG big shot George Trujillo who was recently relocated to the Dallas / Fort Worth Area.

And yes, pizza will be served ’cause pizza makes user groups run.

6031 Connection Drive
Suite 900
Irving, TX 75039

In this blog post regarding MySQL for Excel features included since version 1.2.0, we are going to talk about a new option that is used along with Edit MySQLData operations; very useful when editing data in a multi-user environment. If you are not familiar with editing MySQL data it is very advisable that you visit our thorough blog post about that topic: How To - Guide to editing MySQL data within Excel.

Remember you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone. …

Here are a few videos those of you who are just getting started with Sphinx may find useful. The first video demonstrates a very simple implementation with Ubuntu, PHP, and MySQL. The second video is also about installing on Ubuntu. And, the last video discusses fulltext query syntax. Check ‘em out. Quick Start with Ubuntu [...]