April 20, 2023
6分で読めますJust like real life, the world of computer science is replete with trade-offs. Relational databases are no exception. When interacting with relational databases, we face the dilemma between data...
January 29, 20154分で読めますWhen I was researching about Unicode's "surrogate pairs" in a separate matter, an article about the "surrogate key" and "compound primary key" in the database was caught in the **surrogate** connection and I derailed as much as I could (laughs)...
April 23, 2013**Introduction Settings of MHA (MasterHigh AvailabilityManager)** Versions used: mha4mysql-manager-0.53-0, MySQL-5.5 (1) Explanation of simple advantages and other benefits MHA is a product that uses the latest slave as the master in the event of a master failure in mysql to compensate for the differences of other slaves and change the direction of the master. ...
March 25, 20131分で読めますIf you want to access the WordPress DB from a script, you can simply access MySQL and handle it, but if you want to use a WordPress function for some reason (e.g. scripting an image), you can use ''' require_once('wp-blog-header.php'); ```...
December 25, 20122分で読めますBefore、...
November 7, 20122分で読めますWhen building a commercial website with WordPress, it is common to separate the web application server from the database server and duplex the database side. It is simply to improve the performance of the service by distributing the load on database access, and in the sense that the main database can be recovered from the database of the mirrored secondary node in the event of a failure, it is the worst case for the service...
