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…
Application Development with Rapid Application Development Framework AllcountJS
The idea of Rapid Application Development (RAD) was born as a response to traditional waterfall development models. Many variations of RAD exist; for example, Agile development and the Rational Unified Process. However, all such models have one thing in common:…
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…
[NuoDB]: Overview & Installation
NuoDB is a distributed cloud database management system with a rich SQL implementation and full support for transactions. NuoDB is designed to offer: * Scale-out Performance * Continuous Availability * Geo-Distribution * Multi-Tenancy * No Knobs Administration As a distributed…