Mydbops MyWebinar 11th edition – Speaker Announcement

Mydbops propounds free webinars & meetups about MySQL, MongoDB, and PostgreSQL, the major three opensource databases.  What greater thing can we give to our community than to diversify their skill sets and improve their craftsmanship by providing free Webinars with niche topics, illustrations, Q&A, and, most importantly, more fun as we work together to sharpen our … Continue reading Mydbops MyWebinar 11th edition – Speaker Announcement

Faster Load data outfile in MySQL

While exporting the table with MySQL native utility, we don't have any control on the process, and also there will be no progress update as well on the process completion. So when exporting the larger table will consume high resource utilization and also the disk space usage will also be high. MySQL shell utility will … Continue reading Faster Load data outfile in MySQL

Troubleshooting an unique key addition during pt-online-schema-change

We all tried various alternative methods for modifying the table structure, but pt-online-schema-change (pt-osc) is the most convenient and preferred method for performing the alter online. It has more granular control too. But it may lead to data loss if proper precautionary steps are not taken care of. In this blog, we are going to … Continue reading Troubleshooting an unique key addition during pt-online-schema-change

PostgreSQL automatic failover with pg_auto_failover

PostgreSQL is a powerful, open-source relational database with a strong reputation for reliability, robustness, and performance. It supports replication to achieve high availability for a very long. But it lacks an important feature on its own, that is the concept of automated failover. Of course, there are a lot of open-source tools available to do … Continue reading PostgreSQL automatic failover with pg_auto_failover

Synopsis of Mydbops 11th edition of opensource database meetup

We’re ecstatic and energised at the prospect of sowing the seeds of knowledge in our opensource database community. Thank you to everyone who came out to our 11th opensource database meetup. Our meetup series began in 2018, and the 11th edition took nearly three years to complete. However, we prioritised quality above quantity when distilling. As … Continue reading Synopsis of Mydbops 11th edition of opensource database meetup

11th Opensource Database Meetup – Speaker Announcement

Mydbops propounds free webinars & meetups about MySQL, MongoDB, and PostgreSQL, the major three opensource databases.  What greater thing can we give to our community than to diversify their skill sets and improve their craftsmanship by providing free Webinars with niche topics, illustrations, Q&A, and, most importantly, more fun as we work together to sharpen … Continue reading 11th Opensource Database Meetup – Speaker Announcement

Maintenance of MySQL Binary logs

In this blog, we are going to discuss the Maintenance of binary logs. Before going into our topic, let’s recall the basics of binary logs. Binary logs           Binary logs contain all the changes and records that take place in any database. It will log the statements like CREATE, ALTER, DELETE, INSERT and UPDATE. It will … Continue reading Maintenance of MySQL Binary logs

Synopsis of Mydbops 10th edition of MyWebinar

We are merry & galvanized for bestowing seeds of cognizance to our opensource database community. Thank you to all those who attended in our 10th edition of MyWebinar.  We hope our session was able to elevate & seam your workmanship to perfection. We are committed in giving back to our opensource database community by hosting more … Continue reading Synopsis of Mydbops 10th edition of MyWebinar

Mydbops MyWebinar 10th edition – Speaker Announcement

Mydbops propounds free webinars & meetups about MySQL, MongoDB, and PostgreSQL, the major three opensource databases.  What greater thing can we give to our community than to diversify their skill sets and improve their craftsmanship by providing free Webinars with niche topics, illustrations, Q&A, and, most importantly, more fun as we work together to sharpen our … Continue reading Mydbops MyWebinar 10th edition – Speaker Announcement

Aurora MySQL Parallel query Performance and its gains

As a continuation to my previous blog , I have made benchmarking to find the performance improvement using parallel query.Before starting the testing, we will go through the monitoring stats variables and query analysis (explain). Monitoring Aurora Parallel Query stats S:NoParameter Purpose 1Aurora_pq_request_attemptedNo of attempt that query tried to use parallel query feature.2Aurora_pq_request_executedNo of query … Continue reading Aurora MySQL Parallel query Performance and its gains