Configuration error: Error: Could not alloc node id at 172.xx.xx.2 port 1186: Connection done from wrong host ip 172.xx.x.4

Im running in datanode 2 ndb_restorebut it get me error.

[root@a5aabaf20dc3 /]# ndb_restore --ndb-connectstring=172.xx.xx.2:1186 \ >                    --nodeid=2 --backupid=1 \ >                    --backup_path=/var/lib/mysql-cluster/BACKUP/BACKUP-1 \ >                    --restore_data --disable-indexes Nodeid = 2 Backup Id = 1 backup path = /var/lib/mysql-cluster/BACKUP/BACKUP-1 Configuration error: Error: Could not alloc node id at 172.xx.xx.2 port 1186: Connection done from wrong host ip 172.xx.x.4. 

also tried --ndb-connectstring "nodeid=2,172.xx.xx.2:1186" and with out port as well as with out --ndb-connectstring at all. nothing made it better

Cluster Configuration --------------------- [ndbd(NDB)] 4 node(s) id=2    @172.xx.xx.4  (mysql-8.0.21 ndb-8.0.21, Nodegroup: 0, *) id=3    @172.xx.xx.3  (mysql-8.0.21 ndb-8.0.21, Nodegroup: 0) id=4    @172.xx.xx.8  (mysql-8.0.21 ndb-8.0.21, Nodegroup: 1) id=5    @172.xx.x.9  (mysql-8.0.21 ndb-8.0.21, Nodegroup: 1)  [ndb_mgmd(MGM)] 1 node(s) id=1    @172.xx.xx.2  (mysql-8.0.21 ndb-8.0.21)  [mysqld(API)]   2 node(s) id=101  @172.xx.xx.5  (mysql-8.0.21 ndb-8.0.21) id=102 (@172.xx.xx.6  (mysql-8.0.21 ndb-8.0.21) 

anyone have idea whats wrong?

Galera: I want to add “Node X” to my cluster but use “Node Y” to transfer the data

I’m having quite a problem with adding a node to my current Galera cluster. Right now I have 4 nodes on my cluster: 3 of them are on my local and 1 currently on the cloud. I successfully synced my cloud node with the local servers earlier.

Now, I want to add my other cloud server to my cluster making it 5, but I want it to use the other node which is also within the cloud so it would be faster (local to cloud took like 2 hours to sync). I tried using wsrep_sst_receive_address and wsrep_sst_donor but it only fails to start the service.

All my servers are using CentOS 7 and has the same galera configuration as follows:

[galera] # Mandatory settings  wsrep_on=ON  wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so    #add your node ips here wsrep_cluster_address="gcomm://alpha,beta,charlie,cloudmain,replica"  binlog_format=row  default_storage_engine=InnoDB  innodb_autoinc_lock_mode=2   #Cluster name  wsrep_cluster_name="my_cluster"   #Allow server to accept connections on all interfaces.  bind-address=0.0.0.0    #this server ip, change for each server  wsrep_node_address="replica"   #this server name, change for each server  wsrep_node_name="Replica Node"    wsrep_sst_method=rsync  

Note: they all have the same config but the name parameters are changed accordingly per server.

I tried adding:

wsrep_sst_receive_address="cloudmain" 

and

wsrep_sst_donor="cloudmain" 

But it is no good. Is it possible to choose a specific server to sync databases from? Thank you.

How to parse XHTML node value with TSQL?

I have the following XHTML and would like to be able to parse out My Node Value. Is there a way to easily do this with TSQL?

<SPAN style="WHITE-SPACE: normal; WORD-SPACING: 0px; TEXT-TRANSFORM: none; FLOAT: none; COLOR: rgb(0,0,0); TEXT-ALIGN: left; FONT: 10px verdana; DISPLAY: inline !important; LETTER-SPACING: normal; TEXT-INDENT: 0px; -webkit-text-stroke-width: 0px">My Node Value</SPAN> 

How to raycast octree for closest leaf node?

So I need to raycast a octree for closest leaf node as efficient as possible. I will be doing it on compute shader (hlsl), but I think it doesn’t matter because first I need to understand the approach and math behind this process in general.

My struct looks like this:

struct OctreeNode {     uint  size; // size of cubic node          uint posX; // center of node     uint posY; // center of node     uint posZ; // center of node          uint childExists;     uint isLeaf;     uint isChild;      uint parentIndex; //Parent node index in structured buffer     uint minchildIndex; // Node child min index in structured buffer (+1 is next child, etc)        uint index; //Index in structured buffer }; 

Octree is rather big, so I guess I can’t afford to raycast everything and then compare distances. I have been looking into https://stackoverflow.com/questions/6281415/octree-raycasting-raytracing-best-ray-leaf-intersection-without-recursion , but I do not understand the answer (especially HLSL one with hitbox what is unknow thing).

Any hints, code, directions highly appreciated.

Migrate from Standalone Instance to Failover Node Instance

I am fairly new to the MS SQL and i am currently working on a project at my company. We have a ERP System built on a SQL Server and we want to create a SQL failover node.

The original configuration is like this :

SQL Standalone Instance SERVER -> SAN Storage (Storage for MDF & LDF).

Is it possible to create a new server, install SQL Server Failover Instance from scratch, then connect the same primary SAN Storage. Import all the user credentials from standalone (original instance) to the new server.?

And when ready to migrate, we simply turn off the Standalone SQL Server, and attach all mdf files in the new server? will this method be good to migrate from standalone instance to failover instance?

Then we have a one node sql cluster available for users to work on

Later we uninstall standalone instance and install a failover sql node on the source Server, then WSFC etc, making it 2 node SQL Cluster?

I thank you for any help that you could provide.

Asif

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".

How to give node sillouhette when behind wall

I am working on a boss-rush fps game. I want it to be like the eye of cthulu fight from terraria, with the enemy flying towards you and then turning around to try again if it misses. However, in order for that to work, the enemy must be visible when they are under the ground. How could I accomplish this? I took this image from a post about a similar question, but for Unity, not Godot.

Why does the formula floor((i-1)/2) find the parent node in a binary heap?

I learned that when you have a binary heap represented as a vector / list / array with indicies [0, 1, 2, 3, 4, 5, 6, 7, 8, …] the index of the parent of element at index i can be found with parent index = floor((i-1)/2)

I have tried to explain why it works. Can anyone help me verify this?

Took reference from Why does the formula 2n + 1 find the child node in a binary heap? thanks to @Giulio