Mydbops·4h agoHow MySQL Replication Filters WorkSuppose a MySQL source has an imdb database, but a replica only needs the movies table. Where you filter matters. A filter on the source…
Mydbops·1d agoHow to Stop an Index Build in MongoDBStopping an index build and dropping a finished index can involve the same command. What matters is the state of the index when MongoDB…
Mydbops·5d agoMongoDB Queryable Encryption: How to Search Encrypted FieldsSuppose a medical records application needs to find a patient by Social Security number. The application needs an exact match, but the…
Mydbops·5d agoOptimistic and Pessimistic Locking in TiDBTwo customers try to reserve the same concert seat. The booking system could hold the seat as soon as one customer selects it, or it could…
Mydbops·6d agoConverting a Physical Standby to a Logical Subscriber in PostgreSQL 17Setting up logical replication on a large PostgreSQL database can take longer than creating the publication and subscription. The initial…
Mydbops·6d agoMariaDB Backup and Recovery with MariaBackupA physical backup gives you a copy of the database files you need to recover from a hardware failure, a server crash, or an accidental…
Mydbops·Nov 5Online Schema Changes on MySQL Tables with Existing TriggersChanging a table’s structure becomes more complicated when that table already has triggers. An online schema change tool must keep the…
Mydbops·Nov 4Why MySQL Doesn’t Always Use an IndexYou add an index, run EXPLAIN, and see key: NULL. That can mean MySQL estimated that another access method would cost less, or that the…
Mydbops·Nov 3How to Install a Specific MySQL 8.0 Version Using YumWhen you’re reproducing a production issue, preparing a replica, or setting up an environment for disaster recovery or user acceptance…
Mydbops·Oct 29Managing PostgreSQL Logs: Configuration, Rotation, and RetentionPostgreSQL logs help explain what happened inside a database server. They provide information for investigating failed statements…A response icon1A response icon1