Category: Databases Administration
-
MySQL Error: 1062 'Duplicate entry' Error
Written by
on
The all too common MySQL ‘Duplicate entry’ Error. mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: master-mysql.local Master_User: repl Master_Port: 3306 Connect_Retry:…
-
Installing MariaDB 10.1 on CentOS 6.8
Written by
on
MariaDB is a fork of the MySQL; it is notable for being led by the original developers of MySQL and is community-developed. The original developers forked it due to concerns…
-
Querying Apache Hadoop Resource Manager with Python.
Written by
on
Querying Apache Hadoop Resource Manager with Python. I was recently asked to write a script that would monitor the running application on the Apache Hadoop Resource Manager. I wonder over…
-
Resizing InnoDB Logs
Written by
on
If you have already created your database and you change the setting for “innodb_log_file_size=###M” and restart here you database and get an error that looks something like InnoDB: Error: log…
-
MongoDB Script for counting records in collections in all the databases
Written by
on
Here is a quick script. I wrote for a co-worker. var host = “localhost” var port = 27000 var dbslist = db.adminCommand(‘listDatabases’); for( var d = 0; d < dbslist.databases.length;…
-
Apache Oozie – Shell Script Example.
Written by
on
Recently I needed the ability to allow a user to submit jobs that required them to pass arguments to a shell script. While it’s easy enough to submit a job using…
-
-
Connecting Tableau to DataStax Cassandra with Cassandra CQL ODBC.
Written by
on
Recently, I did some testing with Tableau Desktop connecting to DataStax Cassandra using their newly released DataStax ODBC driver. Before the release of the DataStax ODBC driver, the only way to…
-
Connecting Tableau to Google Cloud SQL
Written by
on
Before connecting your Tableau Application up to your Google Cloud SQL Instance, you will need to make sure that you have assigned an IP Address to the instance. You will…
-
Elasticsearch
Written by
on
Elasticsearch is a distributed restful search and analytic tool that is built on the top of Apache Lucene for high performance. Elasticsearch features include: Real-Time Data Indexing Scalability High Availability…