Does MySQL update indexes on virtual columns on tables that are being replicated from a master?
1
vote
0
answers
288
views
We use statement based bin log master-slave replication with MySQL 5.7.
We use the slave for analytics and so add additional indexes and things not required on the master.
I recently tried to add a virtual column and indexed it.
Unfortunately, it seems that none of the new data being replicated ends up in the index.
When I query the new rows, the generated column values are present and correct but when I filter the table on the generated column values, none of the rows created since the index was created are returned.
Am I doing something wrong here or is this not supported with bin log replication?
Asked by km6zla
(111 rep)
Jun 4, 2018, 10:15 PM
Last activity: Jun 8, 2018, 08:11 PM
Last activity: Jun 8, 2018, 08:11 PM