[ 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 ]…
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…
Q) When using mongoimport to import a CSV, the field “00234” will get imported as the number 234, is there any way to specify field type of each field or is there any other solution for the same so that…
[ root @ dbversity : /var/lib/mysql ] tar -zxvf mysql-connector-java-5.1.36.tar.gz mysql-connector-java-5.1.36/ mysql-connector-java-5.1.36/docs/ –blah blah —– mysql-connector-java-5.1.36/src/testsuite/ssl-test-certs/server-cert.pem mysql-connector-java-5.1.36/src/testsuite/ssl-test-certs/server-key.pem mysql-connector-java-5.1.36/src/testsuite/ssl-test-certs/server-req.pem mysql-connector-java-5.1.36/src/testsuite/ssl-test-certs/test-cert-store [ root @ dbversity : /var/lib/mysql ] [ root @ dbversity : /var/lib/mysql ] [ root @ dbversity : /var/lib/mysql ]…
Please check your OS version and bit type and download the required ODBC Driver for MySQL from http://dev.mysql.com/downloads/connector/odbc/ [ root @ myhostname : ~ ] cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.6 (Santiago) [ root @…
You can download MariaDB Galera Linux package from the link https://downloads.mariadb.org/mariadb-galera/10.0.20/#os_group=linux_generic [ root @ maria-galera : /mariadb ] ll -lhtr total 142M -rw-r–r– 1 root root 142M Aug 11 08:18 mariadb-galera-10.0.20-linux-x86_64.tar.gz [ root @ maria-galera : /mariadb ] […
You can download mariadb package from https://downloads.mariadb.org/ and copy to your linux box [ root @ vm-16af-8253 : /mariadb ] ll -lhtr total 296M -rw-r–r– 1 sm70768 mongod 296M Aug 11 01:38 mariadb-10.0.21-linux-x86_64.tar.gz [ root @ myhostname : /mariadb ]…
We can restrict table level replication with below parameters in MySQL Solutions for column level are … 1) Custom script • Export data with required fields to a csv from Master server ( with SELECT INTO OUTFILE syntax) • Create…
[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~]…
[ root @ dbversity : ~ ] cat Slave_status.sh #!/bin/bash LOGFILE=slavestatus.log mkdir -p /binlogs/cronjobs/Error_Log yum -y -q mail ## ======================================================= **********SLAVE STATUS************* ======================================================================= array=(10.x.xx.xx) for i in “${array[@]}” do #mysql -h$i -umonitor -p’password’ -e”show slave status\G” > /binlogs/cronjobs/Error_Log/$i_Slave_Status.txt 2>/binlogs/cronjobs/Error_Log/$i_Slave_Status.txt mysql…