sync_binlog = 1 in MySQL 5.7

As Morgan announced it his blog post related to new defaults in 5.7, in 5.7.7 and newer the default value of sync_binlog is now 1. This of course has an impact on performance especially if you don’t have fast storage…
As Morgan announced it his blog post related to new defaults in 5.7, in 5.7.7 and newer the default value of sync_binlog is now 1. This of course has an impact on performance especially if you don’t have fast storage…
As some already noticed it, I’ve recently joined the amazing MySQL family in Oracle. I’m now part to the awesome MySQL Community Team and I will be mostly present in EMEA. Why did I make such change ? Oracle offered…
Also during Percona Live with my colleague Kenny Gryp, we delivered a tutorial on Percona XtraDB Cluster (Galera) These are the slides: Advanced percona xtra db cluster in a nutshell… la suite plsc2016 from Frederic Descamps
At Percona Live 2016, I presented a talk related to Galera. I tried to explain what’s really behind the magic. I think it’s essential for all who want to use Galera replication in MySQL to understand all these concepts. These…
Hi, I’ve finally decided to upgrade my old drupal 6.x blog… I tried Drupal 8, but to be honest I finally migrated to WordPress. WordPress is more easy to maintain, to deal with and also it has a nice Mobile…
Hello,
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
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 ;)
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.
I wanted to speed up a slave using Percona's InnoDB fake change feature, so I decided to use Facebook's prefetcher called faker.
As I needed to compile it, with just some more minutes I could create a rpm package. So here is the RPM for CentOS 6.x 64bit.
Enjoy.
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.
Once again MariaDB invited Doug Shannon from EventToons at their Percona Live MySQL Conference & Expo's booth.
And once again he drew me.
This is the picture of last year:
and the one of this year:
The conclusion is simple: my beard narrowed and my face grew ! ... is this a sign that I'm becoming old ? ;-)
BTW, thx MariaDB's team for this nice and funny gift !
If you want to be able to use an iPhone with Fedora 20 to copy photos or songs, you will need to upgrade libimobiledevice to 1.1.6. If you don't on the phone you will be constantly prompted to trust or not the computer:
You can find the rpms for libimobiledevice 1.1.6 here.
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.