PHPNews

Configuring GTID and binary logging

This tutorial demands a service restart since some flags here presented can not be dynamically changed What is GTID and why do I need it? Directly from the MySQL documentation (excerpt taken as is with different jargons than used here, for master / slave we are using primary / replica ): A global …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Wednesday August 22, 2018


How to setup a Replication User

  A replication user is necessary to set up the relationship Primary / Replica . This is a short step but it needs a bit more of attention. From the MySQL 5.7 documentation (highlights are my own): Although you do not have to create an account specifically for replication, you should be aware that the …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Monday August 20, 2018


A small dive into the MySQL 8.0 X-DevAPI

Introduction What is the X-DevApi? From insidemysql.com there is a definition of the X-DevAPI and its features in the following paragraphs: The X DevAPI is the common client-side API used by all connectors to abstract the details of the X Protocol. It specifies the common set of CRUD-style functions/metho…

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Wednesday July 18, 2018


How to use MySQL 8.0.4 with a GUI

If you want to have a look on what is about to come in the new version of the popular database and is used to Syntax Highlighting you don’t need to be chained to the Terminal. Some of you may use tools like MySQL Workbench or  Sequel Pro (as of the release of this post both tools had the following error occurring…

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Thursday February 22, 2018


Congress, who is? – A Civic Tech project

A while ago I had this idea for a project: To show how representatives voted, either for or against, on bills. People elect representatives but often forget to follow what they are up to. I asked around: who is your representative? The most common response: I don’t know. If people don’t even know who their represent…

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Tuesday November 28, 2017


MySQL 8.0: Preview @ PHPWorld

These are the slides for my MySQL 8.0 Preview: What is coming ? At PHPWorld 2017. Abstract: Yes, you read it correctly, we are jumping from 5.7 to 8.0 (that sounds familiar, doesn’t it?). The new version doesn’t only change the number but also changes how you write SQL. Recursive queries will allow you to …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Wednesday November 15, 2017


Playing with Ruby modules: prepend

In the past month or so I’ve been learning Ruby, this is my first blog post about the language and my experiences learning it. I’d love to hear your feedback. Ruby allows you to work with modules and mixins, giving characteristics to classes and instances that otherwise could only happen through inheritance. One …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Monday July 31, 2017


I don’t know Ops, and that may be OK

I am a Software Engineer at heart. I started as such and worked with PHP for about 7 years, always correlating my work with data somehow until I got an opportunity and decided to follow my instincts and be a Data Engineer. I didn’t turn a Data Engineer from one night to another. It was a process. I was lucky to have …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Friday February 17, 2017