Blog : What’s On Our Mind?

Sharing Our Point of View
date_format.jpg
Regular readers of my blog know that from time to time I use the blog as a forum to answer questions I get via e-mail. Today, we address a popular theme – dealing with DB2 date data… Q:I have a DATE column in a DB2 table, but I do not want it to display the way DB2 displays it by default. How can I get a date format retrieved from a column in a table from DB2 database in the format MM/DD/YYYY? A:The simplest way to…
rdbms.jpg
A study, commissioned by Dell Software, shows traditional relational database management systems remains popular among corporate users despite claims and hype to the contrary. Although many various industry reports and prognosticators have stated that unstructured data is growing explosively, fueling the urgent need for technologies to work with it, structured data remains relevant, if not essential, to organizations. Structured data is now growing at a rate faster than unstructured data, according to the report. Structured Data Remains Popular Dell Software found: Although the growth of unstructured data has garnered most…
Galera Cluster
You need your application to stay up and available in case of software/OS crash, network issues, or hardware failure. Simple Master/Slave replication is not Highly Available, since there will be some delay in your application’s availability even under the best of circumstances. Master/Master also has its share of downsides (Primary Key collisions and data drift just to name a couple) that are also amplified when you have network related issues. We could even consider using GTID based replication for data integrity across replication chain and…
MySQL Replication
MySQL 5.7.9, released by Oracle Corporation in October 2015, offers users various updates and new features, our favorite of which is replication. Replication is a key feature that enables users to develop a high-availability database. Most database administrators are familiar with the most standard type of replication: master-slave. The administrator copies the data on the primary server to another server. In the event anything happens to the primary server, the data can be found and easily recovered. MySQL supports numerous types of replication. These include single master-slave…