Skip to main content

StreamShift Documentation

MySQL / MariaDB setup

Source setup

If the source and target are both MySQL and you are doing a "Lift and Shift only" migration, create a user for use by Striim and grant it SELECT privileges on all tables to be migrated.

In all other cases (including when the source and target are both MariaDB), set up the source as described in MySQL / MariaDB setup.

Target setup

  1. Create the target database(s).

  2. Create a CHKPOINT table in one of the target databases.

    CREATE TABLE CHKPOINT (
  id VARCHAR(100) PRIMARY KEY, 
  sourceposition BLOB, 
  pendingddl BIT(1), 
  ddl LONGTEXT);

  3. Create a user for use by Striim as follows, replacing ******** with a strong password. You may use any user name you wish.

    CREATE USER 'striim'@'%' IDENTIFIED BY '********';
GRANT ALTER, CREATE, DELETE, DROP, INSERT, SELECT ON *.* TO 'striim'@'%';

    If the source and target are both MySQL, add these additional privileges:

    GRANT ALTER ROUTINE, CREATE ROUTINE, CREATE VIEW, EVENT, LOCK TABLES, REFERENCES, RELOAD,
  REPLICATION CLIENT, TRIGGER, UPDATE ON *.* TO 'striim'@'%';
In this section: