Mar
27
2014
--

Percona Server 5.6.16-64.2 with TokuDB engine Beta is now available

id="attachment_13396" style="width: 257px" class="wp-caption alignright"> href="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Server.jpg"> class="size-full wp-image-13396 " alt="Percona Server version 5.6.15-64.2 with TokuDB engine" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Server.jpg" width="247" height="97" /> class="wp-caption-text">Percona Server version 5.6.16-64.2 with TokuDB engine

Percona is glad to announce the first BETA release of href="http://www.percona.com/software/percona-server">Percona Server 5.6.16-64.2 with href="http://www.tokutek.com/products/tokudb-for-mysql/">TokuDB engine on March 27th, 2014. Downloads are available href="http://www.percona.com/downloads/TESTING/Percona-5.6-TokuDB/beta/538/">here and from the Percona Software Repositories.

Based on Percona Server href="http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.16-64.2.html#5.6.16-64.2">5.6.16-64.2 including all the features and bug fixes in it, and on TokuDB 7.1.5-rc.4, Percona Server 5.6.16-64.2-tokudb is the first BETA release in the Percona Server 5.6 with TokuDB engine series. All of Percona‘s software is open-source and free, all the details of the release can be found in the href="https://launchpad.net/percona-server/+milestone/5.6.16-64.2">5.6.16-64.2 milestone at Launchpad.

New Feature

  • Installer will now automatically install and enable TokuDB engine on new installations.

More information on how to href="http://www.percona.com/doc/percona-server/5.6/tokudb/tokudb_installation.html#tokudb-installation">install and href="http://www.percona.com/doc/percona-server/5.6/tokudb/using_tokudb.html#using-tokudb">use TokuDB can be found in the documentation. This feature is currently considered BETA quality.

Release notes for Percona Server 5.6.16-64.2 with TokuDB storage engine are available in our href="http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.16-64.2-tokudb.html">online documentation. We did our best to eliminate bugs and problems during the testing this release, but this is a software, so bugs are expected. If you encounter them, please report them to our href="https://bugs.launchpad.net/percona-server/+filebug">bug tracking system.

The post rel="nofollow" href="http://www.mysqlperformanceblog.com/2014/03/27/percona-server-5-6-16-64-2-tokudb-engine-beta-now-available/">Percona Server 5.6.16-64.2 with TokuDB engine Beta is now available appeared first on rel="nofollow" href="http://www.mysqlperformanceblog.com/">MySQL Performance Blog.

Mar
25
2014
--

Percona Server 5.5.36-34.2 is now available

id="attachment_13396" style="width: 257px" class="wp-caption alignright"> href="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Server.jpg"> class="size-full wp-image-13396" alt="Percona Server version 5.5.36-34.2" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Server.jpg" width="247" height="97" /> class="wp-caption-text">Percona Server version 5.5.36-34.2

Percona is glad to announce the release of  href="http://www.percona.com/software/percona-server">Percona Server 5.5.36-34.2 on March 25th, 2014 (Downloads are available  href="http://www.percona.com/downloads/">here and from the  href="http://www.percona.com/doc/percona-server/5.5/installation.html">Percona Software Repositories). Based on  href="http://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-36.html">MySQL 5.5.36, including all the bug fixes in it, Percona Server 5.5.36-34.2 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the  href="https://launchpad.net/percona-server/+milestone/5.5.36-34.2">5.5.36-34.2 milestone at Launchpad.

This release fixes number of packaging bugs that were introduced in the last two releases.

Bugs Fixed:

  • The upgrade to Percona Server href="http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.36-34.1.html#5.5.36-34.1">5.5.36-34.1 would silently comment out any options in my.cnf that have paths specified that contain share/mysql. Bug fixed href="https://bugs.launchpad.net/percona-server/+bug/1293867">#1293867.
  • Percona Server could fail to start after upgrade if the lc-messages-dir option was set in the my.cnf configuration file. Bug fixed href="https://bugs.launchpad.net/percona-server/+bug/1294067">#1294067.
  • Dependency on mysql-common package, introduced in Percona Server href="http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.36-34.0.html#5.5.36-34.0">5.5.36-34.0 could lead to wrongly chosen packages for upgrade, spurious removes and installs with some combination of packages installed which use the mysql libraries. Bug fixed href="https://bugs.launchpad.net/percona-server/+bug/1294211">#1294211.
  • These three bugs were fixed by removing the dependency on mysql-common package.
  • href="http://www.percona.com/doc/percona-server/5.5/management/udf_percona_toolkit.html#udf-percona-toolkit">Percona Toolkit UDFs and href="http://www.percona.com/doc/percona-server/5.5/performance/handlersocket.html#handlersocket-page">HandlerSocket were missing from Debian/Ubuntu packages, this regression was introduced in Percona Server href="http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.36-34.0.html#5.5.36-34.0">5.5.36-34.0. Bugs fixed href="https://bugs.launchpad.net/percona-server/+bug/1296416">#1296416 and href="https://bugs.launchpad.net/percona-server/+bug/1294216">#1294216.
  • Percona Server installer will create the symlinks from libmysqlclient to libperconaserverclient during the installation on CentOS. This was implemented in order to provide the backwards compatibility after the libmysqlclient library has been renamed to libperconaserverclient .

Release notes for Percona Server 5.5.36-34.2 are available in our href="http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.36-34.2.html">online documentation. Bugs can be reported on the href="https://bugs.launchpad.net/percona-server/+filebug">launchpad bug tracker.

The post rel="nofollow" href="http://www.mysqlperformanceblog.com/2014/03/25/percona-server-5-5-36-34-2-now-available/">Percona Server 5.5.36-34.2 is now available appeared first on rel="nofollow" href="http://www.mysqlperformanceblog.com/">MySQL Performance Blog.

Mar
25
2014
--

Percona Server 5.6.16-64.2 is now available

id="attachment_13396" style="width: 257px" class="wp-caption alignright"> href="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Server.jpg"> class="size-full wp-image-13396 " alt="Percona Server version 5.6.16-64.2" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Server.jpg" width="247" height="97" /> class="wp-caption-text">Percona Server version 5.6.16-64.2

Percona is glad to announce the release of href="http://www.percona.com/software/percona-server">Percona Server 5.6.16-64.2 on March 25th, 2014. Downloads are available href="http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.16-64.2/" >here and from the Percona href="http://www.percona.com/doc/percona-server/5.6/installation.html#using-percona-software-repositories">Software Repositories.

Based on MySQL href="http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-16.html">5.6.16, including all the bug fixes in it, Percona Server 5.6.16-64.1 is the current GA release in the Percona Server 5.6 series. All of Percona’s software is open-source and free, all the details of the release can be found in the href="https://launchpad.net/percona-server/+milestone/5.6.16-64.2">5.6.16-64.2 milestone at Launchpad.

Bugs Fixed:

Release notes for Percona Server 5.6.16-64.2 are available in our href="http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.16-64.2.html">online documentation. Bugs can be reported on the href="https://bugs.launchpad.net/percona-server/+filebug">launchpad bug tracker.

The post rel="nofollow" href="http://www.mysqlperformanceblog.com/2014/03/25/percona-server-5-6-16-64-2-now-available/">Percona Server 5.6.16-64.2 is now available appeared first on rel="nofollow" href="http://www.mysqlperformanceblog.com/">MySQL Performance Blog.

Written by in: Events and Announcements,percona server,Percona Software,Zend Developer |
Mar
20
2014
--

Percona XtraDB Cluster 5.6.15-25.5 is now available

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/02/XtraDB-Cluster.jpg"> class="alignright size-full wp-image-12836" alt="Percona XtraDB Cluster 5.6.15-25.5" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/02/XtraDB-Cluster.jpg" width="237" height="82" /> /> Percona is glad to announce the new release of href="http://www.percona.com/software/percona-xtradb-cluster">Percona XtraDB Cluster 5.6 on March 20th 2014. Binaries are available from href="http://www.percona.com/downloads/">downloads area or from our href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/installation.html">software repositories.

Based on Percona Server href="http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.15-63.0.html">5.6.15-63.0 including all the bug fixes in it, href="https://launchpad.net/galera/+milestone/25.3.4">Galera Replicator 3.4 and on href="https://launchpad.net/codership-mysql/+milestone/5.6.16-25.5">Codership wsrep API 25.5 is now the current General Availability release in 5.6 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the href="https://launchpad.net/percona-xtradb-cluster/+milestone/5.6.15-25.5">5.6.15-25.5 milestone on Launchpad.

New Features

  • wsrep patch did not allow server to start with Query Cache enabled. This restriction and check have been removed now and query cache can be fully enabled from config file.
  • New href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/manual/xtrabackup_sst.html">SST options have been implemented: inno-backup-opts, inno-apply-opts, inno-move-opts which pass options to backup, apply and move stages of innobackupex.
  • The joiner would wait and not fall back to choosing other potential donor nodes (not listed in href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-system-index.html#wsrep_sst_donor">wsrep_sst_donor) by their state. This happened even when comma was added at the end. This fixes it for that particular case. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1285380">#1285380.
  • Initial configurable timeout, of 100 seconds, to receive a first packet via SST has been implemented, so that if donor dies somewhere in between, joiner doesn’t hang. Timeout can be configured with the href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/manual/xtrabackup_sst.html#sst-initial-timeout">sst-initial-timeout variable.

Bugs fixed

  • Replication of partition tables without binlogging enabled failed, partition truncation didn’t work because of lack of TO isolation there. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1219605">#1219605.
  • Using LOAD DATA INFILE in with autocommit set to 0 and href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-system-index.html#wsrep_load_data_splitting">wsrep_load_data_splitting set to ON could lead to incomplete loading of records while chunking. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1281810">#1281810.
  • Garbd could crash on CentOS if variable href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-provider-index.html#gmcast.listen_addr">gmcast.listen_addr wasn’t set. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1283100">#1283100.
  • Node couldn’t be started with href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-system-index.html#wsrep_provider_options">wsrep_provider_options option debug set to 1. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1285208">#1285208.
  • Boostrapping a node in a NON-PRIMARY state would lead to crash. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1286450">#1286450.
  • New versions of xtrabackup SST scripts were ignoring --socket parameter passed by mysqld. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1289483">#1289483.
  • Regression in Galera required explicitly setting href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-provider-index.html#socket.ssl">socket.ssl to Yes even if you set up variables href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-provider-index.html#socket.ssl_key">socket.ssl_key and href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-provider-index.html#socket.ssl_cert">socket.ssl_cert. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1290006">#1290006.
  • Fixed the clang build issues that were happening during the Galera build. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1290462">#1290462.
  • Better diagnostic error message has been implemented when href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-system-index.html#wsrep_max_ws_size">wsrep_max_ws_size limit has been succeeded. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1280557">#1280557.
  • Fixed incorrect warnings and implemented better handling of repeated usage with same value for href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-system-index.html#wsrep_desync">wsrep_desync. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1281696">#1281696.
  • Fixed the issue with href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-system-index.html#wsrep_slave_threads">wsrep_slave_threads wherein if the number of slave threads was changed before closing threads from an earlier change, it could increase the total number of threads beyond value specified in href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-system-index.html#wsrep_slave_threads">wsrep_slave_threads. Bug fixed href="https://bugs.launchpad.net/bugs/1290612">#1290612
  • A regression in mutex handling caused dynamic update of href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/wsrep-system-index.html#wsrep_log_conflicts">wsrep_log_conflicts to hang the server. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1293624">#1293624.
  • Presence of /tmp/test directory and an empty test database caused Percona XtraBackup to fail, causing SST to fail. This has been fixed in Percona XtraDB Cluster’s xtrabackup SST script, by using unique temporary directories with Percona XtraBackup. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1294760">#1294760.
  • After installing the auth_socket plugin any local user might get root access to the server. If you’re using this plugin upgrade is advised. This is a regression, introduced in Percona XtraDB Cluster 5.6.14-25.1. Bug fixed href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1289599">#1289599

Other bug fixes: href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1289776">#1289776, href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1279343">#1279343, href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1259649">#1259649, href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1292533">#1292533, href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1272982">#1272982, href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1287098">#1287098, href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1284670">#1284670, and href="https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1264809">#1264809.

Release notes for Percona XtraDB Cluster href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/release-notes/Percona-XtraDB-Cluster-5.6.15-25.5.html">5.6.15-25.5 are available in our href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/index.html">online documentation along with the href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/installation.html">installation and href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/upgrading_guide_55_56.html">upgrade instructions. We did our best to eliminate bugs and problems during the testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our href="https://bugs.launchpad.net/percona-xtradb-cluster/+filebug">bug tracking system.

Percona XtraDB Cluster href="http://www.percona.com/doc/percona-xtradb-cluster/5.6/errata.html">Errata can be found in our documentation.

The post rel="nofollow" href="http://www.mysqlperformanceblog.com/2014/03/20/percona-xtradb-cluster-5-6-15-25-5-now-available/">Percona XtraDB Cluster 5.6.15-25.5 is now available appeared first on rel="nofollow" href="http://www.mysqlperformanceblog.com/">MySQL Performance Blog.

Mar
17
2014
--

Percona Server 5.6.16-64.1 is now available

id="attachment_13396" style="width: 257px" class="wp-caption alignright"> href="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Server.jpg"> class="size-full wp-image-13396 " alt="Percona Server version 5.6.16-64.1" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Server.jpg" width="247" height="97" /> class="wp-caption-text">Percona Server version 5.6.16-64.1

Percona is glad to announce the release of href="http://www.percona.com/software/percona-server">Percona Server 5.6.16-64.1 on March 17th, 2014 (Downloads are available href="http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.16-64.1/" >here and from the Percona href="http://www.percona.com/doc/percona-server/5.6/installation.html#using-percona-software-repositories">Software Repositories.

Based on MySQL href="http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-16.html">5.6.16, including all the bug fixes in it, Percona Server 5.6.16-64.1 is the current GA release in the Percona Server 5.6 series. All of Percona’s software is open-source and free, all the details of the release can be found in the href="https://launchpad.net/percona-server/+milestone/5.6.16-64.1">5.6.16-64.1 milestone at Launchpad.

Bugs Fixed:

Renaming the libmysqlclient to libperconaserverclient

This release fixes some of the issues caused by the libmysqlclient rename to libperconaserverclient in Percona Server href="http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.16-64.0.html">5.6.16-64.0. The old name was conflicting with the upstream libmysqlclient.

Except for packaging, libmysqlclient and libperconaserverclient of the same version do not have any differences. Users who previously compiled software against Percona-provided libmysqlclient will either need to install the corresponding package of their distribution, such as distribution or href="http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-shared-5.5.36-1.linux2.6.x86_64.rpm">Oracle-provided package for CentOS and libmysqlclient18 for Ubuntu/Debian or recompile against libperconaserverclient. Another workaround option is to create a symlink from libperconaserverclient.so.18.0.0 to libmysqlclient.so.18.0.0.

Release notes for Percona Server 5.6.16-64.1 are available in our href="http://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.16-64.1.html">online documentation. Bugs can be reported on the href="https://bugs.launchpad.net/percona-server/+filebug">launchpad bug tracker.

The post rel="nofollow" href="http://www.mysqlperformanceblog.com/2014/03/17/percona-server-5-6-16-64-1-now-available/">Percona Server 5.6.16-64.1 is now available appeared first on rel="nofollow" href="http://www.mysqlperformanceblog.com/">MySQL Performance Blog.

Written by in: Events and Announcements,MySQL,percona server,Percona Software,Zend Developer |
Mar
17
2014
--

Percona Server 5.5.36-34.1 is now available

id="attachment_13396" style="width: 257px" class="wp-caption alignright"> href="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Server.jpg"> class="size-full wp-image-13396" alt="Percona Server version 5.5.36-34.1" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Server.jpg" width="247" height="97" /> class="wp-caption-text">Percona Server version 5.5.36-34.1

Percona is glad to announce the release of  href="http://www.percona.com/software/percona-server">Percona Server 5.5.36-34.1 on March 17th, 2014 (Downloads are available  href="http://www.percona.com/downloads/">here and from the  href="http://www.percona.com/doc/percona-server/5.5/installation.html">Percona Software Repositories). Based on  href="http://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-36.html">MySQL 5.5.36, including all the bug fixes in it, Percona Server 5.5.36-34.1 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the  href="https://launchpad.net/percona-server/+milestone/5.5.36-34.1">5.5.36-34.1 milestone at Launchpad.

Bugs Fixed:

Renaming the libmysqlclient to libperconaserverclient

This release fixes some of the issues caused by the libmysqlclient rename to libperconaserverclient in Percona Server href="http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.36-34.0.html">5.5.36-34.0. The old name was conflicting with the upstream libmysqlclient.

Except for packaging, libmysqlclient and libperconaserverclient of the same version do not have any differences. Users who previously compiled software against Percona-provided libmysqlclient will either need to install the corresponding package of their distribution, such as distribution or href="http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-shared-5.5.36-1.linux2.6.x86_64.rpm">Oracle-provided package for CentOS and libmysqlclient18 for Ubuntu/Debian or recompile against libperconaserverclient. Another workaround option is to create a symlink from libperconaserverclient.so.18.0.0 to libmysqlclient.so.18.0.0.

Release notes for Percona Server 5.5.36-34.1 are available in our href="http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.36-34.1.html">online documentation. Bugs can be reported on the href="https://bugs.launchpad.net/percona-server/+filebug">launchpad bug tracker.

The post rel="nofollow" href="http://www.mysqlperformanceblog.com/2014/03/17/percona-server-5-5-36-34-1-now-available/">Percona Server 5.5.36-34.1 is now available appeared first on rel="nofollow" href="http://www.mysqlperformanceblog.com/">MySQL Performance Blog.

Written by in: Events and Announcements,percona server,Percona Software,Zend Developer |
Mar
13
2014
--

Open Source Appreciation Day at the Percona Live MySQL Conference

I am very pleased to announce a new event in conjunction with the href="https://www.percona.com/live/mysql-conference-2014/">Percona Live MySQL Conference and Expo this year: href="http://www.percona.com/live/mysql-conference-2014/program/open-source-appreciation-day">Open Source Appreciation Day on Monday, March 31st in the Santa Clara Convention Center! We are pleased to announce two separate groups holding events this year under this new umbrella. We are hosting an event called “ href="http://www.percona.com/live/mysql-conference-2014/program/open-source-appreciation-day/openstack-today">OpenStack Today” for those interested in learning more about developments in the OpenStack world. CentOS is holding the “ href="https://www.percona.com/live/mysql-conference-2014/program/open-source-appreciation-day/centos-dojo-santa-clara">CentOS Dojo Santa Clara” event. Registration is required, as space is limited, but the events are both free to attendees.

OpenStack Today

href="http://www.percona.com/live/mysql-conference-2014/program/open-source-appreciation-day/openstack-today">OpenStack Today will cover deployments in this rapidly evolving ecosystem. OpenStack is the fastest growing open source cloud infrastructure project today. Organizations are creating private OpenStack clouds in their datacenters or deploying applications to public OpenStack clouds and MySQL is at the heart of those deployments. Attendees will learn the latest trends in OpenStack and how MySQL fits into the OpenStack roadmap. Speakers from hastexo, Mirantis, Tesora, Scalr, and Percona will present. For the full agenda, visit the href="http://www.percona.com/live/mysql-conference-2014/program/open-source-appreciation-day/openstack-today">event webpage on the Percona Live website.

CentOS Dojo Santa Clara

href="http://www.percona.com/live/mysql-conference-2014/program/open-source-appreciation-day/centos-dojo-santa-clara">CentOS Dojo Santa Clara will bring people from the CentOS communities together to talk about systems administration, best practices and emerging technologies. CentOS Dojo events emphasize local speakers and tutors that come together and discuss things that they care about most and to share stories from their experiences working with CentOS in various scenarios. Attendance is limited to ensure there are plenty of opportunities for everyone to interact and establish social connections to carry the conversations through the future. For the full agenda, visit the href="https://www.percona.com/live/mysql-conference-2014/program/open-source-appreciation-day/centos-dojo-santa-clara">event webpage on the Percona Live website.

Both events are free but space is limited to 75 people for the CentOS event and 100 people for the OpenStack event. Attendees may only register for only one of these events, not both.

I wish to thank CentOS and Tesora who are helping sponsor these events.

Open Source Appreciation Day

class="alignleft" title="Open Source Appreciation Day at the Percona Live MySQL Conference" alt="Open Source Appreciation Day at the Percona Live MySQL Conference" src="http://www.percona.com/static/images/percona_live_logo_blacktext.png" width="240" height="69" />I’m happy that Open Source Appreciation Day came together. We have been in discussions with a few open source projects about organizing events for the Monday before the conference. For those who attended the Percona Live MySQL Conference in 2013, you know that it was held on a Monday through Thursday. We had to move the conference to Tuesday through Friday this year because we couldn’t start moving into the facilities until Monday and it takes a full day to create the awesome experience conference attendees will enjoy (for those planning to attend Percona Live in 2015, we’ll be back to a Monday through Thursday event , April 13-16). But we have some meeting space available upstairs in the Santa Clara Convention Center this year on Monday that is perfect for meetings of 50 to 100 people. We decided to put the rooms to good use and launch Open Source Appreciation Day in cooperation with CentOS and multiple organizations and speakers from the OpenStack ecosystem. We reached out to other open source projects but were unable to pull together events for other projects.

I look forward to a great Percona Live conference this year. And I hope that Open Source Appreciation Day will prove to be popular with those within, and maybe even previously outside, the MySQL community.

The post rel="nofollow" href="http://www.mysqlperformanceblog.com/2014/03/13/open-source-appreciation-day-percona-live-mysql-conference/">Open Source Appreciation Day at the Percona Live MySQL Conference appeared first on rel="nofollow" href="http://www.mysqlperformanceblog.com/">MySQL Performance Blog.

Mar
12
2014
--

Monitoring MySQL with MONyog

Monitoring MySQL and effectively managing it can be challenging. Identifying issues before they grow into performance problems that impact end users can be crucial. Knowing which tools to use, which key metrics to monitor, and how to resolve issues can be enormously important. When considering these facts, we at Percona decided to take steps to provide our Support customers with the tools, alerts, and advice they need to have higher performing, more secure, and easier to manage MySQL deployments.

Percona Support Now Includes MONyog and Percona Advisors

I am pleased to announce that Percona now provides our Gold and Platinum title="Percona Support for MySQL" href="https://www.percona.com/percona-mysql-support" >Percona Support for MySQL customers with the enterprise grade tools and advice they need for better performance, fewer database issues, and effective monitoring of MySQL. We have partnered with Webyog to provide our customers with MONyog Ultimate Edition, the leading MySQL monitoring and management tool. We then improve upon MONyog by providing title="Percona Advisors for MONyog" href="https://www.percona.com/products/mysql-support/mysql-monitoring-solutions" >Percona Advisors which provide MONyog users with best practices for monitoring MySQL and resolving performance issues. Percona Advisors combined with MONyog provides visibility into problems before they impact end user experience and it also provides guidance with links to relevant technical information on resolving issues quickly and effectively.

Percona Advisors is an installable set of rules, alerts, and recommended actions for MONyog. They capture the accumulated MySQL operational knowledge and insight of our Percona Support, Consulting, and Remote DBA teams. Percona Advisors modify the standard MONyog dashboard to highlight the most important performance metrics with alerts for when metrics fall outside of recommended limits. Percona Advisors is an ever-evolving solution with regular updates planned to incorporate additional best practices and guidance on issue resolution over time, as MySQL best practices continue to evolve.

“Monitoring MySQL with MONyog” Webinar on March 19, 2014

I am giving a webinar entitled “ title="Monitoring MySQL with MONyog Webinar" href="https://www.percona.com/resources/mysql-webinars/monitoring-mysql-monyog" >Monitoring MySQL with MONyog” on Wednesday, March 19, 2014 at 10:00 am Pacific Daylight Time to introduce this new solution. I will provide information on MONyog and how to create alerts which will make MySQL administration easier. I will also show how to leverage MONyog to understand trends, create alerts, and use other features to monitor performance and troubleshoot the source of issues. I hope you will join me then.

The post rel="nofollow" href="http://www.mysqlperformanceblog.com/2014/03/12/monitoring-mysql-monyog/">Monitoring MySQL with MONyog appeared first on rel="nofollow" href="http://www.mysqlperformanceblog.com/">MySQL Performance Blog.

Feb
21
2014
--

Before every release: A glimpse into Percona XtraDB Cluster CI testing

I spoke last month at href="http://lca2014.linux.org.au/">linux.conf.au 2014 in Perth, Australia, and one of my sessions focused on the “Continuous Integration (CI) testing of Percona XtraDB Cluster (PXC)” at the href="https://www.youtube.com/playlist?list=PLmiuOcBMoxjcc0SF5R6Ttbp881cXv8fxs">Developer,Testing, Release and CI miniconf.

Here is the video of the presentation:

width="420" height="315" src="http://www.youtube.com/embed/9qL6-qrTUd0" allowfullscreen="" frameborder="0">

Here is the presentation itself:

width="427" height="356" style="border: 1px solid #CCC; border-width: 1px 1px 0; margin-bottom: 5px; max-width: 100%;" src="http://www.slideshare.net/slideshow/embed_code/31388171" marginwidth="0" marginheight="0" allowfullscreen="" frameborder="0" scrolling="no">

style="margin-bottom: 5px;"> title="Percona XtraDB Cluster before every release: Glimpse into CI testing" href="https://www.slideshare.net/slidunder/ci-31388171" >Percona XtraDB Cluster before every release: Glimpse into CI testing from href="http://www.slideshare.net/slidunder" >Raghavendra Prabhu

Below is a rough transcript of the talk:

This talk covered the continuous integration testing of the Galera cluster; specifically, Percona XtraDB Cluster (PXC), based on Galera, is taken into consideration. Due to the nature of the cluster, existing testing procedures of MySQL cannot be used to fully test it, newer novel methodologies are required and used to uncover bugs.

The QA automation of PXC primarily involves:

a) Jenkins

b) Sysbench

c) Random Query Generator (RQG)

d) SST Testing

e) Replication Testing

f) Other techniques such as use of lock_wait_timeout (defaulting to one year) to catch MDL bugs, use of release and debug builds differently in tests: with the manifestation of a bug in either (an assertion/crash in debug build being a server hang in release buid for instance) are also used.

g) In future, we intend to have:

To conclude, as you may notice, there is a certain degree of overlap between these tests. This is intended, so that if one type of test misses it, other catches it, making it easy to detect the hard-to-catch bugs.

The post rel="nofollow" href="http://www.mysqlperformanceblog.com/2014/02/21/before-every-release-a-glimpse-into-percona-xtradb-cluster-ci-testing/">Before every release: A glimpse into Percona XtraDB Cluster CI testing appeared first on rel="nofollow" href="http://www.mysqlperformanceblog.com/">MySQL Performance Blog.

Written by in: CI,CI testing,galera,Jenkins,linuxconfau2014,MySQL,Percona Software,Percona XtraDB Cluster,pxc,Raghavendra Prabhu,Zend Developer |
Feb
17
2014
--

How to create a new Percona XtraDB Cluster with ClusterControl

We recently title="ClusterControl for Percona XtraDB Cluster Improves Management and Monitoring" href="http://www.mysqlperformanceblog.com/2014/02/04/clustercontrol-makes-percona-xtradb-cluster-easier-manage/">announced Percona ClusterControl supplied in partnership with Severalnines. This enterprise-grade cluster management and monitoring software is available with a  title="Percona MySQL Support" href="http://www.percona.com/products/mysql-support">Percona Support contract covering title="Percona XtraDB Cluster" href="http://www.percona.com/software/percona-xtradb-cluster">Percona XtraDB Cluster, MySQL Cluster, or MySQL Galera. In this blog post I am going to show you how to use Percona ClusterControl to to create a new 3-node cluster with Percona XtraDB Cluster.

Percona ClusterControl architecture

The software has three main parts:

  • style="line-height: 1.5em;">Percona ClusterControl UI style="line-height: 1.5em;">: This is the web interface from where we can create new clusters and monitor and manage existing ones.

In this example hostname cc and IP 10.60.5.234.

  • style="line-height: 1.5em;">Controller (or cmon) style="line-height: 1.5em;">: We need one controller for each Percona XtraDB Cluster. The controller is placed between ClusterControl UI and the cluster itself. It connects to the cluster to gather information or run commands and send back info to the ClusterControl UI.

In this example hostname cmon and IP 10.60.5.233.

  • style="line-height: 1.5em;">Percona XtraDB Cluster style="line-height: 1.5em;">: This is the cluster itself. We can create a new one or manage an existing one.

In this example hostnames xtradb1, xtradb2, xtradb3 and IPs 10.60.5.235-237.

Installation of Percona ClusterControl UI

First we need to install the Percona ClusterControl UI. We provide a link to the installation script in Percona’s customer portal. We just need to download the script and run it as root in the server designed for Percona ClusterControl UI.

root@cc:~# ./install-cc.sh

The installer will do everything for us. It will download Percona ClusterControl UI and all the dependencies needed from distribution’s repositories. It will also install MySQL, PHP5 and Apache. When the installation process finishes it will show this message:

Initial setup complete. To finalize the installation open your web browser
and go to this URL, http://10.0.2.15/install to finalize the installation.
Public/external IP => http://x.x.x.x/install
NOTE: Detected more than one IP: 10.0.2.15 10.60.5.234

Now we can access the Percona ClusterControl UI from the web interface and continue the installation process there. The installer will check if the server meets all the pre-requisites and it will ask some extra details to finish the installation:

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/requisites.png"> class="aligncenter size-full wp-image-21001" alt="ClusterControl pre-requisites" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/requisites.png" width="578" height="739" />

  • MySQL username and password: This is the MySQL server the install-cc.sh installed for us and where the Percona ClusterControl UI will store its own information.
  • Your name, logging e-mail and password: This is important, because this is the admin account for the Percona ClusterControl UI. The e-mail is also very important, because it is where we will receive new customised package installations created by the tool as we will see later on.

If everything is correct click on “Install” and it will show us the following notice:

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/installed.png"> class="aligncenter size-full wp-image-20996" alt="Percona ClusterControl installed" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/installed.png" width="600" height="134" />

After accepting the notice, Percona ClusterControl will show us the login screen.

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/login.png"> class="aligncenter size-full wp-image-21003" alt="ClusterControl Login" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/login.png" width="662" height="321" />

This is the main page still with no clusters monitored.

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/blank.png"> class="aligncenter size-full wp-image-21005" alt="ClusterControl Installed" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/blank.png" width="600" height="432" />

Creating our first Percona XtraDB Cluster

The next step is to install our cluster. It can be done from the web interface. We just need to click on “Create Database Cluster” button. The cluster creation wizard will start. First we need to choose which kind of configuration we want to deploy. We will choose “Galera Cluster for MySQL“:

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/create1.png"> class="aligncenter size-full wp-image-21007" alt="ClusterControl Creation" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/create1.png" width="600" height="280" />

The next step in the wizard is to provide the info about the kind of Galera Cluster we want and the network info about the nodes.

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/form1.png"> class="aligncenter size-full wp-image-21043" alt="ClusterControl Form" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/form1.png" width="600" height="442" />

It is divided in two different sections:

  • style="line-height: 1.5em;">Settings style="line-height: 1.5em;">: Here we have to make several decisions and provide info about our cluster nodes. By default Percona XtraDB Cluster will be deployed. We will need to provide extra info like the IPs, Linux distribution, hardware information and cluster configuration parameters.
  • style="line-height: 1.5em;">Cluster Control Node style="line-height: 1.5em;">: Here we need to configure the controller or cmon for this cluster. The controller node is the one that will connect to all our cluster nodes, install software and monitor them. Therefore, this control node needs to have access with SSH to all other nodes. That’s the reason we can upload an SSH private key. It is recommended that all 5 servers can connect to each other with passwordless authentication (root user) using an SSH key.

Now we have two options. Just deploy the cluster from the web interface or generate an installation package. We are going to use the second option so we can see what it does under the hood. When we click the “Generate Package” it will send us a tar.gz to our e-mail address.

Control Node and Cluster deployment:

We need to upload the package to the control node and run the installation script. It will check the connectivity, firewall ports and the SSH keys:

root@cmon:~/s9s-galera-percona-2.4.0/mysql/scripts/install# bash ./deploy.sh 2>&1 |tee cc.log
Checking EC2 Keypair:
Key pair found
Firewalls must accept  4567 (galera), 4567+1 (galera IST),  22 (ssh),  (rsync), 3306 (mysql), ping (icmp).

Then it will connect to the three cluster nodes and start the installation process using apt-get or yum. Packages like xtrabackup, Percona XtraDB Cluster or netcat will be installed to ensure normal cluster operations.

10.60.5.233: scp -P22 ../../repo/RPM-GPG-KEY-percona root@10.60.5.235:/root/s9s_tmp/RPM-GPG-KEY-percona[ok]
10.60.5.235: Executing 'gpg --import /root/s9s_tmp/RPM-GPG-KEY-percona' [ok]
10.60.5.235: Executing '/bin/sh -c 'gpg -a --export CD2EFD2A | apt-key add -'' [ok]
10.60.5.235: Executing '/bin/sh -c 'echo "deb http://repo.percona.com/apt wheezy main" >> /etc/apt/sources.list'' [ok]
10.60.5.235: Executing '/bin/sh -c 'echo "deb-src http://repo.percona.com/apt wheezy main" >> /etc/apt/sources.list'' [ok]
10.60.5.235: Executing 'apt-get -q -y update' [ok]
10.60.5.235: Executing 'LC_ALL=en_US.utf8 DEBIAN_FRONTEND=noninteractive apt-get -o Dpkg::Options::='--force-confnew' -y -q install percona-xtradb-cluster-galera-2.x percona-xtradb-cluster-client-5.5 percona-xtradb-cluster-server-5.5 percona-xtrabackup' [ok]

All the Percona XtraDB Cluster process is automatic. When the installation of nodes is finished it will start to install the Control Node package and its dependencies (apache, PHP and MySQL). After that, the process has finished:

galera : 10.60.5.237 [  up]
galera : 10.60.5.236 [  up]
galera : 10.60.5.235 [  up]
Installation completed in 618 seconds
*******************************************************************************
*                                                                             *
*                            CONGRATULATIONS                                  *
*                                                                             *
*******************************************************************************
You have now installed one of the most advanced db infrastructures available.
Open your browser to http://10.60.5.233/cmonapi
Logon with your email address and password.
This is your ClusterControl API token, xxxxxxxxxxxxxxxxxxxxxxxxxx, keep it for safekeeping if you need to (re)register your cluster again.

We need to open the URL and insert the API token there:

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/api.png"> class="aligncenter size-full wp-image-21009" alt="ClusterControl API" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/api.png" width="600" height="308" />

After that we need to “connect” the Control Node with the Percona ClusterControl UI:

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/register.png"> class="aligncenter size-full wp-image-21010" alt="Register the new CMON" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/register.png" width="471" height="446" />

And that’s all. We have Percona ClusterControl installed and a new Percona XtraDB Cluster in our infrastructure that we can monitor and manage from a web interface.

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/nodes.png"> class="aligncenter size-full wp-image-21011" alt="ClusterControl nodes" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2014/02/nodes.png" width="551" height="654" />

Conclusion

Percona ClusterControl is a really useful and user-friendly tool to manage and monitor our clusters. We can use it to create new clusters as we have seen here or to manage already existing clusters. I will write a second blog post explaining how to put our already in production Percona XtraDB Cluster under Percona ClusterControl management.

The post rel="nofollow" href="http://www.mysqlperformanceblog.com/2014/02/17/how-to-create-a-new-percona-xtradb-cluster-with-clustercontrol/">How to create a new Percona XtraDB Cluster with ClusterControl appeared first on rel="nofollow" href="http://www.mysqlperformanceblog.com/">MySQL Performance Blog.

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com