{"id":1487,"date":"2014-01-07T11:45:27","date_gmt":"2014-01-07T10:45:27","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=1487"},"modified":"2014-01-07T11:45:27","modified_gmt":"2014-01-07T10:45:27","slug":"update-db-set-age-age-1-where-productmysql","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2014\/01\/07\/update-db-set-age-age-1-where-productmysql\/","title":{"rendered":"UPDATE db SET age = age + 1 WHERE product=’MySQL’"},"content":{"rendered":"

2013 \u00e0 \u00e9t\u00e9 une ann\u00e9e tr\u00e8s riche en ce qui concerne l\u2019\u00e9cosyst\u00e8me MySQL \/ MariaDB \/ Percona Server. Voici un petit r\u00e9cap technique (incomplet) pour les 3 acteurs majeurs:<\/p>\n

MySQL @Oracle<\/h1>\n

 <\/p>\n

En bref<\/h2>\n

Oracle \u00e0 repris la main et le lead technique en 2013 avec MySQL 5.6: http:\/\/dimitrik.free.fr\/blog\/archives\/2013\/02\/mysql-performance-mysql-56-vs-mysql-55-vs-mariadb-55.html<\/a><\/p>\n

 <\/p>\n

Facebook migre vers la 5.6: https:\/\/github.com\/facebook\/mysql-5.6<\/a><\/p>\n

 <\/p>\n

De belle promesses avec MySQL 5.7: http:\/\/dimitrik.free.fr\/blog\/archives\/2013\/10\/mysql-performance-the-road-to-500k-qps-with-mysql-57.html<\/a><\/p>\n

 <\/p>\n

Avec MySQL 5.7 & memcached: http:\/\/dimitrik.free.fr\/blog\/archives\/2013\/11\/mysql-performance-over-1m-qps-with-innodb-memcached-plugin-in-mysql-57.html<\/a><\/p>\n

\u00c9tat des lieux<\/h2>\n

MySQL 5.6 GA depuis le 05\/02\/2013<\/p>\n

Changes in MySQL 5.6.10 (2013-02-05, General Availability)<\/a><\/p>\n

http:\/\/dev.mysql.com\/downloads\/mysql\/<\/a><\/p>\n

 <\/p>\n

MySQL 5.7 DMR, derni\u00e8re version le 03\/12\/2013<\/p>\n

Changes in MySQL 5.7.1 (2013-04-23, Milestone 11)<\/a><\/p>\n

http:\/\/dev.mysql.com\/downloads\/mysql\/<\/a><\/p>\n

 <\/p>\n

MySQL cluster 7.3 GA depuis le 18\/06\/2013<\/p>\n

Changes in MySQL Cluster NDB 7.3.2 (5.6.11-ndb-7.3.2) (2013-06-18, General Availability)<\/a><\/p>\n

http:\/\/dev.mysql.com\/downloads\/cluster\/<\/a><\/p>\n

 <\/p>\n

MySQL utilities GA derni\u00e8re version le 02\/08\/2013<\/p>\n

Changes in MySQL Utilities 1.3.4 (2013-08-02, General Availability)<\/a><\/p>\n

http:\/\/dev.mysql.com\/downloads\/tools\/<\/a><\/p>\n

\u00c9v\u00e9nements fran\u00e7ais<\/h2>\n

Meetup Oracle\/LeMug le 10 octobre 2013<\/p>\n

http:\/\/dasini.net\/blog\/2013\/10\/01\/mysql-techday-le-programme\/<\/a><\/p>\n

http:\/\/dasini.net\/blog\/2013\/10\/14\/retour-sur-le-mysql-techday\/<\/a><\/p>\n

 <\/p>\n

MariaDB & SkySQL<\/h1>\n

 <\/p>\n

En bref<\/h2>\n

Monty Program Ab et SkySQL ont fusionn\u00e9s: http:\/\/www.skysql.com\/news-and-events\/press-releases\/skysql-merges-with-mariadb-developers<\/a><\/p>\n

MariaDB Galera Cluster est pass\u00e9e GA, en attendant le tour de MariaDB 10.<\/p>\n

Wikimedia migre en MariaDB 5.5: https:\/\/blog.wikimedia.org\/2013\/04\/22\/wikipedia-adopts-mariadb\/<\/a><\/p>\n

Google migre vers MariaDB 10: http:\/\/www.zdnet.com\/google-quietly-dumps-oracle-mysql-for-mariadb-7000020670\/<\/a><\/p>\n

 <\/p>\n

Des distribs Linux qui embarques MariaDB: https:\/\/mariadb.com\/kb\/en\/distributions-which-include-mariadb\/<\/a><\/p>\n

Et une multitude de moteur de stockage: https:\/\/mariadb.com\/kb\/en\/mariadb-storage-engines\/<\/a><\/p>\n

\u00c9tat des lieux<\/h2>\n

MariaDB 5.5 GA depuis le 23\/05\/2013<\/p>\n

https:\/\/downloads.mariadb.org\/<\/a><\/p>\n

 <\/p>\n

MariaDB Galera Cluster 5.5 GA depuis le 30\/08\/2013<\/p>\n

https:\/\/downloads.mariadb.org\/<\/a><\/p>\n

 <\/p>\n

MariaDB 10.0.7 Beta: derni\u00e8re version le 27\/12\/2013<\/p>\n

https:\/\/blog.mariadb.org\/mariadb-10-0-7-now-available\/<\/a><\/p>\n

https:\/\/downloads.mariadb.org\/<\/a><\/p>\n

\u00c9v\u00e9nements fran\u00e7ais<\/h2>\n

Meetup SkySQL \/ LeMug: 17 d\u00e9cembre 2013<\/p>\n

http:\/\/www.lemug.fr\/2013\/17-decembre-meet-up-la-nuit-mariadb\/<\/a><\/p>\n

 <\/p>\n

Percona<\/h1>\n

 <\/p>\n

En bref<\/h2>\n

Des outils (toolkit, XtraBackup,…) qui font le bonheur des DBA. A noter que le Q4 \u00e0 vu la sortie en GA de Percona Server 5.6.<\/p>\n

\u00c9tat des lieux<\/h2>\n

Percona Server 5.6 GA: depuis le 7\/10\/2013<\/p>\n

http:\/\/www.percona.com\/software\/percona-server\/ps-5.6<\/a><\/p>\n

 <\/p>\n

Percona Server 5.5 GA: derni\u00e8re version le 20\/12\/2013<\/p>\n

http:\/\/www.percona.com\/downloads\/Percona-Server-5.5\/<\/a><\/p>\n

 <\/p>\n

Percona Server XtraDB Cluster 5.5 GA: derni\u00e8re version le 3\/12\/2013<\/p>\n

http:\/\/www.percona.com\/software\/percona-xtradb-cluster<\/a><\/p>\n

 <\/p>\n

Percona Server XtraDB Cluster 5.6 RC: derni\u00e8re version le 18\/12\/2013<\/p>\n

http:\/\/www.percona.com\/doc\/percona-xtradb-cluster\/5.6\/<\/a><\/p>\n

 <\/p>\n

XtraBackup<\/p>\n

http:\/\/www.percona.com\/software\/percona-xtrabackup<\/a><\/p>\n

 <\/p>\n

Toolkit<\/p>\n

http:\/\/www.percona.com\/software\/percona-toolkit<\/a><\/p>\n

 <\/p>\n

Monitoring Plugins<\/p>\n

http:\/\/www.percona.com\/software\/percona-monitoring-plugins<\/a><\/p>\n

 <\/p>\n

Data Recovery Tool for InnoDB<\/p>\n

http:\/\/www.percona.com\/software\/mysql-innodb-data-recovery-tools<\/a><\/p>\n

\u00c9v\u00e9nements fran\u00e7ais<\/h2>\n

Pas de meetup Percona \/ LeMug en 2013. Il aurait d\u00fb avoir lieu fin 2013, mais un stupide probl\u00e8me de salle \u00e0 fait capoter l\u2019affaire. Ce n\u2019est que partie remise.<\/p>\n

N\u2019h\u00e9sitez pas \u00e0 compl\u00e9ter si j\u2019ai oubli\u00e9 des choses \ud83d\ude42<\/p>\n

Beaucoup de bonnes choses en 2013, c\u2019est vraiment de bon augure pour 2014.<\/p>\n

Je profite de ce \u201cpost\u201d pour \u00e9videmment vous souhaiter une excellente ann\u00e9e 2014. Que celle-ci soit remplie de bonheur, de sant\u00e9, de r\u00e9ussite et de belles requ\u00eates optimis\u00e9es \ud83d\ude42<\/p>\n

 <\/p>\n

SQLment votre,<\/p>\n

 <\/p>\n

Olivier DASINI<\/p>\n","protected":false},"excerpt":{"rendered":"

2013 \u00e0 \u00e9t\u00e9 une ann\u00e9e tr\u00e8s riche en ce qui concerne l\u2019\u00e9cosyst\u00e8me MySQL \/ MariaDB \/ Percona Server. Voici un petit r\u00e9cap technique (incomplet) pour les 3 acteurs majeurs:
\nMySQL @Oracle
\nMariaDB & SkySQL
\nPercona<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[167,8,181],"tags":[],"class_list":["post-1487","post","type-post","status-publish","format-standard","hentry","category-mariadb","category-mysql","category-percona-server-2"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-nZ","jetpack-related-posts":[{"id":1375,"url":"https:\/\/dasini.net\/blog\/2013\/02\/21\/mysql-5-6\/","url_meta":{"origin":1487,"position":0},"title":"MySQL 5.6","author":"Olivier DASINI","date":"21 f\u00e9vrier 2013","format":false,"excerpt":"Cela fait quelques jours maintenant que MySQL 5.6 est disponible pour la production. Un impressionnant travail a \u00e9t\u00e9 effectu\u00e9 par les \u00e9quipe d'Oracle, voici un petit r\u00e9sum\u00e9 des principales \u00e9volution vu par Peter Zaitsev. L'\u00e9v\u00e9nement dans l'\u00e9v\u00e9nement, c'est la \"pol\u00e9mique\" sur les performances de la 5.6, par rapport \u00e0 MySQL\u2026","rel":"","context":"Dans "MariaDB"","block_context":{"text":"MariaDB","link":"https:\/\/dasini.net\/blog\/category\/mariadb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1473,"url":"https:\/\/dasini.net\/blog\/2013\/10\/14\/retour-sur-le-mysql-techday\/","url_meta":{"origin":1487,"position":1},"title":"Retour sur le MySQL techday","author":"Olivier DASINI","date":"14 octobre 2013","format":false,"excerpt":"Jeudi 10 octobre \u00e0 eu lieu, dans les locaux d'Oracle, le MySQL techday organis\u00e9 par Oracle et le MySQL User Group francophone. Dans la continuit\u00e9 de MySQL Connect, les speakers nous ont offert des sessions de tr\u00e8s grandes qualit\u00e9s sur les th\u00e8mes de la performance et de l'optimisation relative aux\u2026","rel":"","context":"Dans "Conf\u00e9rence"","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1450,"url":"https:\/\/dasini.net\/blog\/2013\/08\/26\/mysql-techday-le-10-octobre-2013\/","url_meta":{"origin":1487,"position":2},"title":"MySQL TechDay, le 10 Octobre 2013","author":"Olivier DASINI","date":"26 ao\u00fbt 2013","format":false,"excerpt":"Le 10 octobre 2013, Oracle et Le MySQL User Group Francophone (lemug.fr) vous invitent au MySQL Tech Day \u00e0 Paris. Une journ\u00e9e technique bien pleine o\u00f9 les diff\u00e9rentes \u00e9quipes MySQL chez Oracle vont nous pr\u00e9senter les am\u00e9liorations pr\u00e9sentes et futures des versions 5.6 et 5.7 de MySQL. Au programme: Overview:\u2026","rel":"","context":"Dans "Conf\u00e9rence"","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1245,"url":"https:\/\/dasini.net\/blog\/2012\/04\/05\/mysql-5-6-rock-suite\/","url_meta":{"origin":1487,"position":3},"title":"MySQL 5.6 rock suite","author":"Olivier DASINI","date":"5 avril 2012","format":false,"excerpt":"Voici la suite du post MySQL 5.6 rock, dans lequel je test MySQL 5.5 & 5.6, MariaDB 5.3 & 5.5 et Percona server 5.5. Pour cet article, toujours un bench. Le contexte est assez proche, \u00e0 la diff\u00e9rence pr\u00e8s que cette fois les serveurs sont test\u00e9s en lecture (65%) et\u2026","rel":"","context":"Dans "bench"","block_context":{"text":"bench","link":"https:\/\/dasini.net\/blog\/category\/bench\/"},"img":{"alt_text":"dasini.net - 95 centile for R\/W i\/o bounds","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-includes\/images\/dasini.net_bench_mysql_95percentil.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1227,"url":"https:\/\/dasini.net\/blog\/2012\/03\/30\/mysql-5-6-rocks\/","url_meta":{"origin":1487,"position":4},"title":"MySQL 5.6 rock !","author":"Olivier DASINI","date":"30 mars 2012","format":false,"excerpt":"Comme d'habitude, mon but n'est pas de conna\u00eetre les possibilit\u00e9s maximales du serveur (d'autres le font mieux que moi), mais plut\u00f4t d'avoir une id\u00e9e assez pr\u00e9cise de leurs comportements respectifs dans un environnement le plus proche possible de ma prod. pour ce test, les candidats sont, Percona 5.5, MariaDB 5.3\u2026","rel":"","context":"Dans "bench"","block_context":{"text":"bench","link":"https:\/\/dasini.net\/blog\/category\/bench\/"},"img":{"alt_text":"dasini.net - 95 centile","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-includes\/images\/percentil.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1496,"url":"https:\/\/dasini.net\/blog\/2015\/09\/14\/meetup-mysql-a-paris\/","url_meta":{"origin":1487,"position":5},"title":"Meetup MySQL \u00e0 Paris","author":"Olivier DASINI","date":"14 septembre 2015","format":false,"excerpt":"Ce jeudi 17 septembre 2015, \u00e0 l'initiative du MySQL User Group France (lemug.fr), je vais pr\u00e9senter un retour d'exp\u00e9rience sur une migration MySQL 5.5 vers 5.6 dans les locaux de Dailymotion \u00e0 Paris.","rel":"","context":"Dans "Conf\u00e9rence"","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/1487","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/comments?post=1487"}],"version-history":[{"count":2,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/1487\/revisions"}],"predecessor-version":[{"id":1489,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/1487\/revisions\/1489"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=1487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=1487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=1487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}