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

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 »

Backing Up And Restoring Your MySQL Database Via Command Line

One priceless benefit of having a web hosting provider that gives you SSH access to the server is that there’s a wealth of command line tools that can make data management very easy for you. In this post, I’m going to illustrate how you can use some of MySQL’s command line tools to back up (export) and restore (import) your database.

Read the rest of Backing Up And Restoring Your MySQL Database Via Command Line »

Cool SQL Tool: Instant SQL Formatter

I found Instant SQL Formatter a while ago. From my initial tests, I found that it can generate code that’s nicely formatted and readable.

The following databases are supported:

  • MS Access
  • MSSQL
  • MySQL
  • MS Access
  • PLSQL
  • Generic SQL

Pretty useful tool if you do lots of database SQL stuff.