MySQL Central @ OpenWorld is only 20 days away! It is therefore time to start planning your conference, and Schedule Builder is a useful tool we recommend to use.

On Monday, September 29, you have the opportunity to attend MySQL tutorials. Each tutorial will last 2 hours and help you acquire in-depth knowledge on a number of MySQL topics. You will be able to choose from:

10:15 am - 12:15 pm

How to Analyze and Tune MySQL Queries for Better Performance
Øystein Grøvlen, Senior Principal Software Engineer, Oracle

Moscone South - 250

…

Are you using or interested in learning more about MySQL? Are you attending Oracle OpenWorld and looking for an opportunity to meet and exchange ideas or experiences with MySQL users?

Join us on Tuesday, September 30, 2014 to celebrate the dynamics and growth of the MySQL community. Whether you are attending MySQL Central @ OpenWorld, a member of local MySQL user groups, a MySQL user in the Bay Area, or simply interested in MySQL technology, you're all invited to Oracle's MySQL Community Reception.

• Mingle with your peers and learn from real-world experiences.
• Talk to MySQL engineers face-to-face and get the first-hand information on the latest product development.

Time: Tuesday, September 30, 2014 @ 7:00 p.m. - 9:00 p.m.

Location: Jillian's at Metreon …

Podcasts Performance Query Optimization Server Tuning

This week, we discuss common MySQL performance tips.

Podcasts Performance Query Optimization Server Tuning

This week, we discuss common MySQL performance tips.

September 9, 2014 By Severalnines

We are excited to announce the availability of YUM/APT repositories for ClusterControl, making new releases of ClusterControl  easily accessible using YUM or APT package managers. The repo is found at http://repo.severalnines.com, with instructions provided on the landing page. Our Cluster Configurators will be using these repositories. As a result, users upgrading from s9s_upgrade_cmon starting from version v.1.2.8 will be configured with the package repository.

ClusterControl requires extra post-installation setup steps, such as generating an API token, configuring cmon/dcps database schema, grant privileges on cmon schema, setting up SSL and so on. We provide a post-installation script for this purpose at [Apache document …

Dear MySQL users,
MySQL Connector/Net 6.9.3 is the first GA release for the 6.9.x series of the .NET driver for MySQL. It can be used for production environments.
It is appropriate for use with MySQL server versions 5.5-5.7.
It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloadsandmirrorsites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)
Enjoy and thanks for the support!
On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team.

When a write query is sent to Percona XtraDB Cluster all the nodes store the writeset on a file called gcache. By default the name of that file is galera.cache and it is stored in the MySQL datadir. This is a very important file, and as usual with the most important variables in MySQL, the default value is not good for high-loaded servers. Let’s see why it’s important and how can we calculate a correct value for the workload of our cluster.

What’s the gcache?
When a node goes out of the cluster (crash or maintenance) it obviously stops receiving changes. When you try to reconnect the node to the cluster the data will be outdated. The joiner node needs to ask a donor to send the changes happened during the downtime.

The donor …

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 …