In my previous blog, I have explained how the MySQL clone plugin works internally. In this blog, I am going to do a comparison of Backup and Recovery speed of MySQL clone plugin with other available mysql open source backup tools.
Below tools are used for speed comparison of Backup and Recovery,
Test …
[Read more]For a long time, the only algorithm for executing a join in MySQL has been variations of the nested loop algorithm. With the release of MySQL 8.0.18, the server can now execute joins using hash join. This blog post will have a look at how it works, when it is used, and how it compares to the old join algorithms in MySQL in terms of performance.…
Facebook Twitter LinkedIn
Recently, at Percona Live Europe 2019, Dimitri Kravchuk from Oracle mentioned that he observed some unclear drop in performance for MySQL on an ext4 filesystem with the latest Linux kernels. I decided to check this case out on my side and found out that indeed, starting from linux kernel 4.9, there are some cases with notable (up to 2x) performance drops for ext4 filesystem in direct i/o mode.
So what’s wrong with ext4? It started in 2016 from the patch that was pushed to kernel 4.9: “ext4: Allow parallel DIO reads”. The purpose of that patch was to help to improve read scalability in direct i/o mode. However, along with improvements in pure read workloads, it also introduced regression in intense mixed random read/write scenarios. And it’s quite weird, but this issue had not been …
[Read more]Discover the new Continuent Tungsten Replicator (AMI) – the most advanced & flexible replication engine for MySQL, MariaDB & Percona Server, including Amazon RDS MySQL and Amazon Aurora
We’re excited to announce the availability on the Amazon Marketplace of a new version of the Tungsten Replicator (AMI).
Tungsten Replicator (AMI) is a replication engine that provides high-performance and improved replication functionality over the native MySQL replication solution and provides the ability to apply real-time MySQL data feeds into a range of analytics and big data databases.
Tungsten Replicator (AMI) builds upon …
[Read more]MySQL Cluster is an open-source distributed in-memory database. It combines linear scalability with high availability, providing in-memory real-time access with transactional consistency across partitioned and distributed datasets. It was developed to support scenarios requiring high-availability (99.999% or more) and predictable query time. Testing such a system is achieved via many interconnected pieces ranging from a large set of automated tests and manual exploratory testing. This post explores an overview of the testing methodologies we use and the current challenges we face.
Gaming, banking, telcos, and online services all are powered by fully-redundant and fault-tolerant software systems. At the heart of those systems, you can find MySQL Cluster — a distributed in-memory database having a minimum of five-9s availability (around 5 minutes a year). This open-source database provides nearly-linear …
[Read more]dbForge Fusion is a line of Visual Studio plugins designed to simplify database development and enhance data management capabilities. This line comprises three tools: dbForge Fusion for SQL Server, dbForge Fusion for MySQL, and dbForge Fusion for Oracle. We are happy to announce new updates for each of these tools which come with many improvements […]
The post New dbForge Fusion tools with Visual Studio 2019 Support appeared first on blog.
A user defined table and its corresponding index data, in InnoDB, is stored in files that have an extension .ibd. There are two types of tablespaces, general (or shared) tablespace and file-per-table. For shared tablespaces, data from many different tables and their corresponding indexes may reside in a single .ibd…
Facebook Twitter LinkedIn
The Call For Papers for SCaLE 18x ends soon and I
would love to have your talk on MySQL be part of the MySQL track!
The track is usually on the Friday of the show!
I am 'curating' the MySQL track again and would love to have you
talk on MySQL. Do you have a story about using MySQL, some
trick admin skills you would like to share, a beginners guide to
X & MySQL, or a case study? Well then, please submit.
What is SCaLE? Well it is roughly 5,000 people in Pasadena,
California next March 5-8 2020 at the convention center in the
heart of the City. It is the only big open source in
Southern California and features multiple tracks on subjects
ranging from AI to how to work …
SQL UPPER function is used for converting all the characters in the source string to Uppercase characters. If any number is present in the string, then it remains unaffected. SQL UPPER() function converts a string to the upper-case.
SQL upper() Function
Suppose you have the online shopping website. Customers visit the website and provide the necessary information while creating the login account.
Each customer provides few compulsory information such as first name, last name, phone number, email address, and residential address.
Each customer is different, so you cannot expect the similar format for all inputs.
For example, you get a following entries in an SQL table.
We do not see all words following the consistent pattern.
It does not look good as well if you have to share the report daily to higher management for all newly enrolled customers.
The SQL UPPER …
[Read more]
The London Open Source Database Meetup is hosting me on December
4th -RSVP
and I will be talking about New MySQL Features and a
Brief Look into 2020!
MySQL has made lot of progress with version 8.0 and it has become
the fasted adopted new version of MySQL in history. The new CI/CD
release pattern had been delivering a lot of new features on a
regular basis that you may have not noticed. There is JSON
Document Validation thanks to the good people at JSON-schema.org,
random passwords, hash joins, explain analyze, constraint checks,
and more. So if you need to caught up this is you chance and if
you are wondering what is in the near term future this is your
opportunity.All opinions expressed in this blog are those of Dave
Stokes who is …
