After mysql 8.0.24 does master-slave replication, if the master database hangs, how does the slave database switch to the master database?

After mysql 8.0.24 does master-slave replication, if the master database hangs, how does the slave database switch to the master database? If it can switch, what are the exact steps?

If switching is not possible, what mode can be used so that if a primary database hangs, another database, which is synchronised with the primary database in real time, can operate normally and can be read and written to?

Setup amazon aurora as replica to mariadb master

I am trying to setup replication between MariaDB 10.4.17 and Aurora 5.7.12 MySQL, with Mariadb as master and aurora as replica. I am following this aws article

I noted the file name and position

+---------------+----------+--------------+------------------+ | File          | Position | Binlog_Do_DB | Binlog_Ignore_DB | +---------------+----------+--------------+------------------+ | binlog.000169 |  1387829 |              |                  | +---------------+----------+--------------+------------------+ 

I created mysql dump from mariadb and loaded that into aurora. after which I created a replication user on the master instance like this

CREATE USER 'replication_aurora'@'%' IDENTIFIED BY 'repl_pass';

GRANT REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO 'replication_aurora'@'%';

and called the procedure on Aurora

CALL mysql.rds_set_external_master ('ip of master', 3306,     'replication_aurora', '<password>', 'binlog.000169', 1387829, 0); 

more about the above procedure here then i called this procedure

CALL mysql.rds_start_replication; 

This was supposed to start replication but I am getting this when i run SHOW SLAVE STATUS \G;

*************************** 1. row ***************************                Slave_IO_State:                   Master_Host: master_ip                   Master_User: replication_aurora                   Master_Port: 3306                 Connect_Retry: 60               Master_Log_File: binlog.000169           Read_Master_Log_Pos: 1387829                Relay_Log_File: relaylog.000001                 Relay_Log_Pos: 4         Relay_Master_Log_File: binlog.000169              Slave_IO_Running: No             Slave_SQL_Running: Yes               Replicate_Do_DB:           Replicate_Ignore_DB:            Replicate_Do_Table:        Replicate_Ignore_Table: mysql.rds_replication_status,mysql.rds_monitor,mysql.rds_sysinfo,mysql.rds_configuration,mysql.rds_history       Replicate_Wild_Do_Table:   Replicate_Wild_Ignore_Table:                    Last_Errno: 0                    Last_Error:                  Skip_Counter: 0           Exec_Master_Log_Pos: 1387829               Relay_Log_Space: 2754               Until_Condition: None                Until_Log_File:                 Until_Log_Pos: 0            Master_SSL_Allowed: No            Master_SSL_CA_File:            Master_SSL_CA_Path:               Master_SSL_Cert:             Master_SSL_Cipher:                Master_SSL_Key:         Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No                 Last_IO_Errno: 1593                 Last_IO_Error: Fatal error: The slave I/O thread stops because a fatal error is encountered when it tries to get the value of SERVER_UUID variable from master.                Last_SQL_Errno: 0                Last_SQL_Error:   Replicate_Ignore_Server_Ids:              Master_Server_Id: 1                   Master_UUID:              Master_Info_File: mysql.slave_master_info                     SQL_Delay: 0           SQL_Remaining_Delay: NULL       Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates            Master_Retry_Count: 86400                   Master_Bind:       Last_IO_Error_Timestamp: 210424 15:42:38      Last_SQL_Error_Timestamp:                Master_SSL_Crl:            Master_SSL_Crlpath:            Retrieved_Gtid_Set:             Executed_Gtid_Set:                 Auto_Position: 0          Replicate_Rewrite_DB:                  Channel_Name:            Master_TLS_Version: 

I am thinking error could be while creating the user I created 'replication_aurora'@'%' instead of creating 'replication_aurora'@'replica ip' is this the issue?

I am unable to check because the connection endpoint aurora gives is more than 60characters long so i cannot create a user with that endpoint on my mariadb master.

Question.

  1. is not giving replica ip in user is the issue?
  2. is compatibility the issue?
  3. should i also create the same user on replica?

I am sort of at a dead end here please help any article or video would be helpful

How do I delete a user from the master database when the user has been deleted from the Server Logins using the SSMS Object Explorer

I am using an Azure SQL Database. I deleted some users from a Azure SQL database after I saw them mentioned in a Vulnerability Assessment report. Here’s how I deleted them:

  1. Log in to SSMS
  2. Expand the Object Explorer tree
  3. Expand the ‘Security’ folder
  4. Expand the ‘Logins’ folder
  5. Highlight the user
  6. Right-click and select ‘Delete’

I went back to the Vulnerability Assessment blade and ran a new ‘Scan’ but the users I deleted still show up in the list. The list included SQL code to show that my users still exist. I ran that code back in SSMS in the master database and confirmed my users still exist. Here’s the relevant code:

SELECT * FROM sys.database_principals

When I run the following code, I get an error saying the user does not exist (‘or you do not have permission’ – but I am a server admin so I ruled that out):

DROP LOGIN <username>

How do I get rid of these logins?

Does a buckler stack with the AC from the feat Shielded Gauntlet Master?

The biggest advantage of a buckler is that you keep a hand free while still gaining a shield bonus. You are also able to wear a gauntlet (normal, locked, or spiked) while keeping that hand free. Lets assume that the buckler is a +1 buckler so its providing a +2 shield bonus, and the gauntlet is just a +2.

The feat Shielded Gauntlet Master says

While using Shield Gauntlet Style, you no longer lose your shield bonus to AC when you attack with your gauntlet (or spiked gauntlet) or use it to hold a weapon. In addition, you add your gauntlet’s enhancement bonus to the shield bonus to AC granted by this feat as if it were a shield enhancement bonus.

So, does the bucklers shield bonus stack with the bonus from the feat? Since both would provide +2, is the final shield AC +2 or +4?

Does Voice of the Chain Master allow casting certain spells from an isolated space?

An interesting question popped into my brain recently while researching the Pact of the Chain for a Genie Patron Warlock. Casual shenanigans aside, I was wondering if taking Voice of the Chain Master allowed me to cast certain spells while safely tucked in my vessel but, maybe not in the way you think I’m going to ask about. Allow me to elaborate;

As per Voice Of The Chain Master

You can communicate telepathically with your familiar and perceive through your familiar’s senses as long as you are on the same plane of existence. Additionally, while perceiving through your familiar’s senses, you can also speak through your familiar in your own voice, even if your familiar is normally incapable of speech.

I’m led to believe that Bottled Respite is NOT another plane of existence, since similar items like a Portable Hole specifically mention when they are.

You can use an action to unfold a portable hole and place it on or against a solid surface, whereupon the portable hole creates an extradimensional hole 10 feet deep. The cylindrical space within the hole exists on a different plane, so it can’t be used to create open passages.

I think it’s safe to assume then, that the interior of the Vessel is simply ‘bigger on the inside’ and not an isolated dimension that you’re teleported to. With this in mind, let’s clarify one more subject before moving on.

I want to be clear; I’m not using my Familiar to ‘carry’ the spell. I understand those limitations. I’m using them purely for approximating my own visual range and my interest is in the wording of certain spells that require you to target ‘a creature you can see within range,’which also don’t otherwise state the spell ‘traveling’ through space in any specific fashion. Let’s set up our hypothetical from here, and pick a spell I personally think would have suitable water retention for this argument.

My Warlock is safely within a collar or ring (The Vessel) worn by my familiar (standing or sitting against nearest wall in the forward facing direction of the ring, to avoid losing as much spell range as possible), through which, I am perceiving through their sight as though I’m in their space (technically, I am, since they are carrying me.) I want to cast Flesh to Stone and I see a creature within 60ft of me (and am confident the range is correct because me and my familiar are occupying the same space). I cast Flesh to Stone which has a range of 60ft and, has the following description;

You attempt to turn one creature that you can see within range into stone. If the target’s body is made of flesh, the creature must make a Constitution saving throw. On a failed save, it is restrained as its flesh begins to harden. On a successful save, the creature isn’t affected.

A creature restrained by this spell must make another Constitution saving throw at the end of each of its turns. If it successfully saves against this spell three times, the spell ends. If it fails its saves three times, it is turned to stone and subjected to the petrified condition for the duration. The successes and failures don’t need to be consecutive; keep track of both until the target collects three of a kind.

If the creature is physically broken while petrified, it suffers from similar deformities if it reverts to its original state.

If you maintain your concentration on this spell for the entire possible duration, the creature is turned to stone until the effect is removed.

RAW it seems pretty sound from my point of view but, I also just really like this combat tactic so, I may be overlooking something. Thoughts?

Master of Many Forms Tripper Questions

So, general background is i am making a gestalt character and was dead set on basing it off of a tripper i absolutely loved playing awhile back. The DM is fairly open to any official source except BoED, BoVD, Dragon Mag, or any psionics. The last bit is what tripped (no pun intended) me up. The original build used psy warrior to get expansion for the ability to go large.

I came up with the idea of going master of many forms to get the Improved wild shape large and humanoid so i could just shape into a large version of myself.

My questions are…

  1. Would this work?
  2. How would stats be affected when i shape (i assume it would just be the standard medium to large adj, but i’m not sure)?
  3. Is there a better option out there (i know this plan comes with the issue with gear melding, i have plans for that as well)?

I have the build planned out to level 12 as of right now and would be more than willing to share if asked, but i don’t think those details are relevant to the questions right now.

Shield Master – Can the shield push be taken before an attack?

Can the shield push from the Shield Master feat be taken before an attack? i.e. Push prone, follow up with an attack while they’re down.

Shield Master

You use shields not just for protection but also for offense. You gain the following benefits while you are wielding a shield:

If you take the Attack action on your turn, you can use a bonus action to try to shove a creature within 5 feet of you with your shield.

What are the risks of upgrading DB major version in replica and then promoting it as master?

Recently AWS decided to force update all MariaDB RDS under 10.3, and I am using AWS and my RDS are using MariaDB 10.1. We are trying to minimize the downtime and any risk of data out of sync.

Our plan is to create a replica and upgrade it from 10.1 to 10.5. After that we will let it to consume binlog from old non-upgraded RDS then promoting it as Master and point our website to the newly created and upgrade RDS.

Assume we will have continuous stream of data coming into the RDS, what are the risk of steps above? Is the new RDS able to get all binlog genereated during the upgrade time? We estimated there will be ~ 1.5 hours to finish upgrading from 10.1 to 10.5

Thank you for helping