Sharding Pinterest: How we scaled our MySQL fleet

https://medium.com/@Pinterest_Engineering/sharding-pinterest-how-we-scaled-our-mysql-fleet-3f341e96ca6f


Comments

Post a Comment

Popular posts from this blog

c++ problems and solutions related to oops

1-> How to publicly inherit from a base class but make some of public methods from the base class private in the derived class? ans- 1) You can use public inheritance and then make bar private: class Base { public : void foo (){} void bar (){} }; class Derived : public Base { private : using Base :: bar ; }; 2) You can use private inheritance and then make foo public: class Base { public : void foo (){} void bar (){} }; class Derived : private Base { public : using Base :: foo ; }; Note: If you have a pointer or reference of type Base which contains an object of type Derived then the user will still be able to call the member.
Read more

What are Master and Slave databases and how does pairing them make web apps faster?

What are Master and Slave databases and how does pairing them make web apps faster? A database is "slaved" to a "master" when it receives a stream of updates from the master in near real-time, functioning as a copy. The "slave" must simply apply the changes that the master validated and approved. In principle, one could create a master-slave setup by transferring files really fast from one server to the other; but in practice, each database has its own specialized replication protocol. There are many reasons a replica makes queries return faster. One is that the master's CPU is less burdened by queries while the replica's CPU is less burdened by writes; so there is more CPU available to do work. Another is that data, while nominally stored to disk, is cached in RAM when that is possible; and indeed the OS does this whether the database asks for it or not and can be unpredictable about it. On the master, recently written portions of the database ...
Read more