Tag: MySQL

Feed: Recent Announcements. Previously, gathering performance data on a database required configuration and maintenance of monitoring applications and related resources. Correlating performance data took hours without specialized expertise. To find a query of interest, such as a stuck or long-running SQL query, meant investigating each query one at a time. RDS Performance Insights allows non-experts and experts to identify top SQL loads and from where they originated on a visual dashboard in seconds. Now, RDS Performance Insights supports segmenting the performance data by database name. You can determine if a specific database is generating unusual high load, or is executing ... Read More

Feed: Planet MySQL; Author: EverSQL; So you thought your database is in good shape, but suddenly your CPU usage spiked and reached 100% at 2AM. How would you go about tracking the root cause and fix it? 1. Locate the root cause If you are using CloudWatch or any infrastructure monitoring solution, you can start your investigation there.To understand what happened in your database, you should enable the slow query log feature on your database. This will capture all the slow log queries into a log, based on a threshold that you define.If you are not sure how to enable ... Read More

Feed: Planet MySQL; Author: Vitess; IntroductionIn this blog, I would like to explore Vitess Operator for Kubernetes. This post demonstrates the sample implementation of Vitess in Kubernetes topology. I also explore common DBA tasks by demonstrating how they are handled in the Vitess ecosystem. Vitess, out of the box, comes with a lot of tools and utilities that one has to either incorporate or develop to manage MySQL topology. Let’s take a look at the capabilities of Vitess in these areas and demonstrate how they are performed under the operator realm.PrerequisitesGKE AccountKubectlMySQL ClientInstall vtctlclient locallygo get vitess.io/vitess/go/cmd/vtctlclientDownload the Operator example ... Read More

Feed: Planet MySQL; Author: Vitess; Previously posted on link at Nov 3, 2020.Traditionally, MySQL has been used to power most of the backend services at Bolt. We’ve designed our schemas in a way that they’re sharded into different MySQL clusters. Each MySQL cluster contains a subset of data and consists of one primary and multiple replication nodes.Once data is persisted to the database, we use the Debezium MySQL Connector to capture data change events and send them to Kafka. This gives us an easy and reliable way to communicate changes between back-end microservices.Vitess at BoltBolt has grown considerably over the ... Read More

Feed: AWS Big Data Blog. Many organizations have an Apache Hive metastore that stores the schemas for their data lake. You can use Amazon Athena due to its serverless nature; Athena makes it easy for anyone with SQL skills to quickly analyze large-scale datasets. You may also want to reliably query the rich datasets in the lake, with their schemas hosted in an external Hive metastore. In response to customers’ requests, AWS announced Athena’s support for Hive metastore in early 2020. This extends the ability in Athena to query external data stores, with a combined benefit of better performance and ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Kubernetes operators are meant to simplify the deployment and management of applications. Our Percona Kubernetes Operator for Percona XtraDB Cluster serves the purpose, but also provides users the flexibility to fine-tune their MySQL and proxy services configuration.The document Changing MySQL Options describes how to provide custom my.cnf configuration to the operator. But what would happen if you made a mistake and specified the wrong parameter in the configuration?Apply ConfigurationI already deployed my Percona XtraDB Cluster and deliberately submitted the wrong my.cnf  configuration in cr.yaml : spec: ...   pxc:     configuration: |       [mysqld]       wrong_param=123 …    configuration: |      [mysqld]      wrong_param=123Apply ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Overview MindsDB is a third-party application that interfaces with MariaDB Server to provide Machine Learning capabilities through SQL. The interface is done via the Connect Storage Engine. Installation To get a functional MariaDB - MindsDB installation, one needs to install the following components: MindsDB connects to MariaDB Server via a regular user to setup a dedicated database called mindsdb. Which user will be used is specified within MindsDB's configuration file. For example, if MindsDB is installed locally, one can create a user called mindsdb@localhost. MindsDB only authenticates via the mysql_native_password plugin, hence ... Read More

Feed: Planet MySQL; Author: Continuent; Having concluded the ninth webinar in the series last week, we’re excited to share that the Continuent Tungsten MySQL Use Case Webinar Series for 2020 with Eero Teerikorpi, Founder & CEO of Continuent, is now available to watch in its entirety on demand. With this series that started last August and wrapped up this month, over the course of 9 webinars and 9 Tungsten Clustering customer use cases, Eero took us on a journey of how we’ve helped our customers make the most of their MySQL databases and their HA/DR and Geo-scaling needs. From MySQL ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; All together now Let’s now put together all that we’ve learned in InnoDB Data Locking – Part 2 “Locks” about table and record locks to understand following situation: mysql> BEGIN; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM t FOR SHARE; +----+ | id | +----+ | 5 | | 10 | | 42 | +----+ 3 rows in set (0.00 sec) mysql> DELETE FROM t WHERE id=10; Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t VALUES (4); ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; Oracle Live. On Wednesday, December 2, the world’s most popular open source database takes a leap forward in the cloud. Edward Screven, Oracle’s chief corporate architect, will share MySQL innovation that enables you to reduce cost and complexity while accelerating business insights.  We have really exciting news for MySQL users, including some amazing testimonials from early adopters who will share their experiences. And, yes of course, there will be benchmarks! Join us on this very special day in the history of MySQL. Watch the live event, and following the announcement, join us for a ... Read More