mariadb connect引擎连接sqlserver

最新推荐文章于 2022-05-20 00:26:35 发布

Angus_yang

最新推荐文章于 2022-05-20 00:26:35 发布

阅读量4.6k

点赞数 1

分类专栏： mariadb 快乐DBA 文章标签： mariadb连接sqlserver mariadb connect引擎

本文链接：https://blog.csdn.net/yangzhawen/article/details/50596717

版权

网上很多使用mariadb的connect引擎连接oracle，唯独没有mariadb使用connect引擎连接sqlserver,特小记一篇.

---1.使用最新版connect

# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 10.1.10-MariaDB-log Source distribution

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.



#rpm2cpio MariaDB-10.1.10-centos6-x86_64-connect-engine.rpm | cpio --extract  --make-directories


#cp /soft/usr/lib64/mysql/plugin/ha_connect.so  /data/mysql/lib/plugin/

root@node01 13:30:33>INSTALL SONAME  'ha_connect';
Query OK, 0 rows affected (0.00 sec)



#  ls /data/mysql/lib/plugin/
adt_null.so              dialog.so                  ha_federatedx.so          metadata_lock_info.so    semisync_master.so
auth_0x0100.so           example_key_management.so  ha_innodb.so              mypluglib.so             semisync_slave.so
auth_pam.so              file_key_management.so     ha_mroonga.so             mysql_clear_password.so  server_audit.so
auth_socket.so           ha_archive.so              handlersocket.so          qa_auth_client.so        simple_password_check.so
auth_test_plugin.so      ha_blackhole.so            ha_spider.so              qa_auth_interface.so     sql_errlog.so
daemon_example.ini       ha_connect.so              ha_test_sql_discovery.so  qa_auth_server.so        wsrep_info.so
debug_key_management.so  ha_example.so              libdaemon_example.so      query_cache_info.so
dialog_examples.so       ha_federated.so            locales.so                query_response_time.so

--权限重要
#chown mysql:mysql -R /data/mysql


root@node01 15:18:54>show engines \G;
*************************** 1. row ***************************
      Engine: MRG_MyISAM
     Support: YES
     Comment: Collection of identical MyISAM tables
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 2. row ***************************
      Engine: MEMORY
     Support: YES
     Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 3. row ***************************
      Engine: MyISAM
     Support: YES
     Comment: MyISAM storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 4. row ***************************
      Engine: CSV
     Support: YES
     Comment: CSV storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
*************************** 5. row ***************************
      Engine: CONNECT
     Support: YES
     Comme