Ciugk

Clash Royale CLAN TAG #URR8PPP Performance impact of using NetworkTopology with 3 node cassandra cluster in One Datacenter We are using 3 node Cassandra cluster in one data center. For our keyspaces as suggested in best practices we are using NetworkTopology for replication strategy using the GossipingPropertyFileSnitch. For Read/Write consistency we are using as QUORUM. In majority of cases when users use NetworkTopology as replication strategy they might have multiple DataCenters configured. In our case we have only one DataCenter, A) With that using the NetworkTopology as replication strategy will it cause any performance impact ? B) As we are using QUORUM as Read/Write consistency which is considering multiple DataCenters, does QUORUM consistency have any performance impact ? is it OK to continue using QUORUM consistency considering future expansions of data centers ? Please suggest. By clicking "Post Your A...

Clash Royale CLAN TAG #URR8PPP Is MySQL optimize table request safe to use during write operations and in replication enviorement? I have MySQL DB with up to 300 InnoDB tables with similar structure each has about 700k rows and size around 160M in normal case. This tables are independent of each other and has no foreign keys. This tables are intensively used for RW operations the table usage pattern looks like this: After a few month the DB performance has dropped significantly. After investigation the problem was found: the table files has grown large and occupied about 300M of disk space each. After running manual table optimization the problem was solved but in a few weeks the DB performance started to degrade again. As a solution to keep DB healthy the OPTIMIZE TABLE request was added after each data removal. The questions are: By clicking "Post Your Answer", you acknowledge that you have read our updated...