At MySQL we love opportunities to interact with our users and MySQL User Camp gives us the chance to do just that. The first MySQL User Camp of this year was held on February 13th 2019 at the Oracle Kalyani Magnum Office.…
Facebook Twitter Google+ LinkedIn
MySQL User camp is one of the prestigious MySQL meetup happening in India for the past 6 years. Mydbops DBA’s PonSuresh and Vignesh has presented about the “JSON functions and their improvements in MySQL 8.0” at MySQL User Camp Bangalore on 13-02-2019.
JSON has been more improved a lot in MySQL 8.0 and improvements in LOB storage of MySQL boost it performance further. This presentation covers the JSON performance enhancements in MySQL 8.0 with its basic functions.
The Oracle Open World 2019 Call For Paper is open until March 13th.
MySQL track will be part of CodeONE, the parallel conference focused on developers.
We encourage you to submit a session related to the following topics:
Don’t miss the chance to participate to this amazing event. Submit now() here !
InnoDB keeps hot data in memory on its buffer named InnoDB Buffer Pool. For a long time, when a MySQL instance needed to bounce, this hot cached data was lost and the instance required a warm-up period to perform as well as it did before the service restart.
That is not the case anymore. Newer versions of MySQL/MariaDB allow users to save the state of this buffer by dumping tablespace ID’s and page ID’s to a file on disk that will be loaded automatically on startup, making the newly started server buffer pool as it was prior the restart.
Details about the MySQL implementation can be found at https://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html
With that in mind, Percona XtraBackup versions …
[Read more]
The much anticipated release of Galera 4 makes
its way first in the latest release of MariaDB Server
10.4.3 Release Candidate which you can download now. Congratulations to MariaDB
Corporation and MariaDB Foundation on this release candidate — please get testing Galera
4, and share your feedback with us via our Google Group discussion list! Do not forget that
you can always reach us via email: mailto:info@galeracluster.com
and via our contact us form.
The feature we are excited about the most, is a feature request from many users. This is none other than huge transaction …
[Read more]Some months ago, Shlomi Noach published a series about Service Discovery. In his posts, Shlomi describes many ways for an application to find the master. He also gives detail on how these solutions cope with failing-over to a slave, including their integration with Orchestrator.
This is a great series, and I recommend its reading for everybody implementing master failover, with or without
The Oracle Cloud has a lot to offer with it’s Security Focused 2nd Generation OCI environment. My previous blog on OCI IaaS walks us through some of the great IaaS features such as compartments and VCN Subnets where you can run services across private ip addresses. What I’d like to look at this time is… Read More »
In this article, let us look at the new storage format of compressed large objects (compressed LOB or ZLOB). In my previous article MySQL 8.0: InnoDB Introduces LOB Index For Faster Updates, I have explained about the new storage format of uncompressed LOBs. …
Facebook Twitter Google+ LinkedIn
In this post, I want to explore a way to establish 100,000 connections to MySQL. Not just idle connections, but executing queries.
100,000 connections. Is that really needed for MySQL, you may ask? Although it may seem excessive, I have seen a lot of different setups in customer deployments. Some deploy an application connection pool, with 100 application servers and 1,000 connections in each pool. Some applications use a “re-connect and repeat if the query is too slow” technique, which is a terrible practice. It can lead to a snowball effect, and could establish thousands of connections to MySQL in a matter of seconds.
So now I want to set an overachieving goal and see if we can achieve it.
Setup
For this I will use the following hardware:
Bare metal server provided by packet.net, instance size:
c2.medium.x86
Physical Cores @ 2.2 GHz
(1 X AMD EPYC 7401P)
Memory: 64 GB of …