Continuent is pleased to announce the availability of our new Tungsten Cluster (AMI) - the complete continuous operations solution for MySQL database clusters - on the AWS Marketplace.
Tags: tungsten cluster AWS amazon marketplace tungsten clustering MySQL mysql high availability mysql disaster recovery …
[Read more]The Challenge Often with sensitive information, you need to have an audit log. Not just that a table had a select run, but that specific cells within the table were accessed. Frequently data such as this will contain a classification level as part of the row, defining policies for how it is handled, audited, etc.… Facebook Twitter LinkedIn
I recently watched a fantastic Python Pandas library tutorial series on YouTube. Without a doubt, Pandas is great for all sorts of data stuff. On the same token, MySQL Shell in Python mode is quite powerful in the sense that Python and the MySQL Shell (version >= 8.0) are somewhat united in the same environment. Although Pandas is in a league all its own when it comes to data analysis, between the power of MySQL and Python, we can also perform some basic analysis easily in MySQL Shell Python mode. In this blog post, I will cover some basic data analysis using Python mode in the MySQL Shell. Continue reading to see examples…
Business vector created by freepik – www.freepik.com
OS, Software, and DB used:
ARM processors are fast gaining popularity in the High Performance Computing (HPC) space with multiple cloud providers providing powerful and flexible variants of ARM instances to boot. Users are still in a dilemma about whether running MySQL on ARM is really effective? To help ease this out we introduce a Cost-Performance-Model (#cpm). Model is generic in nature to help normalize computing configuration based on cost and could be used for other HPC kinds of software too.
USP of ARM
ARM is all about a lot of cores (may be less powerful compared to x86) running with lesser power there-by effectively generating cost savings. Let’s understand this fact with some data-points.
Above table shows that booting ARM resources on any cloud-provider is cost effective (compared to x86).
Key is to find out if the said saving could be realized when running software. This sounds easy, just run the same version …
[Read more]If you are using XA transactions, then you’ve likely run into a few replication issues with the 2PCs (2 Phase Commits). Here is a common error we see in Percona’s Managed Services and a few ways to handle it, including injecting an empty XA transaction.
Last_Error: Error 'XAER_NOTA: Unknown XID' on query. Default database: 'punisher'. Query: 'XA COMMIT X'1a',X'a1',1'
What Does it Mean?
It means that replication has tried to commit an XID (XA transaction ID) that does not exist on the server. We can verify that it does not exist by checking:
replica1 [localhost:20002] {msandbox} ((none)) > XA RECOVER CONVERT XID;
+----------+--------------+--------------+--------+
| formatID | gtrid_length | bqual_length | data |
+----------+--------------+--------------+--------+
| 1 | 1 | 1 | 0x2BB2 | …[Read more]
In a recent article, I explained how to test MySQL Database Service (aka MDS) on OCI without having to setup a VPN.
A VPN is the recommended way and of course using some man-in-the-middle exposing the MySQL Classic and X Protocol port is something you should absolutely avoid !
So, in this article we will see another way to test or use MDS without VPN but using a more secure option.
SSH
The solution uses a SSH tunnel between your machine (laptop, etc..) and OCI.
How does it work ?
We have a MDS instance (10.0.1.3), and a compute instance (10.0.0.2). The compute instance is in the public subnet and has a public IP assigned to it.
Then we open a SSH tunnel to the compute instance’s public IP that forward all traffic to a certain port on localhost (we will use 3406) …
[Read more]Author Andriy Lysyuk.
The unDROP for InnoDB tool can be used to recover
corrupt MySQL databases. In this post, we will show how to repair
a MySQL database if its files got corrupted and even
innodb_force_recovery=6 doesn’t help.
The corruption of InnoDB tablespace may be caused by many reasons. A dying hard drive can write garbage, thus, page checksum will be wrong. InnoDB then reports to the error log:
InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 4.
MySQL is well known for its poor start-up script. A simple upgrade procedure may end up with two mysqld processes writing to the same tablespace. That leads to corruption too. Sometimes, power reset corrupts not only the InnoDB files, but the whole file system becomes unusable for …
[Read more]MySQL 8.0 General Availability release was launched in April 2018, and since then there have been ten versions of MySQL 8 and Percona Server for MySQL released. The MySQL Community expressed a high opinion of the MySQL 8.0 advantages, so a lot of databases have been successfully upgraded to the new version. But many of them still need to be up to date.
Percona has prepared a free course “How to Upgrade to MySQL 8.0” that helps you with this task.
It is a series of useful videos for 3-4 minutes. At the end of the course, you can pass the QUIZ and get a certificate.
Follow the link to take the course: https://classroom.google.com/c/MTM2MDIyNDIzMDQy?cjc=zjsst4l
You can also join the course manually. Just open Google Classroom and click “Join class” and enter the code of the class “zjsst4l”. …
[Read more]Launching Your First MySQL DB System
Step 1 - Pre-requisites
1. 1. Create
a compartment and user group to organize the resources and
access. In this example, we create a compartment named
as MySQL_Sandbox, and a
group MySQL_Test_Group. Log-in the Console as an Administrator, under the Identity menu, create
a MySQL_Sandbox compartment, and a …
Using MySQL Enterprise Workbench to write SQL statements against MDS
Assume that you wanted to access/write sql statements on MDS from MySQL Workbench Running on On-premises (Windows OS)
How? Below are steps you needed to follow.
To connect with MySQL Workbench ,you require below details handy :-
Prerequisite:-
|
1. Installed MySQL Enterprise Workbench(preferred latest version) On-Premises. 2. Putty - https://www.putty.org/ 3. Up & Running MDS on ORACLE CLOUD . 4. Up and Running Compute instance. … |