MemSQL’s Kerberos setup with SSL
As of MemSQL 5.0, MemSQL includes an authentication plugin that enables a MemSQL Server to use PAM (Pluggable Authentication Modules) to authenticate users. PAM enables a system to use a standard interface to access various kinds of authentication…
Create dblink from oracle to memsql
Install required RPM packages Configure ODBC gateway Setup environment variable Configure listener.ora and tnsnames.ora Configure ODBC listener Create database link and test2 Environment: Database DB Name DB Version Host Name OS Version Oracle PCRADMN…
MemSQL 4.1.7 – ODBC & JDBC Connectivity
Below document describe you on how to Install MemSQL 4.1.7 version and Connectivity test with MySQL JDBC and ODBC Drivers. Please refer to my previous posts for previous version setup documents for detailed information. [ root @ dbversity : /memsql/memsql-ops-4.0.31/memsql-ops…
ODBC Connectivity test with MemSQL
[ root @ dbversity : /tmp ] rpm -ivh unixODBC-2.2.14-14.el6.x86_64.rpm warning: unixODBC-2.2.14-14.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY Preparing… ########################################### [100%] 1:unixODBC ########################################### [100%] [ root @ dbversity : /tmp ] [ root @ dbversity : /tmp ]…
MySQL JDBC Connectivity issues with MemSQL
While testing the connectivity with MySQL JDBC Connector for MemSQL, I’m receiving below errors. My code works fine with MySQL Database but fails with MemSQL Database. Assuming this might be the issue because MemSQL doesn’t have init_connect global variable. Please…
[MemSQL]: Installation with Ops Manager
[Dev root @ dbversity1host~]# ll -lhtr total 164M -rw-r–r– 1 root root 149M Jul 30 09:59 memsqlbin_amd64.tar -rw-r–r– 1 root root 15M Jul 30 09:59 memsql-ops-4.0.31.tar [Dev root @ dbversity1host~] [Dev root @ dbversity1host~]# mkdir /memsql [Dev root @ dbversity1host~]…
[MemSQL]: 4.0 Installation thorough memsql ops
MemSQL_4.0_Installation_thorough_memsql_ops
What is NewSQL ?
What is NewSQL : NewSQL is a category of SQL database products that address the performance and scalability issues posed by traditional online transaction processing (OLTP) relational database management systems (RDBMS). Such systems aim to achieve the scalability of NoSQL…
Node requirement for MemSQL commands
MemSQL commands must be run on the appropriate type(s) of node in a MemSQL cluster. Please refer the link MemSQL Commands by Type — MemSQL 2.6 documentation for more details. X = recommended to run on this type of node…
MemSQL Aggregation commands
some useful Aggregator commands. At Master Aggregator :- ——————— Please find the each command description at http://developers.memsql.com/docs/latest/ref/index.html#select mysql> select database(); +————+ | database() | +————+ | ycsb | +————+ 1 row in set (0.00 sec) mysql> show tables; +—————–+ |…