Blog : What’s On Our Mind?

Sharing Our Point of View
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…
DB2 Date and Time Data
DB2 allows you to add and subtract DATE, TIME, and TIMESTAMP columns. In addition, you can add date and time durations to, or subtract them from, date and time columns. But use date and time arithmetic with care. If you do not understand the capabilities and features of date and time arithmetic, you will likely encounter some problems implementing it. You can make life easier for yourself by keeping the following rules in mind as you code DB2 date/time arithmetic. When you issue date arithmetic…