(David Ducos) pt-online-schema-change emulates the way that MySQL alters tables internally, but it works on a copy of the table you wish to alter. It executes INSERT statements to import the data, that runs in a single connection to fill the new table.
Tag: Open Source
(Olivier Dasini) When thinking about security within a MySQL installation, you can consider a wide range of possible procedures / best practices and how they affect the security of your MySQL server and related applications.
(Ted Wennmark) For more information on how to create a service look at man systemd.service
(Shahryar Ghazi) MySQL has been making huge progress on the JSON/NoSQL front as well ie. supporting many of the JSON access and manipulation features and operations.
(Stephen Thorn) As a Solutions Engineer at Percona, one of my responsibilities is to support our customers as they investigate new and emerging technologies. This affords me the opportunity to speak to many current and new customers who partner with Percona.
(Dave Stokes) The MySQL Document Store is an quick and easy to use NoSQL JSON Document Database that was designed to be easy to use. But there is one thing that may not be obvious if you are working to modify multiple documents.
(Jake Davis) In Percona’s Managed Services, we start up and shut down MySQL servers all the time. Over the years, we’ve seen various issues occur due to the way servers are shut down.
(Jesper Krogh) On a busy server, the binary logs can end up being one of the largest contributors to amount of disk space used. That means higher I/O, larger backups (you are backing up your binary logs, right?), potentially more network traffic when replicas fetch the logs, and so on.
(Ted Wennmark) Use MySQL Enterprise Audut plugin to track data changes on specific tables.
(Jericho Rivera) In this day and age, large enterprise companies make use of Ansible, Puppet, or Chef to provision MySQL servers, be it replica sets or clusters. This eases the burden of deployment and workflow management.