Working with Galera Cluster on MariaDB using RHSC
Starting (or bootstrapping) a Galera Cluster using MariaDB from RHSC (RedHat Software Collection) CANNOT be done with –wsrep-new-cluster option at service start up on RHEL6, e.g. commonly known as: # service mysql start –wsrep-new-cluster <=== This DOES NOT work!!! RHEL…
MariaDB RHSC installation
To stick with current version of MariaDB to ensure receiving the latest features and security patches. Use the following steps to install MariaDB re-distributed by Redhead Software Collection (RHSC) on RHEL 6.x: [root@dbverstyhost ~]# cd /net/e12-dma-04/nas/mariadb/support_files [root@dbverstyhost support_files]# ls -l…
MariaDB – Bulk Inserts using Store Procudere
MariaDB [partition_db]> DROP TABLE IF EXISTS mytable; Query OK, 0 rows affected, 1 warning (0.00 sec) MariaDB [partition_db]> CREATE TABLE mytable (id int(10), pin int(10), dt datetime) PARTITION BY HASH ( SECOND(dt) ); Query OK, 0 rows affected (0.03 sec)…
The program can’t start because LIBEAY32.dll is missing from your computer. Try reinstalling the program to fix this problem
If you’re installing MongoDB with the SSL suport package on the windows it requires libeay32.dll and ssleay32.dll files, please find the below issue raised by MongoDB JIRA https://jira.mongodb.org/browse/SERVER-19086 You can download above dll files from below latest Openssl software collection and copy…
Protecting SSL privatekey with password
Once you’re done with Setting up SSL (openssl) with MariaDB , run below command against your private key to assign a password and out file to a new private key file. [root@dbversity ~]# openssl rsa -aes256 -in /etc/opt/rh/rh-mariadb101/pki/mariadb_private.key -out /tmp/mariadb_privatekey.with_password_aes…
Reading/Parsing a CRL with OpenSSL
Below command used to parse and give you a list of revoked serial numbers: openssl crl -inform DER -text -noout -in mycrl.crl Most CRLs are DER encoded, but you can use -inform PEM if your CRL is not binary. If…
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…