Database Encryption: Why and Where You Need to Have Data Encryption
Database encryption provides enhanced security for your at-rest and in-transit data. Many organizations have started to look at data encryption seriously with recent security breach cases. In most cases, database servers are a common target...
Database Security 101: Security in Open Source Databases
Data security is one of the most significant aspects of administering a database. Depending on the organizational structure, if you are managing the production database, you must monitor for unauthorized access and usage. This also...
Database Security 101: Understanding Database Access Privileges
Data is the new gold for big companies and organizations It's considered as the lifeblood of most modern businesses and there's a bonanza of opportunities to sell or to market to the large audience of...
An Overview of Hybrid Cloud Database Server Architecture
A hybrid cloud environment uses a mix of private and public cloud and even on-premises services and offers many advantages, including scalability, high availability, faster deployments and effective disaster recovery. One known challenge with this...
Transaction Considerations for MongoDB in Production
A MongoDB transaction is a group of throughput operations (reads and writes ) that require all these operations to succeed or fail together. For instance consider transferring money from account A to account B. If...
Working With MyISAM in MySQL
MyISAM is one of the most popular storage engines in MySQL. MyISAM frequently is the second choice after InnoDB - in this blog post we will try to find out how best to work with...
Which Moodle Database Should You Use?
The open source, eLearning LMS Moodle has recently been getting a lot of attention due to the COVID-19 Pandemic. The strain on the resources as educators move their students to eLearning platforms has caused many...
Understanding Character Sets and Collations in MySQL
If you have ever worked with MySQL, you inevitably came across character sets and collations. In this blog post, we will try to give you a more in-depth look at what those two are and...
Understanding the Value of Database Automation in E-Learning
E-learning management systems, such as Moodle, proved to be very valuable during the COVID-19 pandemic. Such systems are developed on pedagogical principles allowing educators and trainers to achieve their training goals. E-learning platforms can greatly...
ClusterControl CLI Secrets – Things You Can Do That Are Not in the GUI
Everybody has a secret, and ClusterControl is not the exception… ClusterControl has a powerful, easy-to-use, and friendly UI, but using this UI is not the only way to manage your clusters. ClusterControl has a CLI...
Managing Journaling in MongoDB
MongoDB just like any other database may fail when executing a write operation. In that case we need a strategy that will keep the operation somewhere so that the database can resume when it is...
Introducing Lookup Charts in MongoDB
If you aren’t familiar with MongoDB, it’s a document-oriented NoSQL data model, which uses documents rather than tables and rows like you would find with relational tables. As such, due to the unique way it’s...