You are currently browsing the archives for posts tagged as MySQL.

Planning for a MySQL Cluster Setup

Recently, I’ve had the opportunity to setup a MySQL Cluster infrastructure for a major educational institution. Theoretically, the deployment is a straightforward process. Of course like most IT projects, the actual roll-out process is only a minor concern.

The process of gluing together the components and making sure they stick solidly is where the challenge is more extreme.

In this article, I’m not going to discuss how to setup a MySQL Cluster. There are tons of documentations regarding this procedure already available. What I’ll be touching on is presented more as a deployment strategy, preparation and maintenance guide.

By the way, if your organization is interested in deploying a MySQL Cluster infrastructure, please note that HTNet Solutions provides this service and would be more than happy to get yours up and running.

Read the rest of Planning for a MySQL Cluster Setup »

Oracle Bags Sun For $7.4 Billion

You got to hand it to Oracle, they have managed to do what IBM failed merely two weeks ago: Oracle has bought Sun for $7.4 billion. That’s just under six percent more than what IBM offered in the now collapsed talk.

This deal is definitely an industry-defining event as mentioned in the linked BusinessWeek article. The massive potential of the combined IT giants will be a force to be reckoned with.

Nevertheless, I still worry for the future of MySQL; the popular open source database platform Sun acquired in 2008. It now has to compete internally with Oracle’s own database engine which drives a significant bulk of its revenue. My fear is that instead of building on the MySQL technology, Oracle may just choose to let it dwindle into obscurity. To add to worries, Oracle already has its own open source database platform in the form of Berkeley DB.

The silver lining is that MySQL is just too big to be ignored. It is without a doubt, the most widely deployed database engine in the world. Its significance in the web hosting industry cannot be overstated. So eventhough I worry about MySQL’s future within the Oracle camp, I’m sure that basic economics and the wonderful way in which open source works will, in the end, prevail.

Congrats to Oracle; you’ve definitely got a potential winner in your hands now. Let’s see what you do with it 🙂

VBA + MySQL: Checking For Duplicate Key Before Data Insertion

This article has been long overdue; so I apologize to newbie who orignally asked how to do duplicate key checking before inserting Excel data into a MySQL database.

I got a few minutes of free time today, so I decided to draft a sample workbook that will demonstrate this process. You can download the sample workbook here. Standard disclaimer: This file has been found to be virus-free when uploaded. However, you are highly recommended to scan the file again with an up to date anti-virus software before opening it.

Read the rest of VBA + MySQL: Checking For Duplicate Key Before Data Insertion »

Inserting An Unknown Number Of Excel Rows Into MySQL With VBA

I’ve been asked how to insert an unknown number of lines of data from an Excel spreadsheet into MySQL. I thought that rather than answer that question in a comment reply, I might as well create a sample Excel spreadsheet with the solution already in place.

Of course, I will explain the rationale behind my method in this article first 🙂

Read the rest of Inserting An Unknown Number Of Excel Rows Into MySQL With VBA »

Inserting Data Into MySQL From Excel Using VBA

seun asked in an old post of mine, Interfacing with MySQL via Excel; whether it’s possible to submit data from Excel into MySQL.

Yes, it is very much possible to do this. In fact, I’ve written a tutorial on how to do this with the help of VBA.

Read the rest of Inserting Data Into MySQL From Excel Using VBA »