Alvarez will help deliver industry-leading database management services to the Asia-Pacific region

OTTAWA, Ontario — September 8, 2014 — Pythian, the global leader in data management consulting and services, today appointed Francisco Alvarez as Vice President, Asia Pacific to oversee the company’s regional expansion effort and deliver high-level database and data infrastructure support to an underserved region.

In his new role, Alvarez will oversee a team of more than 50 Pythian experts. Alvarez will be based out of Pythian’s Macquarie Park, Australia office and be responsible for extending Pythian services in major practice areas, including Oracle, MySQL, Microsoft SQL Server, big data, DevOps, and system administration. He will also manage all Pythian user groups in the Asia-Pacific region.

“In a career spanning more than two …

By Holger Kenn

A few weeks ago, I was looking into running a MySQL Galera Cluster for a customer with a large Linux IAAS deployment on Azure.

Why that? There’s ClearDB, a Microsoft Partner that offers MySQL on Azure as SaaS (Software as a service), so you can go to https://www.cleardb.com/store/azure and pick your size. Or, if you want to run it on your own, you can pick a Ubuntu Linux Gallery image and type “apt-get install mysql-server” and that’s it, right? Well, not so fast…

ClearDB is a great offering for most customers that need a MySQL backend, but in this case, even the largest ClearDB offer was not sufficient.

So the customer followed the second path down, he created an IAAS VM (actually several VMs which each run an independent database server for different purposes) and configured his services to use these …

pt-query-digest is a tool available from Percona for analysis of MySQL queries from slow log, general log and binary log files. It can also analyze queries from mysql processlist and tcpdump mysql data. It is one of the best tools for slow query analysis on mysql server and can help you to improve mysql performance and efficiency. This tool is part of Percona Toolkit, the well-known MySQL management software utility toolkit for MySQL server administration (of course it also works on MariaDB and Percona Server). Formerly, percona toolkit was known as maatkit and pt-query-digest was called mk-query-digest. It has lots of options available to explore. In this post we'll compare some of the different sources pt-query-digest can use.

Slow query logs

MySQL can log …

pt-query-digest is a tool available from Percona for analysis of MySQL queries from slow log, general log and binary log files. It can also analyze queries from mysql processlist and tcpdump mysql data. It is one of the best tools for slow query analysis on mysql server and can help you to improve mysql performance and efficiency. This tool is part of Percona Toolkit, the well-known MySQL management software utility toolkit for MySQL server administration (of course it also works on MariaDB and Percona Server). Formerly, percona toolkit was known as maatkit and pt-query-digest was called mk-query-digest. It has lots of options available to explore. In this post we'll compare some of the different sources pt-query-digest can use.

Slow query logs

MySQL can log …

Stored routines give you the ability to create a statement in one application (MySQL) that can be used in multiple client applications that use different programming languages or work on different platforms.

Take the MySQL for Developers course to learn more about stored routines and other key topics. This will build your expertise as a MySQL Developer.

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

• Live-Virtual Event: Attend a live-event from your own desk, no travel required. Choose from a selection of events already on the schedule to suit different timezones.
• In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.

Taxonomy upgrade extras:  myenv operation MySQL Operations multi instance consolidation Backup catalog

FromDual has the pleasure to announce the release of the new version 1.1.1 of its popular MySQL, MariaDB and Percona Server multi-instance environment MyEnv.

The majority of improvements happened in the MySQL Backup Manager (mysql_bman) where we added a …