cannal 读取mysql binlog 日志

{"data":[{"user_id":"20000071","login_ip":"3232264387","login_time":"2019-11-22 15:46:40"}],"database":"umc","es":1574408874000,"id":1040683,"isDdl":false,"mysqlType":{"user_id":"int(10) unsigned","login_ip":"int(10) unsigned","login_time":"datetime"},"old":[{"login_time":"2019-11-22 10:25:22"}],"pkNames":null,"sql":"","sqlType":{"user_id":4,"login_ip":-5,"login_time":93},"table":"user_login_ip","ts":1574408796429,"type":"UPDATE"}
{"data":[{"id":"624186258113978368","price":"7519.980000000000000000","contract_id":"1001","formula":null,"created_date":"2019-11-22 15:46:40"}],"database":"58future","es":1574408800000,"id":605281,"isDdl":false,"mysqlType":{"id":"bigint(32)","price":"decimal(40,20)","contract_id":"bigint(32)","formula":"varchar(256)","created_date":"datetime"},"old":null,"pkNames":["contract_id","created_date"],"sql":"","sqlType":{"id":-5,"price":3,"contract_id":-5,"formula":12,"created_date":93},"table":"tb_future_index_price","ts":1574408796609,"type":"INSERT"}
{"data":[{"id":"624185983080120321","user_id":"333385950","currency_id":"8","contract_id":null,"amount":"199999999.000000000000000000","fee_rate":"0.000000000000000000","new_user_balance":"1123307572794622.621618260000000000","old_user_balance":"1123307372794623.621618260000000000","old_balance":"1123307372794623.621618260000000000","new_balance":"1123307572794622.621618260000000000","fee":"0.000000000000000000","target_id":"1395939","action":"2","status":"1","user_realised":null,"created_date":"2019-11-22 15:46:08"},{"id":"624186058980245506","user_id":"333385950","currency_id":"8","contract_id":"2001","amount":"99999999.000000000000000000","fee_rate":"0.000000000000000000","new_user_balance":"7502632494.967429750000000000","old_user_balance":"7402632495.967429750000000000","old_balance":"7407070820.138155660000000000","new_balance":"7507070819.138155660000000000","fee":"0.000000000000000000","target_id":"624186162894094336","action":"30","status":"1","user_realised":null,"created_date":"2019-11-22 15:46:17"}],"database":"58regular_future","es":1574408800000,"id":605282,"isDdl":false,"mysqlType":{"id":"bigint(20)","user_id":"bigint(20)","currency_id":"bigint(20)","contract_id":"bigint(32)","amount":"decimal(40,20)","fee_rate":"decimal(40,20)","new_user_balance":"decimal(40,20)","old_user_balance":"decimal(40,20)","old_balance":"decimal(40,20)","new_balance":"decimal(40,20)","fee":"decimal(40,20)","target_id":"bigint(20)","action":"int(2) unsigned","status":"int(2)","user_realised":"decimal(40,20)","created_date":"datetime"},"old":[{"new_user_balance":null,"old_user_balance":null,"old_balance":null,"new_balance":null,"status":"0"},{"new_user_balance":null,"old_user_balance":null,"old_balance":null,"new_balance":null,"status":"0"}],"pkNames":["id"],"sql":"","sqlType":{"id":-5,"user_id":-5,"currency_id":-5,"contract_id":-5,"amount":3,"fee_rate":3,"new_user_balance":3,"old_user_balance":3,"old_balance":3,"new_balance":3,"fee":3,"target_id":-5,"action":4,"status":4,"user_realised":3,"created_date":93},"table":"tb_system_ledger","ts":1574408796710,"type":"UPDATE"}
{"data":[{"currency_id":"8","user_balance":"1123307572794622.621618260000000000","balance":"1123307572794622.621618260000000000","fee":"0.000000000000000000","insurance_fund":"655130.376297640000000000","realised":"0.000000000000000000","created_date":"2019-07-10 11:35:50","modify_date":"2019-11-22 15:45:36","over_loss_summary":"{\"2009\":{\"overLoss\":72.51950020000000000000,\"realised\":219.89848595000000000000,\"balance\":117642069.90878459000000000000,\"insuranceFund\":0,\"fee\":108.11238201000000000000,\"contractId\":2009,\"userBalance\":117641961.79640258000000000000},\"2008\":{\"overLoss\":0,\"realised\":305.51321655000000000000,\"balance\":26263461.01999976000000000000,\"insuranceFund\":0,\"fee\":1198.87812583000000000000,\"contractId\":2008,\"userBalance\":26262246.81847093000000000000},\"2007\":{\"overLoss\":0,\"realised\":0,\"balance\":89582.55988900000000000000,\"insuranceFund\":0,\"fee\":0.00459517000000000000,\"contractId\":2007,\"userBalance\":89582.55529383000000000000},\"2006\":{\"overLoss\":0,\"realised\":0,\"balance\":24310.00000000000000000000,\"insuranceFund\":0,\"fee\":0,\"contractId\":2006,\"userBalance\":24310.00000000000000000000},\"2005\":{\"overLoss\":0,\"realised\":0,\"balance\":3150.00000000000000000000,\"insuranceFund\":0,\"fee\":0,\"contractId\":2005,\"userBalance\":3150.00000000000000000000},\"2004\":{\"overLoss\":172119.55581661000000000000,\"realised\":183998.72398154000000000000,\"balance\":8142591.00000000000000000000,\"insuranceFund\":0,\"fee\":294.48396660000000000000,\"contractId\":2004,\"userBalance\":8142296.51603340000000000000},\"2003\&

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值