(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.
Tag: Open Source
Prepare MySQL for a Safe Shutdown
(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.
MySQL Compressed Binary Logs
(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.
Database change tracking using MySQL EE Audit
(Ted Wennmark) Use MySQL Enterprise Audut plugin to track data changes on specific tables.
Setting up an InnoDB Cluster With a Few Lines of Code
(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.
MySQL Security – Password Verification-Required Policy
(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.
Testing Percona XtraDB Cluster 8.0 with DBdeployer
(Alkin Tezuysal and Ramesh Sivaraman) In the light of support for Percona XtraDB Cluster (PXC), the DBdeployer anniversary, and the newly released Percona XtraDB Cluster 8.0, I’m happy to announce that Giuseppe Maxia has recently updated DBdeployer to support Percona XtraDB Cluster 8.0.
GeoSpatial data handling made easy with MySQL 8.0
(pon suresh pandian) Human geography examines the dynamics of cultures, societies and economies, and physical geography examines the dynamics of physical landscapes and the environment.
MySQL Linux to Windows
(Michael McLaughlin) My students want to transfer their course setup MySQL files from the Linux VM that I provide to Microsoft Windows 10. This post explains how because I found a couple small errors in the Google’d posts they would most likely see.
MySQL NDB Cluster 8.0.20 new features
This post is about changes in the implementation of NDB Cluster from MySQL NDB Cluster 8.0 through 8.0.20, as compared to earlier release series.