How can you create indexes on replica database only

Hussain Fakhruddin 21 Reputation points

I want to create a replica of Azure MariaDB but with the ability to create indexes on it to improve search performance.

How can I do that?

Azure Database for MariaDB
{count} votes

Accepted answer
  1. Anurag Sharma 17,386 Reputation points

    Hi @Hussain Fakhruddin , thanks for providing more details.

    Databases on Read replicas of Azure Database for MariaDB servers are created with read only option and they don't allow us to run any kind of ddl or insert/update/delete on them, even index creation is not allowed.

    However, when we create the read replicas the indexes present on the primary server are synced with the read replicas. So if we want to create any new indexes, we first need to create them on the primary server which in turn will be synced to read-replicas.

    Read replicas in Azure Database for MariaDB

    Please let us know if this helps or else we can discuss further.


    If answer is helpful please click on 191194-image.png as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions. Thank you for helping to improve Microsoft Q&A!

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful