PostgreSQL and MySQL are types of database management systems (DBMS). This article explains the differences between the systems, reviews the recent trends, and attempts to answer the question of which database management system takes the lead in 2019. Hint: it might not be an either-or answer. Primary Database Model - RDBMS vs ORDBMS Databases store data in an organized manner … [Read more...] about MySQL vs PostgreSQL: 2019 Showdown
sql
2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used
PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines. So what makes PostgreSQL so special, and how … [Read more...] about 2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used
Managing High Availability in PostgreSQL Part II
Are you deploying PostgreSQL in the cloud and want to understand your options for achieving high availability? In our previous blog post, Managing High Availability in PostgreSQL “ Part I, we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by ClusterLabs. In Part II, we're introducing you to an alternative open source tool, Replication Manager … [Read more...] about Managing High Availability in PostgreSQL Part II
2019 Database Trends SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use
Wondering which databases are trending in 2019? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. Get the latest insights on MySQL, MongoDB, PostgreSQL, Redis, and many … [Read more...] about 2019 Database Trends SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use
MySQL Tutorial Understanding The Seconds Behind Master Value
In a MySQL hosting replication setup, the parameter Seconds_Behind_Master (SBM), as displayed by the SHOW SLAVE STATUS command, is commonly used as an indication of the current replication lag of the slave. In this blog post, we examine how to understand and interpret the MySQL Seconds Behind Master value in various situations. Possible Values of  Seconds Behind Master The … [Read more...] about MySQL Tutorial Understanding The Seconds Behind Master Value
