Ideas, releases, practical guides, and perspectives from the people building with MySQL.
MySQL introduced a JSON data type in version 5.7, and expanded the functionality in version 8.0.
Besides being able to store native JSON in MySQL, you can also use MySQL as a document store (doc store) to store JSON documents. And, you can use NoSQL CRUD (create, read, update and …
[Read more]Author: Robert Agar
MySQL is an extremely popular open-source database platform originally developed by Oracle. It currently is the second most popular database management system in the world, only trailing Oracle’s proprietary offering. If you aim to be a professional database administrator, knowledge of MySQL is almost a prerequisite. It is an important part of the multi-platform database environment found in the majority of IT departments.
A recent addition that has added to the complexity of managing a MySQL environment is the introduction of big data. Big data is characterized by the volume, velocity, and variety of information that is gathered and which needs to be processed. It can be used to provide an organization with the business …
[Read more]ProxySQL 2.0.7, released by ProxySQL, is now available for download in the Percona Repository along with Percona’s proxysql-admin tool.
ProxySQL is a high-performance proxy, currently for MySQL and database servers in the MySQL ecosystem (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues.
This release includes ProxySQL 2.0.7 which introduces many new features and enhancements and also …
[Read more]MySQL Workbench is a great multi-purpose GUI tool for MySQL, which I think is not marketed enough by the MySQL team and is not appreciated enough by the community for what it can do.
MySQL Workbench Licensing
MySQL Workbench is similar to MySQL Server and is an Open-Core product. There is Community Edition which has GPL licensed source code on GitHub as well as the “MySQL Workbench Standard Edition (SE)” and “MySQL Workbench Enterprise Edition (EE)” which are proprietary. The differences between the releases can be found in this document.
In this MySQL Workbench review, I focus on the MySQL Workbench Community Edition, often referred to as MySQL Workbench CE.
Downloading MySQL Workbench
You can download the current version of MySQL …
[Read more]
In MySQL Cluster 8.0.18 we have developed MySQL Cluster Auto
Installer to
also support installing NDB :)
We have made it very easy to setup an NDB Cluster in the Oracle
Cloud.
The Auto Installer will take care of installing the proper
software, installing
firewalls, installing some supportive software. Most of the
testing of this
software have been done against Oracle Cloud using instances with
Oracle
Linux 7.
I prepared two Youtube videos to show how it works. The first one
gives some
insights into setting up the Compute Instances required in the
Oracle Cloud.
Setup
compute instances in Oracle Cloud for MySQL Cluster
AutoInstaller
The second video uses these compute instances to set up an NDB
Cluster.
Setting up
an …
InnoDB Page Compression Explained
We have several customers with multi-terabyte database infrastructure on SSDs, The SSDs are great investment for performance but they are also expensive with shorter lifespans so storage efficiency management is something we are very cautious about on SSDs, At MinervaDB Labs we spend considerable amount of time doing research on InnoDB page compressions benefits and most common mistakes. The compressed tables were first introduced in 2008 with InnoDB plugin for MySQL 5.1 . Facebook has been a major committer to this project and most of it were later implemented in upstream MySQL code as well. We can implement compression in InnoDB is two ways, Either by using Barracuda InnoDB file format or ROW_FORMAT=COMPRESSED
How InnoDB page compression works ?
When a page is …
[Read more]
We have a new version of the MySQL Cluster Auto Installer. I have
prepared 3
Youtube videos that shows how to make use of the Auto Installer
to install and
set up a cluster on your local machine.
This is my first attempt at making Youtube videos to explain
things around
MySQL Cluster.
The Auto Installer is intended as a tool to make it easy to get a
cluster up and
running. It is NOT intended for managing a cluster.
The first Youtube video Install MySQL
Cluster 8.0.18 on Mac OS X shows how
to install MySQL Cluster 8.0.18 on Mac OS X. This is obviously
trivial, so should
be straightforward to do even without the video.
The second Youtube video Starting a local
MySQL Cluster using Auto Installer sets
up a …
NoSQL + SQL = Mysql 8 Open Source India 2019 keynote from Sanjay Manwani
Slides from the keynote presented at Open Source India 2019 at Nimhans convention center Bangalore. As usual lots of interesting folks. Lots of focus on Open Source.
Met people from the SODA foundation who are trying to standardize the IO layer across all cloud implementations. All the best guys.
Also met folks from MOSIP who have an effort ongoing to help countries create their own UID. Seems like they already have some traction.
Also met an interesting person trying to think about Indian design and creativity in software. After Chumbak it does make sense to think about how not only UI but the software development …
[Read more]Yesterday, Bhuvanesh published an article about how to verify the difference between allocated diskspace for a tablespace and the the data in it.
I commented with an old post explaining how to get some similar info only using SQL in case you don’t have filesystem access.
And finally, my friend Bill Karwin, commented how this info is not always accurate. Which, of course, I agree with.
This is why, I checked …
[Read more]
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the
release
of MySQL for Visual Studio 1.2.9.
This is a maintenance release for 1.2.x. It can be used for
production environments.
MySQL for Visual Studio is a product that includes all of
the
Visual Studio integration functionality to create and
manage
MySQL databases when developing .NET applications.
MySQL for Visual Studio is installed using the MySQL
Installer
for Windows which comes in 2 versions:
* Full (415.1 MB) which includes a complete set of
MySQL products
with their binaries included in the
downloaded bundle.
* Web (18.6 MB – a network install) which will just
pull MySQL
for Visual Studio over the web and
install it when run.
You can download MySQL …