Score Cards of MySQLDB vs MariaDB vs PostgreSQL
MySQLDB_MariaDB_PostgreSQL_ScoreCards MySQL #Scr MariaDB #Scr PostgreSQL #Scr MySQL application compatible open source RDBMS, enhanced with high availability, security, interoperability and performance capabilities Widely used open source RDBMS Based on the object relational DBMS Postgres …
How to view MySQL stored procedure code ?
To view procedure code in mysql, you must be the owner of the routine or have SELECT access to the “mysql.proc” table and you can use any of the following statements. SHOW PROCEDURE CODE proc_name; SHOW CREATE PROCEDURE proc_name; SELECT…
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…
JDBC Driver connectivity test with MySQL
[ 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 ]…
ODBC Connector installation & connectivity test for 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 @…
[MySQL]: Filtering replication by Column is possible ?
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…
[MySQL]: Replication monitoring alert script
[ 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…
[MySQL]: How to split a string into multiple columns in a SQL statement
mysql> select * from test; +——+———————+ | id | name | +——+———————+ | 1 | /root/path/to/leaf | | 1 | /var/lib/mysql/data | +——+———————+ 2 rows in set (0.00 sec) mysql> mysql> select id,name, SUBSTRING_INDEX(name, ‘/’, 2) as first_val, SUBSTRING_INDEX(name,…
[MySQL]: General/Error log as a solution for user audit log
MySQL General Log : The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. The general…
mysqlfabric commands
[ root @ vm-5cc5-bad6 : ~ ] mysqlfabric group lookup_servers mysql-ha-group Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e Time-To-Live: 1 server_uuid address status mode weight ———————————— ——————- ——- ———- —— 4a914fd4-1eec-11e5-972b-005056bb627d 10.116.175.107:3306 PRIMARY READ_WRITE 1.0 [ root @ vm-5cc5-bad6 : ~ ] [ root…