lefred

lefred

I am MySQL Community Manager for EMEA & APAC. I joined the MySQL Community Team in May 2016. I have been an OpenSource and MySQL consultant for more than 15 years. My favorite topics are High Availability and Performance.
  • Joined: April 26, 2016
  • Articles: 581
  • Comments: 356

Percona Live, MySQL Conference & Expo 2016

Hello, Percona Live 2016, Data Performance Conference Santa Clara, April 13-16, 2015 Like every year since I joined Percona, I also plan to speak at the next Percona Live Conference & Expo in Santa Clara during spring 2016. Once again I want to share with the users, DBAs and developers my experience related to MySQL High Availability and especially with Galera. This year, Percona implemented a Community Vote to rate the talks you would like to see in the schedule. So if you want to attend one or more of my talks, please vote for them. Of course, I invite you to rate other people's talk too, that will help the organisation and the Conference Committee to prepare the schedule. These are the direct links to my talks and tutorial: * https://www.percona.com/live/data-performance-conference-2016/sessions/advanced-percona-xtradb-cluster-nutshell-la-suite-hands-tutorial-not-beginners#community-voting * https://www.percona.com/live/data-performance-conference-2016/sessions/undelete-rows-binary-log-hacking-session#community-voting * https://www.percona.com/live/data-performance-conference-2016/sessions/galera-replication-demistified-how-does-it-work#community-voting * https://www.percona.com/live/data-performance-conference-2016/sessions/revisited-tips-improve-your-galera-cluster-experience#community-voting

NetworkManager, OpenVPN on Fedora 21

On openvpn setups where MD5 is still in use with the SSL certificate, it's now impossible to connect when you are in Fedora 21. To allow openvpn client to connect to such VPN using NetworkManager, you need to modify /usr/lib/systemd/system/NetworkManager.service and add the following two lines in [Service] section: 
Environment="NSS_HASH_ALG_SUPPORT=+MD5"
Environment="OPENSSL_ENABLE_MD5_VERIFY=1"
Restart the service and it will work ;)

Get Things Gnome : synchronize multiple computers

Since many years now I use GTG to manage my todo lists. (it can even be ). I tried to use Remember The Milk service to sync my laptop and my desktop but it wasn't really working well. Then I discovered a nice project : GTGonline, a Django project that allows the synchronization to and from GTG via a backend called backend_gtgonline. I forked the project to create a branch (that will never be merged it seems) to not hardcode the url of the service as I host my own version of GTGonline backend. My branch is https://github.com/lefred/backend_gtgonline/tree/service-url and I also provide a rpm package for Ferdora 20.

Backport of Percona Audit Plugin

Since yesterday, the new Percona Server (5.5.37-35.0) includes an audit plugin. This is the announcement on mysqlperformance blog. I needed to have this feature for a customer running an older version of Percona Server (5.5.33-31.1), so I back ported the plugin (revision 654) removing some extra info that is not available on previous version of Percona Server. The information above in struct mysql_event_general (include/mysql/plugin_audit.h) were not yet present: MYSQL_LEX_STRING general_host; MYSQL_LEX_STRING general_sql_command; MYSQL_LEX_STRING general_external_user; MYSQL_LEX_STRING general_ip; Additionally, as I needed to parse the audit log quickly, I added a new format (CSV) to replace both implementation of XML output (OLD & NEW). This is an example of the new output: 
AUDIT_RECORD - Audit::35531_2014-05-07T06:15:32::2014-05-07T06:15:36 UTC::5.5.33-31.1::--basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/percona1.err --pid-file=/var/lib/mysql/percona1.pid::x86_64-Linux
AUDIT_RECORD - Connect,35532_2014-05-07T06:15:32,2014-05-07T06:16:04 UTC,1,0,root,root,,,localhost,
AUDIT_RECORD - Query::35533_2014-05-07T06:15:32::2014-05-07T06:16:04 UTC::1::0::select @@version_comment limit 1::root[root] @ localhost []
AUDIT_RECORD - Query::35534_2014-05-07T06:15:32::2014-05-07T06:16:20 UTC::1::0::SELECT DATABASE()::root[root] @ localhost []
AUDIT_RECORD - Init DB::35535_2014-05-07T06:15:32::2014-05-07T06:16:20 UTC::1::0::(null)::root[root] @ localhost []
AUDIT_RECORD - Query::35536_2014-05-07T06:15:32::2014-05-07T06:16:20 UTC::1::0::show databases::root[root] @ localhost []
AUDIT_RECORD - Query::35537_2014-05-07T06:15:32::2014-05-07T06:16:20 UTC::1::0::show tables::root[root] @ localhost []
AUDIT_RECORD - Field List::35538_2014-05-07T06:15:32::2014-05-07T06:16:20 UTC::1::0::::root[root] @ localhost []
AUDIT_RECORD - Field List::35539_2014-05-07T06:15:32::2014-05-07T06:16:20 UTC::1::0::::root[root] @ localhost []
AUDIT_RECORD - Query::35540_2014-05-07T06:15:32::2014-05-07T06:16:23 UTC::1::0::show databases::root[root] @ localhost []
AUDIT_RECORD - Query::35541_2014-05-07T06:15:32::2014-05-07T06:16:27 UTC::1::0::SELECT DATABASE()::root[root] @ localhost []
AUDIT_RECORD - Init DB::35542_2014-05-07T06:15:32::2014-05-07T06:16:27 UTC::1::0::(null)::root[root] @ localhost []
AUDIT_RECORD - Query::35543_2014-05-07T06:15:32::2014-05-07T06:16:29 UTC::1::0::show tables::root[root] @ localhost []
AUDIT_RECORD - Query::35544_2014-05-07T06:15:32::2014-05-07T06:16:34 UTC::1::0::select * from t::root[root] @ localhost []
The patch is available below and the compiled plugin for Centos 6 x86_64 for Percona Server 5.5.33-rel31. Update: I've now added the code in launchpad and changed the default audit format to CVS, so the first time the plugin is loaded, CVS is used and no need to restart mysqld to enable CVS.

As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

You can find articles I wrote on Oracle’s blog.

Continue