bitcoin core – Does my node rebroadcast its mempool transactions on startup?

When a node shuts down cleanly, it does flush the mempool to disk and reloads it upon startup. It will not rebroadcast the transactions.

A node will only relay transactions once, when it first learns about them. Your wallet will cause its own transactions to be rebroadcast. There is currently no other mempool-level mechanism that rebroadcasts any foreign transactions ever after the initial relay.

Especially due to the privacy implications thereof, there is on-going work to change node behavior such that it will generally rebroadcast all transactions that should have been included in the previous block: [p2p] Introduce node rebroadcast module #21061

MySQL Group Replication starts master node with super_read_only

I am trying to set up MySQL group replication. Only problem is, that when I try to start replication group, It starts with super_read_only.

Here the configurations in my.cnf file

(mysqld)

max_binlog_size = 4096
default_authentication_plugin     = mysql_native_password

log_bin                           = mysql-bin-1.log
enforce_gtid_consistency          = ON
gtid_mode                         = ON
log_slave_updates                 = ON
binlog_checksum                   = NONE

plugin-load-add                   = group_replication.so
plugin-load-add                   = mysql_clone.so
relay_log_recovery                = ON
transaction_write_set_extraction  = XXHASH64
loose_group_replication_start_on_boot                    = OFF
loose_group_replication_group_name                       = 74fe8890-679f-4e93-9169-a7edfbc1d427
loose_group_replication_group_seeds                      = mysql_cluster_mysql0_1:3306, mysql_cluster_mysql1_1:3306, mysql_cluster_mysql2_1:3306
loose_group_replication_single_primary_mode              = ON
loose_group_replication_enforce_update_everywhere_checks = OFF
bind-address = 0.0.0.0

instances are run inside docker, that’s why group seed addresses has these hostnames.

Also here the procedure for running master instance.

DELIMITER $$

USE `db`$$

DROP PROCEDURE IF EXISTS `set_as_master`$$

CREATE DEFINER=`root`@`%` PROCEDURE `set_as_master`()
BEGIN
  SET @@GLOBAL.group_replication_bootstrap_group=1;
  CREATE USER IF NOT EXISTS 'repl'@'%';
  GRANT REPLICATION SLAVE ON *.* TO repl@'%';
  FLUSH PRIVILEGES;
  CHANGE MASTER TO MASTER_USER='root' FOR CHANNEL 'group_replication_recovery';
  START GROUP_REPLICATION;
  -- SELECT * FROM performance_schema.replication_group_members;
END$$

DELIMITER;

After running CALL start_as_master; in Sqlyog, process stucks on below lines.

'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.

2021-03-03T21:47:55.934818Z 8 (System) (MY-013587) (Repl) Plugin group_replication reported: 'Plugin 'group_replication' is starting.'

2021-03-03T21:47:55.935929Z 9 (System) (MY-011565) (Repl) Plugin group_replication reported: 'Setting super_read_only=ON.'

Why does it run with super_read_only=ON?
Is there anything I miss during configuration or running script?

MySQL version is 8.0.23.

unity – Make the texture array node work with cubemaps?

I am working on a procedural interior mapping shader in Unity’s Shader Graph. Ideally, I’d like to feed it a set of cubemaps it can pick from semi-randomly.

However, it seems that by default the texture array asset one can provide to a graph does not support reading cubemaps.

Does anyone have a way to use this, or perhaps a clever custom node or alternate texture mapping, so that I can read a number of cubemaps into the shader semi-randomly? Preferably an arbitrary number, but even a fixed number would be somewhat of an improvement.

8 – How to get a multilevel taxonomy reference field to output as nested UL in node tpl?

I have a simple 2 level taxonomy vocabulary field but I can’t seem to find a way to output the terms (labels) in a nested UL in my node TPL. There are no display formatter options at all and I can’t find any info on this?

{{ content.field_my_terms }} just gives me field__items with flattened field__item.

unity – Rotate a Polygon node in Shader Graph

What does the Vector1 of the Polygon output represent

It represents whether the current pixel being shaded is inside (1) or outside (0) the polygon.

and is there a way I can rotate it as if it were a texture?

Just like with a texture, you don’t rotate the colour value coming out of the node. You have to rotate the sample coordinates going into the node.

Here’s one way to do it, putting a Rotate node between UV0 and the Polygon node:

Rotating the UVs

Or you can just swap the X and Y axes of your input coordinate:

Swizzling X & Y

MYSQL cluster issue: shutdown data node correctly breaks replication

I faced issue on mysql cluster (5.7.28), i shuted down properly vm6 (data nodes) and the mysql replication was broken, i’m trying to make the link bettwen the datanode down and the replication broken but i still can’t find the reason (below the relevant), is there someone who can help me to find the link

Slave: Got error 4009 ‘Cluster Failure’ from NDB Error_code: 1296 (Warning) Slave: Can’t lock file (errno: 157 – Could not connect to storage
engine) Error_code: 1015
Error running query, slave SQL thread aborted. Fix the problem, and
restart the slave SQL thread with “SLAVE START”.

deployment – Does Ansible offer a way to build/compile on the control node, and then deploy to managed nodes?

Is there any way to have Ansible run a build script locally on the control node, and then deploy the resulting artifact to various managed nodes?

Please let me know if there’s something I’ve missed, but I looked at the docs for the shell, command and script modules, and they each only seem to allow execution on the managed node. I’m really surprised I can’t find a way to run a command on the control node.

Maybe this isn’t in Ansible’s wheelhouse?
Is the idea that you’re supposed to use some other tool like Make to do the build, and then Ansible only handles copying it to servers?

ssl – Nginx fails to proxy to Node

I have a running Node app that is live and works fine on http and https.

I setup Nginx and it is also running fine, tested with an sshtunnel, and it is getting a correct response from static files (such as MyPath/index.html).

However, I am trying to get Nginx to work as a reverse-proxy for Node.
Because I want to make another app on my machine, and Nginx should sort the incoming requests for each app.

But there seems to be an issue with Nginx I cannot figure out. I suspect it is a config problem. When I try to reach my Node app, I always get an error page from my browser, saying that there is an SSL issue.

Nginx config

server {
        listen (::):4444 default_server;
        server_name localhost mysite.com www.mysite.com;    

        access_log /home/mysite/access-log;    

        location / {
            proxy_pass http://127.0.0.1:5555;
        }
}    

I tried changing http://127.0.0.1:5555 to https://127.0.0.1:6666 but that didn’t change anything.

Node app

const port = 5555;
const secureport = 6666;    

const privateKey = fs.readFileSync('PATHTOCERT');
const certificate = fs.readFileSync('PATHTOKEY');
const credentials = {key: privateKey, cert: certificate};    


I use an express app instance here, also configured CSP with helmet. But I don’t think that’s the problem, because I disabled helmet and that did not solve anything.

const httpServer = http.createServer(app);
const httpsServer = https.createServer(credentials, app);    

httpServer.listen(port);
httpsServer.listen(secureport);