Mobile Alerts & Notifications For Your Database Using Telegram
One of the great features of Telegram is its bot platform. Users can interact with bots by sending them messages, commands and inline requests and it can be controlled by using HTTPS requests to Telegram's...
An Overview of pgModeler for PostgreSQL
When a project is being designed, the first thing to think about is what its purpose will be... what is the best solution, and what are the alternatives. In software engineering, everything is done to...
A Guide to MySQL Galera Cluster Streaming Replication: Part Two
In the first part of this blog we provided an overview of the new Streaming Replication feature in MySQL Galera Cluster. In this blog we will show you how to enable it and take a...
A Guide to MySQL Galera Cluster Streaming Replication: Part One
Streaming Replication is a new feature which was introduced with the 4.0 release of Galera Cluster. Galera uses replication synchronously across the entire cluster, but before this release write-sets greater than 2GB were not supported....
Factors to Consider When Choosing MongoDB for Big Data Applications
Technology advancements have brought about advantages than need to be exploited by business organizations for maximum profit value and reduced operational cost. Data has been the backbone for these technological advancements from which sophisticated procedures...
What's New in PostgreSQL 12
On October 3rd 2019 a new version of the world's most advanced open source database was released. PostgreSQL 12 is now available with notable improvements to query performance (particularly over larger data sets and overall...
What’s New in MySQL Galera Cluster 4.0
MySQL Galera Cluster 4.0 is the new kid on the database block with very interesting new features. Currently it is available only as a part of MariaDB 10.4 but in the future it will work...
What to Know When Start Working with MongoDB in Production – Ten Tips
Learning MongoDB requires a lot of precise thinking. Little consideration is often not made in essential undertakings that could otherwise jeopardise the performance of the database in production mode. MongoDB is a NoSQL DBMS which...
MongoDB Database Automation Basics Using Chef
Managed environments grow over time, often as a result of the increased data involvement or maybe due to the need of increasing performance through shared workload. Because of this there is a need to add...
PostgreSQL Top Learning & Training Resources
Oftentimes, people want to know about “That One Place” to get all their learning and training resources for PostgreSQL. When I get such a question from a colleague, my typical response it to tell them...
The Most Common PostgreSQL Failure Scenarios
There is not a perfect system, hardware, or topology to avoid all the possible issues that could happen in a production environment. Overcoming these challenges requires an effective DRP (Disaster Recovery Plan), configured according to...
Database Switchover and Failover for Drupal Websites Using MySQL or PostgreSQL
Drupal is a Content Management System (CMS) designed to create everything from tiny to large corporate websites. Over 1,000,000 websites run on Drupal and it is used to make many of the websites and applications...