网上很多使用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
mariadb connect引擎连接sqlserver
最新推荐文章于 2022-06-18 12:24:01 发布
这篇博客详细记录了如何使用MariaDB的Connect引擎连接到SQL Server。首先,介绍了安装最新版Connect引擎的步骤,包括复制库文件并授权。然后,展示了启用Connect引擎并检查其状态的过程。接着,博主介绍了自动和手动安装unixODBC 2.3.0的细节,这是连接到SQL Server所需的。最后,博主安装了微软的ODBC驱动,配置DSN,并创建了一个通过ODBC连接到SQL Server的Connect引擎表,验证了数据的双向同步功能。
摘要由CSDN通过智能技术生成