Accessing remote database metadata

…MariaDB's CONNECT Storage Engine can be used to connect to…tables on a remote database even if that database is not a MySQL database.…As MySQL users, we know that we can find metadata, like table names and…column definitions, with show commands and…queries on the INFORMATION_SCHEMA database.…However, if we are querying a remote database that is not MySQL,…we may not know how to get this kind of information.…Luckily, the connect storage engine has a table type to help solve this problem.…

It is called the catalogue data type, because you want to get a catalogue of…metadata, like table names and column definitions.…The information you can get depends on the type of original data source you have.…And the catalog type you specify.…There are four different kinds of catalog types, each showing different information.…The Table catalog type shows table level information and…is specified with CATFUNC or Catalog Function equals tab.…There's also a column catalog type,…specified by CATFUNC equals col, that shows column level information.…

Resume Transcript Auto-Scroll

Author

Released

9/25/2014

MariaDB is a drop-in MySQL replacement that contains enhancements and new features that MySQL doesn't offer. In this course, Sheeri K. Cabral helps you understand how MariaDB differs from MySQL, and why you might want to make the switch. Since the interface and syntax (and the skills required to work with them) are so similar to MySQL, Sheeri concentrates on the differences: dynamic columns, which allow you store different kinds of data in different rows in a single table; and the powerful Cassandra and CONNECT storage engines, which allow you to harness the power of that data. Start watching and deepen your understanding of this alternative relational database system.