lunedì 29 ottobre 2018

Repair slave in MySQL GTID replication

Run these commands on MySQL shell, to find "where" replication failed and was broken.

Stop the slave.
stop slave;

Find the point where replication broke.
show slave status\G;

Now find "Executed_Gtid_Set". Example value:
Executed_Gtid_Set: 44d966cc-d84d-11e8-be8d-20677cd3f384:1-2872

Increase of one step to 2873
SET GTID_NEXT="44d966cc-d84d-11e8-be8d-20677cd3f384:2873";

Now start the slave.
start slave;
show slave status\G;

Here is another useful tutorial, if the problem persists

Continue the loop until no error occurs. Enjoy

lunedì 30 aprile 2018

Choosing a visual to represent data

How do you choose a visual to represent data?

Here is a handy diagram that can be used to determine the right chart type to use in your data visualization.


Cerca su Google

Cerca nel Blog con Google