Database monitoring comes in a variety of formats, ranging from high-level reporting of system health to assessing granular operations that could impact application performance. Monitoring Options DBMS monitoring extensions: Extensions or add-ons within the database layer that provide insights on query efficiency, database connections, and more. Cloud provider monitoring tools: Most cloud providers include free […]

Horizontal scaling can address high-traffic growth and solve availability issues. It addresses these issues by adding additional servers to your infrastructure Together the servers form a high availability (HA) cluster Adding servers can lead to more complexity in the design of your infrastructure and require changes to your services’ configuration and/or application code. Even with […]

Designing Database Architecture Many websites and web applications can be operated with a single-server configuration, where your database exists on the same server as all of the application’s other software components. This can be appropriate when your server (possibly when paired with external storage, like block storage) has enough compute and storage resources to accommodate […]

Cassandra is an open source columnar database that supports very large amounts of structured data Cassandra does not declare a primary server; instead, data is distributed in a cluster of nodes, eachof which can process client requests This provides an “always-on” architecture that is extremelyappealing for enterprise applications that cannot experience database downtime Cassandra was […]

Redis (short for “REmote DIctionary Server”) is an open source in-memory database that is useful for applications that require rapid data updates in real time Redis stands out from relational databasesby using key-value pairs to store data, resulting in faster response times when fetching data Redis is ideal for projects with a clearly-defined data structure […]

MongoDB is a document database that stores data as JSON documents to provide more flexibility for scaling and querying data based as an application evolves MongoDB is a solution for database requirements that stray away from relational data schemas This approach allows users to start creating documents without needing to first establish a document structure, […]

PostgreSQL, also known as Postgres, is considered to be the most advanced open source database and a more robust SQL database alternative to MySQL Postgres is also the stronger choice for workloads that are dependent on database write operations and the ability to add custom data types Postgres is open source and all features are […]

Here’s a quick overview of five top databases that serve a range of use cases. This list includes both SQL and NoSQL options. MySQL is one of the most widely used database engines MySQL is a component of the LAMP stack, which serves as the foundation for many content management systems, including WordPress MySQL is […]

Evaluating the Strengths and Limitations of Database Operations Databases are anything but “one size fits all.” From privacy and compliance to supporting specific data types, databases only get more advanced as an application scales Even if you aren’t a database administrator (DBA), you need to factor in database capabilities and limitations when adding new features […]