Migrating from Oracle to MySQL/Percona Server is not a trivial
task. Although it is getting easier, especially with the arrival
of MySQL 8.0 and Percona announced Percona Server for MySQL 8.0 GA. Aside from
planning for your migration from Oracle to Percona Server, you
must ensure that you understand the purpose and functionality for
why it has to be Percona Server.

This blog will focus on Migrating from Oracle to Percona Server
as its specific target database of choice. There's a page in the
Oracle website about SQL Developer Supplementary Information for MySQL
Migrations which can be used as a reference for the planned
migration. This blog will not cover the overall process of
migration, as it is a …

Unfortunately at that time we encountered some issues which led us to
rollback these changes. This was to allow users of operating
systems that did not – yet – support TLSv1.1 or higher to
download Percona packages over TLSv1.0.

Since then, we have been tracking our usage statistics for older
operating systems that don’t support TLSv1.1 or higher
at https://repo.percona.com. We now receive very few
legitimate requests for these downloads.

Consequently, we are ending support for TLSv1.0 on all
Percona web properties.

The importance of online code editing platforms cannot be
overemphasized. As much as we love our local IDE's, one too many
times we find ourselves needing to quickly share and or
collaborate with a friend or colleague in our local projects.

In cases like this, online playgrounds give us that added
functionality to write and run codes as well as share snippets
and have colleagues test it out and give us feedback. In this
post, we'll be looking at the top 7 online code editors for
JavaScript in no particular order.

CodePen

CodePen is an
online social development environment for front-end developers.
It comes fully equipped with all the features you'll need to
build, test, share, collaborate and even deploy your websites.

Plans and Features CodePen plans are flexible
enough to accommodate whatever needs you might have. First, there
are individual and …

Jordan Raine is a staff software developer at Clio, the
leading provider of legal practice management, client
relationship management, and client intake software. Clio is
dedicated to helping lawyers meet client needs and run efficient,
profitable practices. Jordan wrote this post to help mySQL
developers save time/effort and ultimately improve their
customers' experience.

Unlike most code a developer writes, writing SQL only requires us
to describe what data we want and not how to get it. When given a
query like SELECT id, author_id FROM
posts WHERE author_id = 123
ORDER BY id, you needn’t concern yourself
with what indexes are used (if any), what type of sort is used,
or any other number of implementation details. Instead, the query
optimizer handles this for you. This keeps SQL concise and …

More than 3 weeks passed since my previous review of public MySQL bug reports I
am subscribed to, so it's time to present some of the bugs I've
considered interesting in January, 2019.

As usual, I'll review them starting from the oldest and try to
summarize my feelings about these bugs at the end of this post.
Here they are:

Bug #93806 - "Document error about ON
DUPLICATE KEY UPDATE". Years pass, but fine MySQL manual still does not explain
some cases of InnoDB locking properly. Xiaobin Lin found
yet another case that it does not explain properly. Or, maybe,
the manual is correct and the problem in …

While implementing ClickHouse for query executions statistics storage
in Percona Monitoring and Management (PMM),
we were faced with a question of choosing the data type for
metrics we store. It came down to this question: what is the
difference in performance and space usage between Uint32, Uint64,
Float32, and Float64 column types?

To test this, I created a test table with an abbreviated and
simplified version of the main table in our ClickHouse Schema.

The “number of queries” is stored four times in four different
columns to be able to benchmark queries referencing different
columns. We can do this with ClickHouse because it is a
column store and it works only with columns referenced by the
query. This method would not be appropriate for testing on …

Since the concept of cloud was born, there has been strong growth
in the number of migrations to this environment. However, not
everything that shines is gold.

As the demand grows, so does the costs. We can find ourselves in
a situation where our monthly cloud expenses are very high and,
in this case, it may make sense to migrate back to an on-prem
environment.

The costs may not be the only reason. There might be security or
compliance requirements, or we may need to have more control of
our systems. Knowing what happens at a lower level can help us
better optimize things.

AWS not only give us the environment, it also
provides us with monitoring and management tools to run our
system in the cloud. So, it can be really hard to migrate to an
on-prem environment and recreate all these tools to …

If you work with MySQL or PostgreSQL, you probably at least heard
about PMM (Percona Monitoring and Management). If
you want to test it, you may also be interested in this article:
I’ll show you how to setup a MySQL and a MariaDB instance and
monitor them in the quickest way. Which is Docker.

Docker is
also my favourite way of running PMM in production. To be clear,
I wouldn’t run a production DBMS in Docker. But now we are
talking to test something quickly on your laptop, without wasting
too much time. And I don’t know a faster way.

Note: PMM is not a single piece of software. It
is a solution created by making use of existing software
projects, like Grafana, Prometheus and Orchestrator. In this post
I want to add this complexity, even if the cost is a …

Mydbops database meetup was held on 26-01-2019
and 48 members from open source database community has attended
this event. We had talks on MySQL and MongoDB databases.

Open source database enthusiastic from companies like OLA Cabs,
Searce Inc, PayTm, Quikr, Zensar, Grab, SAP labs, Travel Yarri,
Meddiff and a few has travelled from other cities of India like
Hyderabad and Chennai.

The Welcome talk was given my Selva venkatesh of Mydbops. He
spoke about the open source database community and welcomed all
the participants and speakers.

Followed by it Karthik P R , CEO/ Founder, Mydbops made his
presentation on “InnoDB Performance
Optimisation” . InnoDB is the prime engine in
MySQL.This talk focuses on the InnoDB Architecture in MySQL 8.0
and its fine tuning. He also answered the various questions
raised …

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.