Instalacia:

apt install mariadb-plugin-connect

Vytvorenie “Federated table”:

CREATE TABLE radcheck_radius1 (
    id     INT(20) ,
    username   VARCHAR(64),
    attribute  varchar(32),
	op			char(2),
    `value`		varchar(253),
    `created`	timestamp,
    `starts`	timestamp,
    `expire`	timestamp,
    `tukeid`	varchar(9) 
)
ENGINE=CONNECT table_type=MYSQL dbname=radius tabname=real_radcheck
CONNECTION='mysql://uzivatel:tajneheslo@db1.test.sk:3306/radius/real_radcheck';

DOC:

https://mariadb.com/kb/en/connect-mysql-table-type-accessing-mysqlmariadb-tables/

   Send article as PDF