I’ve uploaded the slides from my latest talks at OpenWorld and Percona Live, available below. These are mostly an updated version of previous talks, with some new info added here and there..
MySQL sys schema deep dive (Oracle OpenWorld 2016)
Performance schema and sys schema (Percona Live Amsterdam 2016)
The slides of my joint tutorial with Kenny Gryp from Percona on MySQL InnoDB Cluster and Group Replication are now online.
We got nice questions during the session and very good feedback.
MySQL Group Replicatio in a nutshell – MySQL InnoDB Cluster from Frédéric Descamps
First of all I want to say thanks to Thomas that sent me feedback on part1 (see his comment). And indeed all three cases were able to defeat the datamasking.
I rewrote then the rules to also take those cases in consideration:
ProxySQL> DELETE FROM mysql_query_rules where rule_id INSERT INTO mysql_query_rules
(rule_id,active,username,match_pattern,replace_pattern,apply)
VALUES (1,1,'devel','`cc_num`',"cc_num",0);
ProxySQL> INSERT INTO mysql_query_rules
(rule_id,active,username,match_pattern,replace_pattern,apply)
VALUES (2,1,'devel','^[sS][eE][lL][eE][cC][tT] (.*)cc_num([ ,\n])(.*)',
"SELECT \1CONCAT(LEFT(cc_num,2),REPEAT('X',10)) cc_num\2\3",1);
However the current recursive implementation of ProxySQL (using
flagIN & flagOUT) is not an option to face the case where a …
This is the video from LaraconEU 2016 on Making the Most out of MySQL.
The MySQL Windows Experience Team is proud to announce the release of MySQL for Visual Studio 2.0.4 m3. Note that this is a development preview release and not intended for production usage.
MySQL for Visual Studio 2.0.4 m3 is the third development preview release of the MySQL for Visual Studio 2.0 series. This series adds support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax that does not assume previous experience writing traditional SQL.
To learn more about how to write applications using the X DevAPI, see http://dev.mysql.com/doc/x-devapi-userguide/en/. For more information about how the X DevAPI is implemented in MySQL for Visual Studio, and its usage, see …
[Read more]Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.
|
MySQL on Docker: Multi-Host Networking for MySQL Containers
(Part 2 - Calico)
We’re continuing with our popular blogs covering MySQL on Docker and this time we’re looking at deploying MySQL Replication on top of three Docker hosts via Calico’s driver on multi-host networking. Having previously looked at Docker’s single-host networking for MySQL containers as well as multi-host networking and Docker swarm mode, we’re now casting our eyes on other networking drivers, starting with Calico. |
Percona Live Amsterdam is just finished… there was an entire room full day about MySQL 8.0 which is wonderful but there was also another product that everybody was talking about: ProxySQL (great job René).
Ronald Bradford and the MySQL engineering team were discussing about what tool was missing in the MySQL ecosystem and Mark Leith highlighted that a datamasking utility was really missing.
Having used already ProxySQL for Group Replication and other tests, I knew that it would be possible to use it also for this purpose. After a very short discussion and a nightly chat with …
[Read more]Good news ! The MySQL & Friends Devroom has been accepted for Fosdem’s 2017 edition !
This event is a real success story for the MySQL ecosystem, the content, the speakers and the attendees are growing every year.
Fosdem’s organization left out som e long time participants to give other projects a chance as welll to be present at this massive event. Hopefully we were accepted as MySQL is present at Fosdem since the very first editions.
The 2017’s edition will take place 4th & 5th February in Brussels.
I’m currently forming the committee for this new edition and the CfP should open in some days. Stay tuned and prepare your trip to Belgium for the winter !
lefred.
MySQL 5.7 improved as compare to previous releases in terms of transnational capabilities, performance with high load, high Availability, Security and it’s defaults.
Check my blog post : MySQL 5.7 features
This blog post will describe End to End implementation of MySQL on Linux distributions Which will cover MySQL Installation, configuration and administration in production environment with proper configuration. So you can start using your application by implementing following setup and in future you can change it if requires.
[Read more]This blog post discusses how to use MySQL shell securely from Bash.
The Bourne shell is everywhere. It is part of the most basic Linux install. You will find it on the biggest SPARC machines down to a Raspberry Pi. It is nice to know it will always be there. Unlike other, more complex scripting environments such as Perl and Python, it doesn’t require any additional dependencies to be installed.
Anyone that has automated a MySQL task using a Bourne shell such as Bash will be familiar with the following message:
Warning: Using a password on the command line interface can be insecure.
This semi-ominous warning describes a security flaw in passing credentials on a process command line. Any unprivileged user on the system can use a command …
[Read more]
