Author: MySQL Planet

Feed: Planet MySQL; Author: Marco Tusa; If you have a business no matter how small, you are collecting data, and you need to have your data accessible to make informed decisions about how to make your business better. The more successful you become the more data you are producing and the more you become dependent by it. This is when you start to realize your must have your data in a safe place like a database instead some spreadsheet.But to put your data in a database is not enough, you must be sure the database will be robust, resilient, and ... Read More

Feed: Planet MySQL; Author: Dave Stokes;  Data Con LA starts October 23rd and I will be speaking on Sunday and I will be speaking on Sunday the 25th on MySQL's NoSQL JSON Store in a talk titled MySQL Without the SQL -- Oh My!The talk is pre-recorded but I will be live for the question and answer segment. So this is your chance to ask me your question.Dave's MySQL Basics is a new video based series I am starting to teach the basics of MySQL.  I have been talking with book publishers, hiring managers, DBAs of all levels, and many others.  ... Read More

Feed: Planet MySQL; Author: Continuent; Cloud-Based Active/Active Tungsten MySQL Clusters @ Samsung The replay of our webinar ‘AWS Aurora MySQL Replacement - Break Away From Geo-Limitations of AWS Aurora With Multi-Region Cloud Databases’ is now available on-demand. Watch as Continuent CEO Eero Teerikorpi walks us through how our team went about helping Samsung implement their geo-distributed MySQL back-end for IoT services. This webinar looks at why and how we replaced an AWS RDS/MySQL solution with a Tungsten Cluster composite active/active MySQL solution to offer a geo-distributed MySQL back-end for IoT services at Samsung. Samsung is a global SaaS provider with ... Read More

Feed: Planet MySQL; Author: Marcelo Altmann; Earlier this week, Oracle released their Q4 releases series. As on the previous releases, backward compatibility has been broken with previous versions of the server. This time on both MySQL 5.7 and 8.0:MySQL 5.7.32While our QA team was performing an extensive test on it,  we found out this version introduced a new compression format version. This change breaks backward compatibility with older versions of MySQL, which is expected on the 8.0 series but is not on 5.7. As Percona XtraBackup (PXB) is based on MySQL code, it makes MySQL 5.7.32 incompatible with current versions ... Read More

Feed: Planet MySQL; Author: Codership; We have video recording available for you to learn how you can benefit the New Galera Manager. It includes live demo how to install Galera Manager and deploy easily Galera Cluster on Amazon Web Service for Geo-distributed Multi-master MySQL, Disaster Recovery and fast local reads and writes. Now you can monitor and manage your Galera Cluster with Graphical Interface. “The presentation was great with lots of valuable information. We will definitely try to implement Galera Manager in our environment very soon” stated attendee of the webinar. Watch Galera Manager webinar recording Download Galera Manager ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; One of the most exciting storage-related features in Kubernetes is Volume snapshot and clone. It allows you to take a snapshot of data volume and later to clone into a new volume, which opens a variety of possibilities like instant backups or testing upgrades. This feature also brings Kubernetes deployments close to cloud providers, which allow you to get volume snapshots with one click.Word of caution: for the database, it still might be required to apply fsfreeze and FLUSH TABLES WITH READ LOCK or LOCK BINLOG FOR BACKUP.It is much easier in MySQL ... Read More

Feed: Planet MySQL; Author: PlanetScale; For developers building out a web application, a transactional datastore is the obvious and proven choice, but with success comes scale limitations. A monolithic database works well initially, but as an application sees growth, the size of its data will eventually grow beyond what is optimal for a single server. If the application can live with eventually consistent data, scaling read traffic can be solved with relative ease by adding more replicas. However, scaling write traffic is more challenging; for example at a certain point even the largest MySQL database will see performance issues. This is ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Google Cloud Platform (GCP), with its CloudSQL offering, has become a leading platform for database-as-a-service workload deployments for many organizations. Scale and High Availability have surfaced as primary goals for many of these deployments. Unfortunately, the attainment of these objectives has been challenging.Often, the answer has been to simply add more CloudSQL databases. Many, however, have found a better solution in Percona’s fully managed MySQL environment based in Google’s GCE. Percona’s fully managed MySQL offering provides benefits similar to CloudSQL, plus the ability to run MySQL with an unlimited number of tables and ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; Yes, your read the title correctly: an unprivileged user can crash your MySQL Server.  This applies for the default configuration of MySQL 8.0.21 (and it is probably the case for all MySQL 8 GA versions).  Depending on your configuration, it might also be the case for MySQL 5.7.  This needs malicious intent and a lot of determination, so no need to panic as this will not happen by accident.  I am not sharing the exploit in this post (I might do it later), but I am telling you how to avoid the problem.The vulnerability ... Read More

Feed: Planet MySQL; Author: Codership; Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.6, 5.7 and 8.0, consisting of MySQL-wsrep 5.6.49 (release notes, download), 5.7.31 (release notes, download), and 8.0.21 (release notes, download) with Galera Replication library 3.31 (release notes, download) implementing wsrep API version 25 for 5.6 and 5.7, and Galera Replication library 4.6 (release notes, download) implementing wsrep API version 26 for 8.0. This release incorporates all changes to MySQL 5.6.49, 5.7.31 , and 8.0.21 respectively, adding a synchronous option for your MySQL High Availability solutions. It is ... Read More