In MySQL 8.0.1, in addition to new as_cs collations (accent sensitive, case sensitive) for utf8mb4, we have also added a new collation for Japanese.
Introducing utf8mb4_ja_0900_as_cs
Collating rules for for Japanese are complex. Japanese has multiple writing systems with katakana, hiragana, kanji, romaji.…
In a previous post I wrote about how read/write split is implemented in ProxySQL, and what I believe is the best practice for read/write split on top of MySQL servers:
I believe I am remarking that in ProxySQL read/write split is a
special case of query routing.
ProxySQL doesn't try to magically perform read/write split for
every use case scenarios, but instead it gives you the tools and
the power to route traffic dynamically, on demand, through a
simple and powerful Admin interface.
It is a tool for DBAs that need to maintain a farm of MySQL
servers, and guarantee uptime, high availability, and
performance.
In this blog post I will present a use case on how …
[Read more]In a week, me and some Booking.com colleagues will be in Santa Clara for Percona Live.
Booking.com is sponsoring the conference and we will be present at the Monday Evening Reception. You do not need a tutorial pass to attend the dinner (even if it is on the tutorial day): any valid pass will do. If you do not have your ticket yet, it is time to register (you can use the discount code “
While me and Fred were presenting Inexpensive Datamasking for MySQL with
ProxySQL at FOSDEM 2017, we got a very interesting question:
can ProxySQL be used to obfuscate backups obtained from
mysqldump?
The short answer is yes!
Instead of dumping directly from MySQL Server, you can point
mysqldump to ProxySQL that will perform the
datamasking/obfuscation.
The dump file can then be used to provision new staging database
without using production data, and follow compliance
requirements.
This extremely simplify the "common" approach of dumping original
data and storing it in an not obfuscated format (not good for
compliance I believe), load the original data into a database,
and finally perform some obfuscating query (that can really take
a lot of time).
For this …
[Read more]
While me and Fred were presenting Inexpensive Datamasking for MySQL with
ProxySQL at FOSDEM 2017, we got a very interesting question:
can ProxySQL be used to obfuscate backups obtained from
mysqldump?
The short answer is yes!
Instead of dumping directly from MySQL Server, you can point
mysqldump to ProxySQL that will perform the
datamasking/obfuscation.
The dump file can then be used to provision new staging database
without using production data, and follow compliance
requirements.
This extremely simplify the "common" approach of dumping original
data and storing it in an not obfuscated format (not good for
compliance I believe), load the original data into a database,
and finally perform some obfuscating query (that can really take
a lot of time).
For this …
[Read more]
Want to get your web development ideas in
front of a live audience? The
call for papers for the ConFoo Vancouver 2017 web
developer conference is open! If you have
a burning desire to hold forth about PHP, databases, JavaScript,
or any
other web development topics, we want to see your proposals. The
window is
open only from April 10 to May 8, 2017, so hurry. An added
benefit: If your
proposal is selected and you live outside of the Vancouver area,
we will
cover your travel and hotel.
You’ll have 45 minutes for the talk, with 35 minutes for your
topic and
10 minutes for Q&A. We can’t wait to see your proposals!
Until the talks are picked, the price for the tickets will be at
its
lowest. Once …
Consider the scenario that you execute a query. You expect it to
be fast - typically subsecond - but now it take not return until
after 50 seconds (innodb_lock_wait_timeout seconds) and then it
returns with an error:
mysql> UPDATE world.City SET Population = Population + 999 WHERE ID = 130; ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
You continue to investigate the issue using the sys.innodb_lock_waits view or the underlying Information Schema tables (INNODB_TRX, INNODB_LOCKS and INNODB_LOCK_WAITS).
Note: …
[Read more]In this post, I’ll explain how to run Percona Server for MySQL and Percona Server for MongoDB on Bash on Windows on Ubuntu.
We are getting a good number of questions about whether Percona Server (for both MySQL and MongoDB) is available for Windows for evaluation or development purposes. I want to provide a guide to how to get it running.
In comments to the post Running Percona XtraBackup on Windows … in Docker, Peter Laursen recommend Bash on Ubuntu on Windows. That hadn’t occurred to me before, so the credit goes to Peter Laursen.
As of that older post, it appears that Percona XtraBackup was not working right in Bash on Ubuntu on Windows. But in my latest test on Windows …
[Read more]TokuDB Hotbackup is a solution that allows you to do backups on the fly. It works as a library that intercepts certain system calls that duplicate data written to already copied parts of files, so that at the end of the backup process the copied files contain the same content as the original files. There are several blog posts describing how TokuDB Hot Backup works in details:
[Read more]
The Oracle Bare Metal Cloud service is an innovative cloud
service.
When looking at how it can be used for MySQL Cluster it is a
great
fit.
MySQL Cluster is a high availability solution. Oracle Bare Metal
Cloud
provides the possibility to have servers that only you use and
thus
two Oracle Bare Metal servers are definitely independent of each
others
hardware. If you want to also run synchronous replication with
no
dependence on network, housing and electricity you can place
these
servers in different availability domains in the same
region.
Thus it is possible to build individual clusters with very
high
availability.
It is still possible to use smaller virtual machines that share
the
machine with other simultaneous users.
One of the most important features of MySQL Cluster is
predictable
latency. To achieve this it is …
