Re: SHOW GLOBAL STATUS
Posted by: Rick James
Date: June 30, 2015 05:01PM

Those were physical servers -- essentially nothing on a machine except MySQL server. For large systems, that is the only way to go. For small ones, multiple virtual servers should be more cost effective.

Only a few years ago, Virtual machines chewed up something like 30% of the horsepower. Today it is closer to zero. So, even for a 'dedicated' server, "virtual" is more attractive, at least for consistency.

Note: Master-Slave was a requirement for BCP, plus a benefit for read scaling.

Galera gives you some write scaling.
After that, you have to go with sharding.

The problem with write scaling is that every replica (traditional 'Slave' or Galera 'node') has to perform every write.

Feel free to start another discussion (in, say, the Performance forum) to go into more details about scaling options. Please provide more details about your application; there are often different techniques for diff apps, especially in Data Warehousing. See http://mysql.rjweb.org/doc.php/datawarehouse and a couple of companion blogs on Summary Tables and High Speed Ingestion.

Options: ReplyQuote


Subject
Written By
Posted
June 24, 2015 04:10AM
June 25, 2015 11:50PM
June 29, 2015 04:06AM
Re: SHOW GLOBAL STATUS
June 30, 2015 05:01PM
July 02, 2015 01:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.