Generate Invisible Primary Key (GIPK) MySQL 8.0

The Primary key is like the hero of a row, which has more beneficial features in the table while performing any task on the table. The DBA knows the importance of the primary key in the table and how to handle it. Notable features of having a primary key:Requirements:Enabling GIPK:Handling GIPK:BenchmarkingData loading :Limitations:Conclusion: Notable features … Continue reading Generate Invisible Primary Key (GIPK) MySQL 8.0

Advertisement

Synopsis of Mydbops 18th edition of MyWebinar

We’re ecstatic and energized about the prospect of sowing seeds of knowledge in our open-source database community. Thank you to everyone who joined us for the 18th edition of MyWebinar. We hope that our time together helped to elevate and seam your work to perfection. We’re committed to giving back to the opensource database community … Continue reading Synopsis of Mydbops 18th edition of MyWebinar

MongoDB Rule for Indexing (Series: 1)

Any database must have an index, thus MongoDB is not exceptional in this regard. MongoDB features a tonne of interesting index types with fantastic properties based on the use cases it was created for. It has been a very long time since I considered writing a series of blogs about the MongoDB index at all … Continue reading MongoDB Rule for Indexing (Series: 1)

Synopsis of Mydbops 17th edition of MyWebinar

We’re ecstatic and energised about the prospect of sowing seeds of knowledge in our opensource database community. Thank you to everyone who joined us for the 17th edition of MyWebinar. We hope that our time together helped to elevate and seam your work to perfection. We’re committed to giving back to the opensource database community … Continue reading Synopsis of Mydbops 17th edition of MyWebinar

Beware of your Backup before upgrading MySQL 8.0.30

MySQL 8.0.30 was released on 26-07-2022. It has a good list of features. Generated Invisible Primary Key Dynamic Redo log Sizing Instruments to monitor group replication memory Support for Ubuntu 22.04 A most notable feature for Database Administrators and database reliability engineers is Dynamic redo logging. The more widely adopted open-source backup tool is Xtrabackup. … Continue reading Beware of your Backup before upgrading MySQL 8.0.30

MySQL Schema change With Skeema – Part 2 “Production use cases”

In the previous blog, we have gone through the Basic operation of the Skeema tool. In this blog, we will see the production use case of the Skeema tool. Selective schema setup :All (Global) servers :Selective server execution:Selective schema validation of production server :Concurrency and other notable options :Environment based Execution:Conclusion : Selective schema setup … Continue reading MySQL Schema change With Skeema – Part 2 “Production use cases”

Load Balancing/Query Routing using PGPOOL-II ( Part-II)

In our first part of the Pgpool-II series, the Installation and Configuration of Pgpool-II were discussed. This part will focus on one prominent feature of Pgpool-II, which is Load Balancing/Query Routing.  What is Load Balancing?Why do we need Pgpool-II for load balancing?How is it actually work?Types of Load Balancing modesSession Level Load Balancing:Statement Level Load … Continue reading Load Balancing/Query Routing using PGPOOL-II ( Part-II)

Synopsis of Mydbops 16th edition of MyWebinar

We’re ecstatic and energised about the prospect of sowing seeds of knowledge in our opensource database community. Thank you to everyone who joined us for the 16th edition of MyWebinar. We hope that our time together helped to elevate and seam your work to perfection. We’re committed to giving back to the opensource database community … Continue reading Synopsis of Mydbops 16th edition of MyWebinar

Stream MySQL data with mydumper

Mydumper supports streaming of backups right from version 0.11.3 and the latest version Mydumper 0.12.3 it enabled its support for compressed streaming backup. This was the most awaited feature added to Mydumper, making it a more powerful tool for data migration to RDS or Cloud. If you are hearing mydumper for the first time, then … Continue reading Stream MySQL data with mydumper

MySQL Schema change With Skeema – Part 1 “Basic Operations”

As a Database Engineer, One of the biggest challenges in day-to-day activity is performing DDL on high-traffic and transaction-intensive tables. It will become overhead when handling a large number of servers/shards. As a standard process, we will first deploy the changes in DEV and QA before deploying them in production. In the sharded environment, It … Continue reading MySQL Schema change With Skeema – Part 1 “Basic Operations”