Databaselast 24 hours
How to Automate Migration from Standalone MySQL to Galera Cluster using Ansible
Database migrations don’t scale well. Typically you need to perform a great deal of tests before you can pull the trigger and switch from old to new. Migrations are usually done manually, as most of the process does not lend itself to automation. But that doesn’t mean there is no room for automation in the migration process. Imagine setting up a number of nodes with new software, provisioning them with data and configuring replication between old..
No Ping Will Tear Us Apart – Enabling member auto-rejoin in Group Replication
With the release of version 8.0.16 of MySQL, we’ve added some features to the Group Replication (GR) plugin, in order to enhance its high-availability capacities. One of these features was the ability to enable a member that has left the group, under certain circumstances, to automatically rejoin it, without need of intervention by the user.…
Re-evaluating MySQL 8 Query Transformations Capabilities
I recently stumbled upon a very interesting post by Lukas Eder, where he describes 10 query transformations which do not depend on the database’s cost model. He posted it a couple of years ago, though when I read it, I assumed some portions of it may still be relevant today. In the original post, several databases were tested to see if their internal optimizer will be able to automatically re-write the SQL queries and optimize them. In those test..
DatabaseNews
Database Journal:
How to Eliminate Gaps in IdentityHow to Eliminate Gaps in Identity Values in SQL Server by Disabling the Identity Cache
How to Reseed Your Identity ColumnHow to Reseed Your Identity Column Value in SQL Server
Introduction to the Cosmos DB EmulatorIntroduction to the Cosmos DB Emulator
The Horror of NOLOGGING in OracleThe Horror of NOLOGGING in Oracle
MySQL 8 Security TipsMySQL 8 Security Tips
Importing Data into Azure SQL DatabaseImporting Data into Azure SQL Database
IBM Improves IT Operations with ArtificialIBM Improves IT Operations with Artificial Intelligence
Single-column Primary Keys and HistogramsSingle-column Primary Keys and Histograms in Oracle
Microsoft SQL Server: Current IdentityMicrosoft SQL Server: Current Identity Column Value in a Table
Compressed Microsoft SQL Server BackupsCompressed Microsoft SQL Server Backups by Default
Planet MySQL:
How to Automate Migration from Standalone24hHow to Automate Migration from Standalone MySQL to Galera Cluster using Ansible
No Ping Will Tear Us Apart – Enabling24hNo Ping Will Tear Us Apart – Enabling member auto-rejoin in Group Replication
Re-evaluating MySQL 8 Query Transformations24hRe-evaluating MySQL 8 Query Transformations Capabilities
Understanding Cross-Site ReplicationUnderstanding Cross-Site Replication in a Tungsten Composite Multi-Master Cluster for MySQL, MariaDB and Percona Server
How to fetch single row from databaseHow to fetch single row from database in php codeigniter
Flashback Recovery in MariaDB/MySQLFlashback Recovery in MariaDB/MySQL Servers
Performance Tuning Tungsten ReplicationPerformance Tuning Tungsten Replication to MySQL
Exposing MyRocks Internals Via SystemExposing MyRocks Internals Via System Variables: Part 5, Data Reads
S.O.L.I.D the First 5 PrinciplesS.O.L.I.D the First 5 Principles of Object Oriented Design with JavaScript
SQL Group By Example | Group By ClauseSQL Group By Example | Group By Clause In SQL Tutorial