123 lines
12 KiB
Plaintext
123 lines
12 KiB
Plaintext
include/master-slave.inc
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
[connection master]
|
|
SET @number_of_srss =
|
|
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS);
|
|
CREATE SPATIAL REFERENCE SYSTEM 1000000000
|
|
NAME 'foo_1000000000'
|
|
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
|
|
CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 1000000001
|
|
NAME 'foo_1000000001'
|
|
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
|
|
CREATE SPATIAL REFERENCE SYSTEM IF NOT EXISTS 1000000002
|
|
NAME 'foo_1000000002'
|
|
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
|
|
SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
|
|
SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
|
|
foo_1000000000 1000000000 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
foo_1000000001 1000000001 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
foo_1000000002 1000000002 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
include/sync_slave_sql_with_master.inc
|
|
[Connection Slave]
|
|
SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
|
|
SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
|
|
foo_1000000000 1000000000 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
foo_1000000001 1000000001 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
foo_1000000002 1000000002 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000000));
|
|
ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000000))
|
|
1000000000
|
|
SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000001));
|
|
ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000001))
|
|
1000000001
|
|
SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002));
|
|
ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002))
|
|
1000000002
|
|
[Connection Master]
|
|
DROP SPATIAL REFERENCE SYSTEM 1000000000;
|
|
DROP SPATIAL REFERENCE SYSTEM 1000000001;
|
|
CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 1000000002
|
|
NAME 'foo_1000000000'
|
|
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
|
|
SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID = 1000000002;
|
|
SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
|
|
foo_1000000000 1000000002 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
include/sync_slave_sql_with_master.inc
|
|
[Connection Slave]
|
|
SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID = 1000000002;
|
|
SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
|
|
foo_1000000000 1000000002 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002));
|
|
ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002))
|
|
1000000002
|
|
[Connection Master]
|
|
DROP SPATIAL REFERENCE SYSTEM IF EXISTS 1000000002;
|
|
SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
|
|
SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
|
|
include/sync_slave_sql_with_master.inc
|
|
[Connection Slave]
|
|
SELECT * FROM INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS WHERE SRS_ID = 1000000000;
|
|
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME SRS_NAME SRS_ID GEOMETRY_TYPE_NAME
|
|
SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000000));
|
|
ERROR SR001: There's no spatial reference system with SRID 1000000000.
|
|
[Connection Master]
|
|
BEGIN;
|
|
CREATE SPATIAL REFERENCE SYSTEM 1000000000
|
|
NAME 'foo_1000000000'
|
|
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
|
|
CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 1000000001
|
|
NAME 'foo_1000000001'
|
|
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
|
|
CREATE SPATIAL REFERENCE SYSTEM IF NOT EXISTS 1000000002
|
|
NAME 'foo_1000000002'
|
|
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
|
|
SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
|
|
SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
|
|
foo_1000000000 1000000000 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
foo_1000000001 1000000001 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
foo_1000000002 1000000002 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
include/sync_slave_sql_with_master.inc
|
|
[Connection Slave]
|
|
SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
|
|
SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
|
|
foo_1000000000 1000000000 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
foo_1000000001 1000000001 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
foo_1000000002 1000000002 NULL NULL GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]] NULL
|
|
SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000000));
|
|
ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000000))
|
|
1000000000
|
|
SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000001));
|
|
ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000001))
|
|
1000000001
|
|
SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002));
|
|
ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002))
|
|
1000000002
|
|
[Connection Master]
|
|
COMMIT;
|
|
BEGIN;
|
|
DROP SPATIAL REFERENCE SYSTEM 1000000000;
|
|
DROP SPATIAL REFERENCE SYSTEM 1000000001;
|
|
DROP SPATIAL REFERENCE SYSTEM IF EXISTS 1000000002;
|
|
include/sync_slave_sql_with_master.inc
|
|
[Connection Slave]
|
|
SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
|
|
SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
|
|
SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID >= 1000000000 AND SRS_ID <= 1000000002;
|
|
SRS_NAME SRS_ID ORGANIZATION ORGANIZATION_COORDSYS_ID DEFINITION DESCRIPTION
|
|
SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000000));
|
|
ERROR SR001: There's no spatial reference system with SRID 1000000000.
|
|
SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000001));
|
|
ERROR SR001: There's no spatial reference system with SRID 1000000001.
|
|
SELECT ST_SRID(ST_GeomFromText('POINT(0 0)', 1000000002));
|
|
ERROR SR001: There's no spatial reference system with SRID 1000000002.
|
|
[Connection Master]
|
|
COMMIT;
|
|
SELECT @number_of_srss = COUNT(*) AS should_be_true
|
|
FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS;
|
|
should_be_true
|
|
1
|
|
include/sync_slave_sql_with_master.inc
|
|
include/rpl_end.inc
|