Free instals TablePlus 5.73/28/2024 ![]() ![]() Your chronology isn't right: AWS RDS was released in Oct 2009, and gained multi-AZ replication in May 2010. At that time MySQL replication had a few issues, and it used to break every few days. > (This is before AWS RDS, we had to set replication manually in those days) We had set up replication with ![]() Larger companies typically have self-service generic managed database infrastructure, similar to RDS but internal. With large companies like Meta/Facebook, there is no singular "way" that the company uses a particular database. > The way Facebook or Uber uses MySQL is not how you will use it. Over the years of MySQL has improved and so has PostgreSQL. For others they have similar stories but for different issues they faced in MySQL. ![]() So I started recommending PostgreSQL over MySQL. At that time MySQL replication had a few issues, and it used to break every few days.Īt that time PostgreSQL replication which I was using in other projects was rock solid. (This is before AWS RDS, we had to set replication manually in those days) We had set up replication with MySQL 5.6. In my personal case, I was responsible for managing a Wordpress site with a few million visitors every day. So when web developers encountered those problems and they saw that PostgreSQL didn't have those issues, they started recommending PostgreSQL. The reason PostgreSQL is recommended in last 8-10 years is because just before that time, though MySQL was very popular it had some issues which were solved by PostgreSQL. The way Facebook or Uber uses MySQL is not how you will use it.īoth PostgreSQL and MySQL are powerful databases and if you have right people with proper knowledge highly scalable systems can be developed with both. Also for many of the above companies, when they were started MySQL used to be the popular solution, so they started with it and stayed with it. Your requirements and their requirements are different. ![]() This kind of argument that XYZ company uses ABC software so it's also good for my project is not correct. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |