This is a post based on recent tutorials I published , with the goal of discussing how to prepare your current MySQL instance to be configured as an External Primary Server with a Replica/Follower into Google Cloud Platform.
First, I want to talk about the jargon used here. I will be using primary to …
This tutorial is for you that is trying to import your current database into a Google Cloud SQL instance, replica , that will be setup for replication purposes.
According to the documentation , you will need to run:
-h [MASTER_IP] -P [MASTER_PORT] -u [USERNAME] -p \
--databases [DBS] \
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 …
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 …
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
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…
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…
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.
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…
These are the slides for my MySQL 8.0 Preview: What is coming ? At PHPWorld 2017.
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 …
I created a React package called react-usa-map
It displays the USA map with the states including DC / Hawaii / Alaska
It’s MIT license
Install instructions on The package section of this post.
I am working on a project which may or may not go much further. I am building a …
For the past couple months, I’ve been studying. As a side effect, my GitHub account was cluttered with code that is experimental. I didn’t exactly want to trash the experimental code. I wanted to keep my code but also not specifically keep it under my profile.
The solution I found was to create an organization and …
SQLite is really a good tool to set up quick proof of concepts and small applications; however it’s not the most robust solution on the market for working with relational databases. In the open source community two databases take the top of the list: PostgreSQL and MySQL .
I did a small project for my studies. …
Developers in general love when stuff works. Having a solution that can solve about 80% of your problems can leave time for you to deal with the other 20%.
But this post is not about Active Record vs. Data Mapper or any thing like it. Each one has its use case where it’s best applicable and it depends on you (or …
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 …
Disclaimer : This post is aimed to you, the curious developer, sys-admin, technologist, whatever-title-you-use. DO NOT run the following lines on production. Not even in a stable environment, do this if you don’t care about the outcome of the current data.
If you want to keep up with the newest MySQL developer …
This post is a case study of a job I had to do in a legacy application, it doesn’t mean it will apply to you, but it might.
This is a table of contents:
Converting to a JSON array
1st step: remove the leading commas
2nd step: add brackets to the string
3rd step: …
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 …
Prior to my talk at LaraconEU 2016 I was curious to know how much adoption for MySQL 5.7 was in within the community.
I tweeted this:
Pool, use twitter client to see it:
Which Version of MySQL do you use? SELECT @ VERSION ; RT for reach, please. — Gabriela D'Ávila (@gabidavila) August 23, 2016
This post will be updated as soon more information comes along.
This developer version wasn’t released yet, when it does, use at your own risk.
Oracle released the development version of MySQL 8.0.0-dmr on September 12th of 2016. Since then, the team have been working on the 8.0.1 development milestone. …