Buy Percona ServicesBuy Now!

This Week in Data with Colin Charles 12: Open Source Summit Europe and Open Source Entrepreneur Network

Latest MySQL Performance Blog posts - October 27, 2017 - 1:23pm

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.

This week was exciting from a Percona exposure standpoint. We were at Open Source Summit Europe. I gave two talks and participated in a panel, as the co-located event for the Open Source Entrepreneur Network happened on the last day as well. We had a booth, and it was great to hang out and talk with my colleagues Dorothée Wuest and Dimitri Vanoverbeke as well as all the attendees that popped by.

Releases Link List Feedback

I look forward to feedback/tips via e-mail at colin.charles@percona.com or on Twitter @bytebot.

Empty repo for Ubuntu 17.10 - Artful

Lastest Forum Posts - October 27, 2017 - 2:18am
Hello,

I've noticed that apt repo for Ubuntu Artful seems to be corrupted/empty.

https://repo.percona.com/apt/dists/a...binary-x86_64/

comparing to:

https://repo.percona.com/apt/dists/z...binary-x86_64/

It means that in order to install

Hope that helps

Cheers
Chris

Percona Server for MongoDB 3.4.9-2.9 is Now Available

Latest MySQL Performance Blog posts - October 26, 2017 - 10:17am

Percona announces the release of Percona Server for MongoDB 3.4.9-2.9 on October 26, 2017. Download the latest version from the Percona web site or the Percona Software Repositories.

Percona Server for MongoDB is an enhanced, open source, fully compatible, highly-scalable, zero-maintenance downtime database supporting the MongoDB v3.4 protocol and drivers. It extends MongoDB with Percona Memory Engine and MongoRocks storage engine, as well as several enterprise-grade features:

Percona Server for MongoDB requires no changes to MongoDB applications or code.

This release is based on MongoDB 3.4.9 and includes the following additional change:

  • Updated RocksDB to version 5.7.3

Point-in-time recovery

Lastest Forum Posts - October 26, 2017 - 4:48am
Hi all,

I have just upgraded to XtraBackup 2.4 and everything seems to be working well.
I can do a full backup using xtrabackup --backup but am a little lost on how to do a point-in-time recovery.
The documentation seems to say I need to have used the innobackupex program to do the backup but it also says that this program had been deprecated and that I should use the xtrabackup program so I am a little confused.
Reading up on point-in-time recovery in the user manual it only refers to the innobackupex program.
So if I shouldn't be using this program, how do I do a point-in-time recovery?

I would really appreciate some help on this

Thanks in advance

Ian

Find all sql statements larger than X bytes?

Lastest Forum Posts - October 25, 2017 - 2:40pm
Can any of the tools in Percona Toolkit log all SQL queries where the statement text is larger than a certain size?

JSON Output of the pmm-admin list Command

Latest MySQL Performance Blog posts - October 25, 2017 - 10:08am

In this blog post, we’ll look at Percona Monitoring and Management’s pmm-admin list command.

The pmm-admin list command shows all monitoring services you have added using the pmm-admin add command. Starting with version 1.4.0, Percona Monitoring and Management (PMM) also lists external monitoring services when you run pmm-admin list, i.e., those services that monitor the backends not supported out of the box (such as PostgreSQL databases).

In the output, the external monitoring services appear at the bottom:

The tabular output of the pmm-admin list command JSON Output for Automatic Verification

But there is also another feature of pmm-admin list. If you run this command with the –json parameter, the command gives you a JSON document as output. This option now enables inspecting the monitoring services by computers due to the strict JSON syntax rules. JSON has become a de-facto standard for exchanging data for many tools. The JSON output provided by the pmm-admin list command can be used by configuration management tools such as ansible or chef.

The output is captured as keys and values. The general information about the computer where this pmm-client is installed is given as top-level elements:

  • Version
  • ServerAddress
  • ServerSecurity
  • ClientName
  • ClientAddress
  • ClientBindAddress
  • Platform

You can quickly determine if there are any errors in built-in monitoring services by inspecting the Err top level element in the JSON output. Similarly, the ExternalErr element reports errors on external services:

The JSON parsing friendly version produced by the pmm-admin list command Representing Monitoring Services

Two elements contain lists as their values. The Services top-level element contains a list of documents that represent enabled monitoring services. The ExternalServices element contains a list of documents that represent enabled external monitoring services. Each attribute in the Services and ExternalServices elements provides the same information as a column in the tabular output.

Hope this brief post provides some valuable information regarding new Percona Monitoring and Management 1.4.0 functionality. Let me know about any questions in the comments.

mysqld_safe issue on debian stretch

Lastest Forum Posts - October 25, 2017 - 8:34am
hi,


After installing perconna mysql server 5.7 on a brand new debian stretch i was able to start the server but then all actions of /etc/init.d/mysql failed. I tracked the issue to the fact that the pid file in the config files is in /var/run/mysql but mysqld_safe create it under /var/lib/mysql. See:

GUEST:root@stretch01:[~]: /etc/init.d/mysql status
[info] Percona Server 5.7.19-17 is not running.
GUEST:root@stretch01:[~]: ps auxwf|grep mysql
root 1030 0.0 0.0 13388 1020 pts/2 S+ 15:28 0:00 \_ grep mysql
GUEST:root@stretch01:[~]: find /etc/mysql/ -type f -exec grep -i pid {} \;
pid-file = /var/run/mysqld/mysqld.pid
pid_file = /var/run/mysqld/mysqld.pid <= yes i tried this _ one too ;p
pid-file = /var/run/mysqld/mysqld.pid
pid_file = /var/run/mysqld/mysqld.pid <= yes i tried this _ one too ;p
pid-file = /var/run/mysqld/mysqld.pid
pid-file = /var/run/mysqld/mysqld.pid
pid_file = /var/run/mysqld/mysqld.pid <= yes i tried this _ one too ;p
GUEST:root@stretch01:[~]: /etc/init.d/mysql start
GUEST:root@stretch01:[~]: ps auxwf|grep mysql
root 1172 0.0 0.0 13388 972 pts/2 S+ 15:29 0:00 \_ grep mysql
mysql 1076 0.0 0.0 4288 1572 ? S 15:29 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 1141 25.7 1.5 1158856 196944 ? Sl 15:29 0:01 \_ /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --log-error=stretch01.aqueos.net.err --pid-file=stretch01.aqueos.net.pid

GUEST:root@stretch01:[~]: /etc/init.d/mysql status
[info] Percona Server 5.7.19-17 is not running.

GUEST:root@stretch01:[~]: ll /var/run/mysqld/mysqld.pid
ls: cannot access '/var/run/mysqld/mysqld.pid': No such file or directory
GUEST:root@stretch01:[~]: ll /var/lib/mysql/stretch01.aqueos.net.pid
-rw-r----- 1 mysql mysql 5 oct. 25 15:29 /var/lib/mysql/stretch01.aqueos.net.pid


The command of the init.d script seems to be good:

GUEST:root@stretch01:[~]: my_print_defaults mysqld_safe pid-file | sed -n "s/^--pid-file=//p" | tail -n 1
/var/run/mysqld/mysqld.pid

but it does not transmit this to mysqld_safe that do not read any of the cnf files so it creates the pid at the default location that is $DATADIR/xxxx.pid

my_print_defaults in mysqld-safe needs a default file location and the scritp do not send it. /etc/init.d/mysql send just :

su - mysql -s /bin/bash -c "mysqld_safe > /dev/null &"


removing all pid-file in the *.cnf files make all works again as mysqld_safe AND /etc/init.d/mysql use the default

GUEST:root@stretch01:[~]: find /etc/mysql/ -type f -exec grep -i pid {} \;
#pid-file = /var/run/mysqld/mysqld.pid
#pid-file = /var/run/mysqld/mysqld.pid

GUEST:root@stretch01:[~]: /etc/init.d/mysql status
[info] Percona Server 5.7.19-17 is running.

GUEST:root@stretch01:[~]: /etc/init.d/mysql restart
[info] Stopping Percona Server 5.7.19-17.
....
[info] Percona Server 5.7.19-17 is stopped.
[info] Re-starting Percona Server 5.7.19-17.
GUEST:root@stretch01:[~]:

so the /etc/init.d/mysql read the config files but mysqld_safe do not making different settings from the default fail.


best regards,
ghislain.

ps: debian stretch with sysV init (no systemd)
perconna installed by using the personna repository for debian and apt-get install percona-server-server-5.7

ii percona-release 0.1-4.stretch all Package to install Percona gpg key and APT repo
ii percona-server-client-5.7 5.7.19-17-1.stretch amd64 Percona Server database client binaries
ii percona-server-common-5.7 5.7.19-17-1.stretch amd64 Percona Server database common files (e.g. /etc/mysql/my.cnf)
ii percona-server-server-5.7 5.7.19-17-1.stretch amd64 Percona Server database server binaries




Visit Percona Store


General Inquiries

For general inquiries, please send us your question and someone will contact you.