After installing the go-mydumper, mystreamer script is not generated in bin directory

[Suresh145]

Hi Guys,

I have installed the go-mydumper this tool was really awesome. I have downloaded this tool from git.

After installation I am not seeing the mystreamer script in bin directory.

In this post they are using 3 tools

mydumper

myloader

mystreamer

Blog - https://www.programmersought.com/article/79812350875/

But i am seeing only (mydumper & myloader) Can you please let me know why this script was missing ?

And I have one more doubt. In config file you have mentioned below point's

# Use this to override value returned from tables. These are optional
[select]
# user.salt = 'reset salt of all system users'
# user.password = 'reset password of all system users'

# customer.first_name = CONCAT('Bohu', id)
# customer.last_name = 'Last'

what is the purpose of this settings can you please explain more clearly ?

[BohuTANG]

There is no streamer build in the lastest version.

[Suresh145]

Hi BohuTANG,

Thanks for your quick response. Is it possible to use streamer in latest version ?

And one more thing in config file below points are mentioned

# Use this to override value returned from tables. These are optional
[select]
# user.salt = 'reset salt of all system users'
# user.password = 'reset password of all system users'

# customer.first_name = CONCAT('Bohu', id)
# customer.last_name = 'Last'

what is the purpose of this settings can you please explain more clearly ?

[BohuTANG]

There is no streamer in the latest version, so we can't use it never.
The config mentioned is used here:
https://github.com/xelabs/go-mydumper/blob/master/config/config.go#L92-L106

The main idea is to mark your sensitive data with another value.

[Suresh145]

Hi BohuTANG,

Thanks, I have taken a full dump using go-mydumper. Post completion of the backup it does not capture the binlog file and position. The metadata file is empty. Even I have mentioned master_data=2 on config file.

Without binlog and position, replication configuration is very difficult. Please correct me if i am wrong.

vars= "master_data=2;single-transaction"

[root@centos14 go-mydumper]# cd ../dumper-sql/
[root@centos14 dumper-sql]# ls -lrth
total 2.7M
-rw-r--r--. 1 root root   38 Mar 16 00:59 mysql-schema-create.sql
-rw-r--r--. 1 root root    0 Mar 16 00:59 metadata

[BohuTANG]

metadata is a empty and we can't use it anymore.
This is more complex in the multi-thread dumping, so mydumper fakes it.