MariaDB SSL CRL testing issue ?!
[usr@hostname pki]# openssl crl -inform DER -text -noout -in DBversity_Internal_DeviceCA_CRL.crl | grep -A1 ‘XXXXXXXXXXXXXX’ Serial Number: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Revocation Date: Dec 6 08:46:28 2016 GMT [usr@hostname pki]# [usr@hostname pki]# [usr@hostname pki]# date Fri Dec 9 06:04:44 EST 2016 [usr@hostname pki]# But…
MySQL/MariaDB vs MongoDB Privileges Comparision
privileges_comparision_mysql_or_mariadb_vs_mongodb
How to Transition from SQL to MongoDB
How to Transition from SQL to MongoDB It’s the ultimate question. Five years ago you would have looked at your company’s environment and you have said “we’re a SQL shop.” The same was true of MongoDB’s 3000+ customers before they…
MariaDB: What is buzzing ?!
MARIADB NEWSLETTER October 2016 Welcome to the MariaDB newsletter, which features our latest updates, news, events and more. There’s so much going on that we can’t possibly fit it all into one newsletter, so keep an eye on mariadb.com to learn…
MariaDB “JDBC/Connector J” Connection with SSL enabled.
[root@dbversity-com rh-mariadb101]# cat /etc/opt/rh/rh-mariadb101/my.cnf # This group is read both both by the client and the server # use it for options that affect everything [client-server] #################### <– Client-Server SSL Options–> ####################################### ssl ssl-cipher = AES128+EECDH:AES128+EDH ssl-ca = /etc/opt/rh/rh-mariadb101/pki/ca.pem ssl-cert…
MariaDB ODBC Driver (Connector/ODBC) testing
root@dbversity-com ]# ll -lhtr -rw-r–r– 1 698K Oct 4 06:42 mariadb-connector-odbc-2.0.12-ga-linux-x86_64.tar.gz [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# tar -zxvf mariadb-connector-odbc-2.0.12-ga-linux-x86_64.tar.gz mariadb-connector-odbc-2.0.12-ga-linux-x86_64/lib64/libmaodbc.so mariadb-connector-odbc-2.0.12-ga-linux-x86_64/share/doc/mariadb_connector_odbc/COPYING mariadb-connector-odbc-2.0.12-ga-linux-x86_64/share/doc/mariadb_connector_odbc/README [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# ll -lhrt -rw-r–r– 1 698K Oct 4…
Configuring MariaDB With PAM/Kerberos
Please note below directions assume the system is already setup to use AD for user logins. What is here will enable a MariaDB to leverage a system’s current setup. It will not deploy AD from scratch. As of MariaDB 5.0,…
SQL Database Performance Tuning for Developers
Database tuning can be an incredibly difficult task, particularly when working with large-scale data where even the most minor change can have a dramatic (positive or negative) impact on performance. In mid-sized and large companies, most SQL database tuning will…
[MariaDB]: Enforcing SSL for all connections
If we’ve configured required ssl configuration in the my.cnf and enabled ssl globally with required variables (have_ssl, have_open_ssl). Though we create users without REQUIRE SSL privilege, they will use SSL connection. [ root @ dbversity : /var/lib/mysql ] grep ‘ssl’…