In a MySQL 5.7 master-slave setup that uses the default semisynchronous replication setting for rpl_semi_sync_master_wait_point, a crash of the master and failover to the slave is considered to be lossless. However, when the crashed master comes back, you may find that it has transactions that are not present in the current master (which was previously a slave). This behavior … [Read more...] about Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication Setup
server
What is the Best Architecture for your Application: Monolith, Microservices or Serverless?
Choosing the right architecture is critical for the overall success of your product. The three most popular architectures used in the IT world are Monolith, Microservices, and Serverless. Each one offers its own advantages to create exactly the right sort of solution for your users with the best possible experience. Let's take a look at each architecture separately to see how … [Read more...] about What is the Best Architecture for your Application: Monolith, Microservices or Serverless?
Managing MySQL Server Logs: Rotate, Compress, Retain & Delete
MySQL Server generates several logs that can help you monitor the activities of the server. However, once these logs are enabled, they can grow in size and start taking up too much disk space. This is why it's important to have an automated way of archiving and preserving MySQL log files for a certain duration, as well as deleting the old ones. In this blog post, we describe … [Read more...] about Managing MySQL Server Logs: Rotate, Compress, Retain & Delete
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
How To Set Up A Server Room For Your Small Business
It's more imperative for small businesses to have easy and secure access to important information they need to succeed now than ever before, but many entrepreneurs and hard-working professionals are at a loss when it comes to effectively set up a server room for themselves. Despite the allure of a third-party data hosting service, it's indisputably true that dedicated, … [Read more...] about How To Set Up A Server Room For Your Small Business