Author: MySQL Planet

Feed: Planet MySQL; Author: MariaDB; When we are talking about a database auditing concept, what we are focused on is tracking the use of database records, and the monitoring of each operation on the data. The auditing activities goal is to provide a clear and reliable answer to the typical 4 W questions: Who accessed the database, When did this happen, What was touched, Where this access came from. Auditing should also help the security team answer the 5th W: Why this happened? Auditing is also a very important task when we want to monitor the database activity to collect ... Read More

Feed: Planet MySQL; Author: The Pythian Group; In recent weeks I’ve been focusing on Docker in order to get a much better understanding of the containerized world that is materializing in front of us. Containers aren’t just for stateless applications anymore and we’re seeing more cases where MySQL and other databases are being launched in a containerized fashion, so it’s important to know how to configure your MySQL container! In docker hub, you will see an option for this by doing a volume mount from the docker host to the container on /etc/mysql/conf.d. But the problem is that the container ... Read More

Feed: Planet MySQL; Author: Dave Stokes; There was an interesting question on Stackoverflow.com on extracting values from a JSON data type column in a MySQL database.  What caught my eye was the the keys for the key/value pairs were numeric. In particular the author of the question only wanted values for the key named 74.  The sample data was fairly simple.{ "70" : "Apple", "71" : "Peach", "74" : "Kiwi" }I thought SELECT JSON_EXTRACT(column, '$.74') FROM table; should work but it did not. There was a complaint about an invalid path expression.It turns out that you need to make the ... Read More

Feed: Planet MySQL; Author: VividCortex; If you’re someone who keeps up with the Go development cycle, then you’ll know that a couple of weeks ago Go entered its feature-freeze for the Go 1.11 release. One of the changes for this upcoming release that caught my eye was to the database/sql package. Daniel Theophanes contributed a change that introduces several new counters available via the DB.Stats() method ... Read More

Feed: Planet MySQL; Author: Shlomi Noach; May 22, 2018 This is the sixth in a series of posts reviewing methods for MySQL master discovery: the means by which an application connects to the master of a replication tree. Moreover, the means by which, upon master failover, it identifies and connects to the newly promoted master. These posts are not concerned with the manner by which the replication failure detection and recovery take place. I will share orchestrator specific configuration/advice, and point out where cross DC orchestrator/raft setup plays part in discovery itself, but for the most part any recovery tool ... Read More

Feed: Planet MySQL; Author: Sveta Smirnova; Sveta Smirnova | May 21, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Technical Webinars PREVIOUS POST Please join Percona’s Principal Support Escalation Specialist, Sveta Smirnova, as she presents Troubleshooting MySQL Concurrency Issues with Load Testing Tools on Wednesday, May 23, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Normally, we use benchmarking tools when we are developing applications. When applications are deployed, benchmarks tests are usually too late to help. This webinar doesn’t cover actual benchmarks, but it does look at how you can use benchmarking tools for troubleshooting. When you need ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Peter Zaitsev | May 21, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona Monitoring and Management PREVIOUS POST In this blog post, I will show you how to use Percona Monitoring and Management (PMM) to capture per-process metrics in five minutes or less. While Percona Monitoring and Management (PMM) captures a lot of host metrics, it currently falls short providing per-process information, such as which particular process uses a lot of CPU resources, causes Disk IO or consumes a lot of memory. In our database performance optimization and troubleshooting practice, this information ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; In a world increasingly defined by instant-gratification, the demand for positive and direct shopping experiences has risen exponentially. Today’s always-on customers are drawn to the most convenient products and services available. As a result, we are witnessing higher customer switching rates, with consumers focusing more on convenience than on branding, reputation, or even on price.   In this switching economy – where information and services are always just a click away –  we tend to reach for what suits our needs in the shortest amount of time. This shift in decision making has made it harder than ever for businesses to build loyalty among their customers and to guarantee repeat purchases. According to recent research, only 1 in 5 consumers now consider it ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; 【東京】MySQL 8.0 新機能紹介セミナー オプティマイザー＆パフォーマンス 2018年6月1日　1:30 PM - 4:00 PM　@日本オラクル 本社（東京・外苑前） このイベントでは、MySQL 8.0の新機能の中から、オプティマイザーとパフォーマンス/スケーラビリティ改善に関係するトピックをご紹介させて頂きます。 このイベントに参加する利点 ・MySQL 8.0のオプティマイザーの改善点/新機能について知る ・MySQL 8.0のパフォーマンスやスケーラビリティの改善点/新機能について知る 【大阪】Oracle Journey to Cloud セミナー ～クラウド時代における最高のデータベース基盤構築の秘訣～ 2018年6月27日　2:00 PM - 4:30 PM ＠日本オラクル関西オフィス（大阪） 2017年秋に発表された、世界初の自律型データベース・クラウドの構想をはじめ最新版Oracle Databaseの最新情報とクラウド時代におけるデータベース基盤の最適化についてご紹介します。 さらにその最新データベース基盤を支えるためのプラットフォーム選択のポイントや導入事例をご紹介いたします。 ... Read More

Feed: Planet MySQL; Author: MC Brown; Nicolas Tobias has written an awesome guide to setting up replication from MariaDB to Hadoop/HDFS using Tungsten Replicator, in Spanish! He’s planning more of these so if you like what you see, please let him know! Semana santa y yo con nuevas batallas que contar.Me hayaba yo en el trabajo, pensando en que iba a invertir la calma que acompa;a a los dias de vacaciones que libremente podemos elegir trabajar y pense: No seria bueno terminar esa sincronizacion entre los servidores de mariaDB y HIVE? Ya habia buscado algo de info al respecto en ... Read More