Up until now we have seen MDS (MySQL Database Service) and MySQL
in Azure.
As the Cloud technology keeps moving fast, I thought it would be
a good idea to see how to set up a MySQL in Amazon , as a
service, that is RDS.
The post MySQL in Amazon (RDS) first appeared on dasini.net - Diary of a MySQL experts.
Recently one of our customers ran into an issue, wherein a bad actor(code) from the application had made the wrong update to 16 M records of a critical table in the database, causing the entire production process to go down. The application Team was able to find the bad actor and block it, our Remote DBA was involved in the Data Recovery/Rollback.
Here I would like to discuss possible recovery methods for the above said scenario
Delayed Slave:
A simple and effective way to recover is by using a delayed slave, RDS started supporting this feature from version 5.6.40 and 5.7.22 i.e., you can induce a SQL thread delay-interval for applying the writes to a slave, detailed implementation is covered in our blog here. It’s …
[Read more]This brief summarises the proceedings and outcomes of the 2nd MyWebinar which was held on 13th February 2021 at Online Webinar. As part of our thought leadership webinar series, our latest hosting webinar Migrate your EOL MySQL Servers (seamless migration to MySQL group replication / InnoDB cluster)
We have conducted MyWebinar with a very positive response with the help of software like zoom hosting arrangement and YouTube streaming and commitment of our business team, We have easily planned the perfect broadcasting for all of the attendees.
Over 30+ people took part in our webinar on 13th Feb 2021, to learn MySQL EOL and upgrade path. The session “Migrate your EOL MySQL servers to HA Complaint GR Cluster / InnoDB Cluster With Zero Downtime” by …
[Read more]Somebody asked me about how they could convert an XML file to a CSV file to upload into MySQL. They were asking the question based on an old Convert XML to CSV blog post from 2008. Amazing though that is, I had to explain the process no longer requires manual tasks, like calling Java files from the Apache XML Project. All they needed to do was use the Oxygen XML Editor, which is why I wrote this blog post.
For example, I had them use the same sample XML file from the old
blog post (shown below) with one change. The
encoding value needs to change from
latin1 (ISO-8859-1) to unicode
(UTF-8). Then, they should put it into a local
Windows directory (mine went into the …
When you migrate to MySQL Database Service on Oracle Cloud Infrastructure (MDS on OCI), the easiest, fastest and recommended way it to use MySQL Dump & Load Utility.
For more information check these different links:
Whats new in NDB Cluster 7.5 version
In this version, users have more flexible ways of table
partitioning rather than the default way thru ldm. Now user can
partition the table either by node or by ldm. There are 4
different ways of table partitioning supported, these are:
From the above RA is for Read from any replica i.e either from
Primary replica or backup replica and RP is for Read from Primary
replica only. The above options user can give either thru create
table or from alter table sql statement in the COMMENT
section like below.
mysql> create table t1(col1 int unsigned not null primary key …
This blog introduces how RonDB handles automatic thread configuration. This
blog is more technical and dives deeper under the surface of how
RonDB operates. RonDB provides a configuration option,
ThreadConfig, whereby the user can have full control over the
assignment of threads to CPUs, how the CPU locking is to be
performed and how the thread should be scheduled.
However for the absolute majority of users this is too advanced, thus the managed version of RonDB ensures that this thread configuration is based on best practices found over decades of testing. This means that every user of the managed version of RonDB will get access to a thread configuration that is optimised for their particular VM size.
In addition RonDB makes use of adaptive CPU spinning in a way that limits the power usage, but still provides very low latency in all database operations. …
[Read more]Lately, the number of questions about how to build Percona software has been increased. More and more people try to add their own patches, add some modifications, and build software by themselves. But this raises the question of how to do this in the same way as Percona does, as sometimes the compiler flag can make a drastic impact on the final binary.
First of all, let’s talk about the stages of compiling software.
I would say that at the beginning you need to prepare the build environment, install all the needed dependencies, and so on. For each version, the dependency list would be different. How do you get the correct dependency list? You can get all build requirements from the spec file (on rpm-based systems) or from the control file( on deb-based systems).
The next stage is to get the source code of Percona …
[Read more]This week I was evaluating AWS QLDB. Specifically the verifiable history of changes to determine how to simplify present processes that perform auditing via CDC. This is not the first time I have looked at QLDB so there was nothing that new to learn.
What I found was that creating a workable solution with an existing application is hard. Even harder is creating an example to publish in this blog (and the purpose of this post).
First some background.
Using MySQL as the source of information, how can you leverage QLDB? It’s easy to stream data from MySQL Aurora, and it’s easy to stream data from QLDB, but it not that easy to place real-time data into QLDB. AWS DMS is a good way to move data from a source to a target, previously my work has included MySQL to MySQL, MySQL to Redshift, and MySQL to Kinesis, …
[Read more]ProxySQL is proud to announce the latest release of ProxySQL version 2.0.17 on the 9th of February 2021
ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here or alternatively from the ProxySQL Repository, or the Docker image available on our Official ProxySQL Docker Repository. ProxySQL is freely usable and accessible according to the GNU GPL v3.0 license.
Release Overview Highlights
ProxySQL v2.0.17 is a patch release comprising of minor backward compatible changes and bug fixes.
Be sure to try out the new ProxySQL 2.0.17 release and …
[Read more]