In this three-part blog series, we introduced a High Availability (HA) Framework for MySQL hosting in Part I, and discussed the details of MySQL semisynchronous replication in Part II. Now in Part III, we review how the framework handles some of the important MySQL failure scenarios and recovers to ensure high availability. MySQL Failover Scenarios Scenario 1 “ Master MySQL … [Read more...] about MySQL High Availability Framework Explained Part III: Failover Scenarios
sql
MySQL vs PostgreSQL: 2019 Showdown
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
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
