Migrating from on-prem to RDS/Aurora: to be or not to be, DEFINERS is the question

create schema migration;

use migration;

CREATE TABLE persons (
  PersonID int(11) NOT NULL,
  LastName varchar(255) DEFAULT NULL,
  FirstName varchar(255) DEFAULT NULL,
  Address varchar(255) DEFAULT NULL,
  City varchar(255) DEFAULT NULL,
  PRIMARY KEY (PersonID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci


insert into persons values (1,'Joey','Koz','USA','N. Carolina');
insert into persons values (2,'Wally','G','ARG','MZA');
insert into persons values (3,'Fer','Matt','ARG','QUI');
insert into persons values (4,'Jake','Davis','USA','Kansas');
insert into persons values (5,'Alok','Pathak','IND','Delhi');

CREATE TABLE `persons_audit` (
  `PersonID` int NOT NULL,
  `LastName` varchar(255) DEFAULT NULL,
  `FirstName` varchar(255) DEFAULT NULL,
  `Address` varchar(255) DEFAULT NULL,
  `City` varchar(255) DEFAULT NULL,
  `changedat` datetime DEFAULT NULL,
  PRIMARY KEY (`PersonID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci


DELIMITER $$
CREATE function func_cube (num INT)
returns INT
DETERMINISTIC
begin
  DECLARE totalcube INT;

  SET totalcube = num * num * num;

  RETURN totalcube;
end $$

DELIMITER ;

create view v_persons as select PersonID, LastName, FirstName from persons;

CREATE TRIGGER `before_persons_update` BEFORE UPDATE ON `persons` FOR EACH ROW
INSERT INTO persons_audit
 SET PersonID = OLD.PersonID,
     LastName = OLD.LastName,
     City     = OLD.City,
     changedat = NOW();
$$