In a previous post, I explained the architecture and design for the transactional data dictionary in MySQL 8.0. In this post I intend to summarize the status of this work in the 8.0.0 Milestone Release.
Storing all dictionary information in InnoDB tables
The MySQL 8.0.0 now stores dictionary data in InnoDB tables. …
This post introduces PyMyTools v0.1: my first version of a simple
diagnostic toolkit for automating boring DBA tasks. Read on for
tool descriptions and demonstrations!
Introduction No lengthy introductions this time:
Tools: general description The tools are designed to automate some of the simple DBA tasks:
In this blog post, we will discuss how we can verify if an application transaction executed on the master has been applied to the slaves.
In summary, is a good practice to alleviate the load on the master by doing reads on slaves. It is acceptable in most of the cases to just connect on slaves and issue selects. But there are some cases we need to ensure that the data we just applied on our master has been applied on the slaves before we query it.
One way to do this is using a built-in function called MASTER_POS_WAIT. This function receives a binary log name and position. It will block the query until the slave applies transactions up to that point, or timeout. Here is one example of how to use it:
-- insert our data on master
master [localhost] {msandbox} (test) > INSERT INTO test VALUES …[Read more]
Since MySQL now can be used on Oracle Cloud, you will be able to experience a more secure, cost-effective and enterprise-level database applications using MySQL.
The post Oracle MySQL Cloud Service appeared first on Datavail.
In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change.
One of the most annoying situations in the life of a DBA is realizing that the disk where the datadir resides is running out of space. If you’re lucky enough to run over an LVM volume or a RAID (depending on the level, though), it is easy to add disk space. But what if you are not that lucky, and your datadir is running on a single disk? Not so funny!
That is the exact situation we recently faced with a customer, for both the master and slave server. When trying to figure out a solution we saw that:
This release fixes a rare crash as well as a regression bug introduced in 12.3.0.
Changes as compared to SQLyog MySQL GUI 12.3.0 include:
Bug Fixes:
* 12.3.0 introduced a slowness when displaying the saved
connections list with a large no. (100+) of saved connections.
This is fixed now.
* Fixed a rare crash occurring sometimes when typing in the
editor inside an invalid query longer than 128 characters.
Auto-complete was at fault.
Downloads: https://www.webyog.com/product/downloads
Purchase: https://www.webyog.com/shop
The post SQLyog MySQL GUI 12.3.1 Released …
[Read more]In this post, I’ll discuss how to moving VIPs during a failover using Orchestrator.
In our previous post, we showed you how Orchestrator works. In this post, I am going to give you a proof-of-concept on how Orchestrator can move VIPs in case of failover. For this post, I’m assuming the Orchestrator is already installed and able to manage the topology.
Hooks
Orchestrator is a topology manager. Nothing less nothing more. In the case of failover, it will reorganize the topology, promote a new master and connect the slaves to it. But it won’t do any DNS changes, and it won’t move VIPs (or anything else).
However, Orchestrator supports hooks. Hooks are external scripts …
[Read more]In MySQL 8.0, we are making large changes to the way the MySQL server stores meta data with the introduction of our native data dictionary. As part of these improvements, we have also made changes to the way the server bootstraps.…
This blog post is all about new MySQL 5.7 physical, logical architecture and it’s components.In this blog post, I will try to explain things in flow including data processing and SQL execution in MySQL with the help of diagrams.
Unlike the other databases, MySQL is a very flexible and
offers different kinds of storage engines as a plugin
for different kinds of needs. Because of this,
MySQL architecture and behavior will also change as per the
use of storage engines, for example transactional [InnoDB]
and non-transactional [MyISAM] engines data storage and
SQL execution methods will be different and within the
server it will use engine specific components like memory and
buffers depending on type storage engine will get used for the
SQL operation.
Will discuss more InnoDB, since it’s default and main storage
engine for MySQL.
MySQL Physical Architecture: Configuration files: …
[Read more]It’s been a busy month for file vulnerabilities. Thanks to Dawid Golunski at legalhackers.com for giving us all the opportunity to tighten security in our MySQL, MariaDB, and Percona Server instances.
Details were released for the CVE 6663 mentioned last week and for a new CVE 6664:
http://legalhackers.com/advisories/MySQL-Maria-Percona-PrivEscRace-CVE-2016-6663-5616-Exploit.html
http://legalhackers.com/advisories/MySQL-Maria-Percona-RootPrivEsc-CVE-2016-6664-5617-Exploit.html
Note that 6664 is dependent on 6663, and 6663 can be mitigated by turning off symbolic_links (=0). Upgrade to the latest versions also fixes the problem. Regardless, the attacker …
[Read more]
