Tag: MySQL
Kafka Connect AvroConverter Union type
I have Kafka Connect connector using AvroConverter that is reading Debezium CDC Kafka topic generatet from MySQL database. The connector config looks as follows configurationOverrides: “key.converter”: “io.confluent.connect.avro.AvroConverter” “value.converter”: “io.confluent.connect.avro.AvroConverter” “key.converter.schema.registry.url”:…
MySQL Query faster alternative to DISTINCT and REGEXP
You might get faster performance using FIND_IN_SET and a couple of joins: SELECT DISTINCT locations.* FROM locations INNER JOIN users users_include ON users_include.user_id = 1 AND FIND_IN_SET(users_include.user_locations, locations.combined_locations) > 0…
Error during connection to database: TMySQL57Connection : Server connect failed. -Problema Installazione CQRLOG su LINUX POP-OS.
Dopo aver Installato CQRLOG, all’avvio si presenta questo errore:Cqrlog Ver:2.5.1 (001) Date:2021-01-24**** DEBUG LEVEL 1 **** OS:Linux version 5.16.11-76051611-generic (jenkins@warp.pop-os.org) (gcc (Ubuntu 11.2.0-7ubuntu2) 11.2.0, GNU ld (GNU Binutils for Ubuntu)…
Could not install Nginx/Mysql/PHP – aaPanel
Here is the log.sort: cannot read: ping.pl: No such file or directory–2022-03-18 10:16:07– node.aapanel.com/install/3/nginx.shResolving node.aapanel.com (node.aapanel.com)… 104.21.79.196, 172.67.171.7, 2606:4700:3031::6815:4fc4, …Connecting to node.aapanel.com (node.aapanel.com)|104.21.79.196|:443… connected.HTTP request sent, awaiting response… 200 OKLength:…