The MySQL Replication was my first project as a Database
Administrator (DBA) and I have been working with Replication
technologies for last few years and I am indebted to contribute
my little part for development of this technology. MySQL supports
different replication topologies, having better understanding of
basic concepts will help you in building and managing various and
complex topologies. I am writing here, some of the key points to
taken care when you are building MySQL replication. I consider
this post as a starting point for building a high performance and
consistent MySQL servers. Let me start with below key
points Hardware. MySQL Server Version MySQL Server Configuration
Primary Key Storage Engine I will update this post with relevant
points, whenever I get time. I am trying to provide generic
concepts and it will be applicable to all version of MySQL,
however, some of the concepts are new and applicable to latest
versions …
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
As a Database Administrator(DBA), your job want you to know the
most atomic details of databases in your server. It happens for
me many times, my boss/ delivery manager asking me, what is the
size of a specific database or specific table, in this kind of
situation, producing the right data will help make right
decision. From my experience, I understood, it is always better
to say, I will give you data in few minutes, instead of producing
the incorrect data, which I had been doing for a long time.
This post is about identifying the size of a database(s) or
table(s). The simple script, I have been using it for quite
a long, if not wrong when I started my career as DBA. You could
have probably seen this/similar script on other forums as well
and there are many other methods too. I am reproducing this handy
script here to get work done.
Size of a specific table: …