(domas mituzas) Generally in MySQL we send queries massaged to a point where optimizer doesn’t have to think about anything. In our major user database environment 99.9% of queries don’t have alternative query plans available (either because of forced indexes or just straightforward Primary Key read
Tag: Open Source
MySQL replication monitoring 101
(Giuseppe Maxia) Replication is the process that transfers data from an active master to a slave server, which reproduces the data stream to achieve, as best as possible, a faithful copy of the data in the master.
MySQL replication monitoring 101
(Giuseppe Maxia) Replication is the process that transfers data from an active master to a slave server, which reproduces the data stream to achieve, as best as possible, a faithful copy of the data in the master.
Why base64-output=DECODE-ROWS does not print row events in MySQL binary logs
(Sveta Smirnova) Lately I saw many cases when users specified option –base64-output=DECODE-ROWS to print out a statement representation of row events in MySQL binary logs just to get nothing. Reason for this is obvious: option –base64-output=DECODE-ROWS does not convert row events into its strin
Why base64-output=DECODE-ROWS does not print row events in MySQL binary logs
(Sveta Smirnova) Lately I saw many cases when users specified option –base64-output=DECODE-ROWS to print out a statement representation of row events in MySQL binary logs just to get nothing. Reason for this is obvious: option –base64-output=DECODE-ROWS does not convert row events into its strin
Ansible and Loading MySQL Databases Part II
(Dave Stokes) Loading databases on virtual systems is not as straight forward as it should be. Last time the foundation for using Ansible was set down on our quest to be able to have fully functional database servers on virtual servers automatically.
Ansible and Loading MySQL Databases Part II
(Dave Stokes) Loading databases on virtual systems is not as straight forward as it should be. Last time the foundation for using Ansible was set down on our quest to be able to have fully functional database servers on virtual servers automatically.
New Optimizer Hints in MySQL
(Sergey Glukho) A few key points regarding the new hints:
New Optimizer Hints in MySQL
(Sergey Glukho) A few key points regarding the new hints:
Pseudo GTID, ASCENDING
(Shlomi Noach) Pseudo GTID is a technique where we inject Globally Unique entries into MySQL, gaining GTID abilities without using GTID. It is supported by orchestrator and described in more detail here, here and here.