It appears that Amazon is introducing a new service specifically targeted at Relational Databases helpful hints. You can choose from MySQL, Oracle, and Microsoft Sql Server. Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming…
Databases Administration
Covering NoSQL, Relational Database, Data Visualization, and Reporting.
Looking at the Hadoop MapReduce Capacity, Fair, and Hod Schedulers.
Today | started looking at the different MapReduce Schedulers, because I would like to be able to start the processing on a new jobs when slots became available. So I started look at the other schedulers that come with Hadoop. The Capacity Scheduler: The Capacity Scheduler is designed to run Hadoop Map-Reduce as a shared,…
Serengeti Soups Up Apache Hadoop
The primary goal of Bigtop is to build a community around the packaging, deployment and interoperability testing of Hadoop-related projects. This includes testing at various levels (packaging, platform, runtime, upgrade, etc…) developed by a community with a focus on the system as a whole, rather than individual projects. If you looking for in easy to…
Apache Bigtop Hadoop
The primary goal of Bigtop is to build a community around the packaging, deployment and interoperability testing of Hadoop-related projects. This includes testing at various levels (packaging, platform, runtime, upgrade, etc…) developed by a community with a focus on the system as a whole, rather than individual projects. If you looking for in easy to…
MySQL Cheat Sheet
Found this today. Not to bad for a quick reference sheet. MySQL Cheat Sheet
Hortonworks Releases Its (Conservative) Hadoop Platform
Check this article out. “Hortonworks sets itself apart from Cloudera and MapR by sticking with standards-based software and Apache’s proven 1.0 code line.” >>
Configuring MySQL as a Hive Metastore
Hive uses DerbyDB to store its metadata by default, if you have ever tried having more than one person, or multiple services, such as the Hive Web UI or Hive Service connect, it doesn’t work really well and can cause problems. To improve this I recommend use MySQL as the metastore_db. Install a MySQL…
Hadoop, Hive, Oh my.
Sorry, I haven’t really wrote anything in the last couple of months, but after a year or more of reading about Hadoop and poking at it. I have actually got the chance to do something with it. A year or so ago I helped build a MySQL database to help analyze user data. A large amount…
Using Mysqldump to Backup Your Stored Procedures, Functions and Triggers
Now that MySQL has Stored Procedures, Functions and Trigger. I have found myself needing to back them up or make copies to move to a different MySQL server. It’s actually pretty easy to do with mysqldump. Here is the command line for it. shell> mysqldump –routines –no-create-info –no-data –no-create-db –skip-opt <database> > outputfile.sql Then if you…
Slacking over the Holidays
So December was an interesting month for me, with a few changes in my personal career and the holidays. I take a week off. Which of course lead me spending two weeks catching up on work and to top it off my boss or someone above him decided that we need to take look at…