What are top 3 scenarios for MariaDB hybrid synchronization?Thanks
Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.
Hi @MorrisQibou-3145, welcome to Microsoft Q&A forum.
As I understand you would like to know the basic scenario when to use Hybrid Synchronization in Azure MariaDB.
As the definition of it mentions "With Data-in Replication, you can keep data synchronized between your on-premises servers and Azure Database for MariaDB. This synchronization is useful for creating hybrid applications. This method is appealing when you have an existing local database server, but want to move the data to a region closer to end users."
So if we have user base located across globe and we would want to reduce the db connection latency based on user's locations then we can opt for it. Again we cannot eliminate the on-premises server as thats the backbone and primary server through which other servers will get synced.
Another scenario could be reporting requirements where we want to maintain the reporting data in azure but our application is still using the on-premise database. In this case we can point all our reporting applications to use the azure maria db and it will be synced with on-premise like mentioned before.
In a nutshell, we would opt to use this feature when we want to make our data available based on closest location to end users.
Choose the right MariaDB Server option in Azure
When to use Data-in Replication
3 people are following this question.
MariaDB 10.3 Query Performance Insights and Recommendations
mysql on version 5.7 but hecking the server status states Server version is 18.104.22.168
Changing time zone setting in Azure Database for Maria DB
Common Data Model
Replicate production Maria DB server to Maria DB Azure PaaS