Overview for 'gabrielaio'
Written by Gabriela D'Ávila
/ Original link
on Aug. 22, 2018
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 transa…
Written by Gabriela D'Ávila
/ Original link
on Aug. 20, 2018
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…
Written by Gabriela D'Ávila
/ Original link
on Aug. 15, 2018
You don’t need this tutorial if you have access to the root user or another one with SUPER and GRANT privileges. The following instructions works for MySQL 5.7. You will need to stop the MySQL server and start it with mysqld_safe with the option skip-grant-tables: sudo service mysql stop sudo mysql…
Written by Gabriela D'Ávila
/ Original link
on Jul. 18, 2018
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 function…
Written by Gabriela D'Ávila
/ Original link
on Feb. 22, 2018
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…
Written by Gabriela D'Ávila
/ Original link
on Feb. 6, 2018
A lot of people ask me to teach them how to do query analysis and performance. The truth is: there isn’t a script to follow. The following paragraphs are a brain dump on what usually goes on my mind when I am debugging and analyzing. Please comment on what you think I should focus on to cover here.…