Mysqldump is a client utility that is used to perform logical backups of the MySQL database. This popular migration tool is useful for various use cases of MySQL such as: Backup and restore of databases. Migrating data from one server to another. Migrating data across different managed MySQL service providers. Migrating data between different versions […]
Dec
16
2020
Dec
16
2020
MySQL Shell is an advanced client tool that has many features and is easy to use. The recent MySQL release (MySQL 8.0.22) has the utility “exportTable()”, which supports exporting the data into a file from a table using MySQL shell. The exported data file can be imported using the utility “importTable()”, which was released in MySQL 8.0.17.
With “exportTable()”, you can export the data into a local server or in any S3-compliant object storage provider. In this blog, I am going to explain how those exportTable() & importTable() utilities are working in local servers and I also did some tests with MySQL 5.7 and MySQL 5.6.
Overview of exportTable() & importTable() exportTable():
- Introduced in MySQL 8.0.22.
- The utility is used to export the data from the MySQL table into a data file.
- It can be used to export the table to a local server or any S3-compliant object storage …
Dec
16
2020
Introduction In this article, we are going to see how we can enable the MySQL JDBC Driver Statement Caching mechanism, which, unfortunately, is not enabled by default. No matter what data access framework you are using, you still need to configure the JDBC Driver if you want to get the most out of the MySQL database engine. MySQL JDBC client-side PreparedStatement As I explained in this article, by default, the MySQL JDBC Driver emulates prepared statements. So, no matter if you are executing a plain Statement or a PreparedStatement, the SQL statement... Read More
The post MySQL JDBC Statement Caching appeared first on Vlad Mihalcea.
Dec
16
2020
If you plan to deploy a Drupal site to OCI using MySQL Database Service, there is a very easy way to perform that deployment: using OCI’s Resource Manager !
As you know, security is something very important for Oracle in OCI, therefor, exposing the database on the Internet is not allowed.
Even if you are not using OCI, I really recommend you to follow that principle and never expose your database to Internet !
I already cover this in many previous posts. But I also understand that for people not being a sysadmin, this can be complicated the first time.
That’s why, all this can be automated using a stack to deploy in Resource Manager.
The first thing to do when you have your OCI account, it’s to download the stack from GitHub: https://github.com/lefred/oci-drupal-mds
Then in OCI’s dashboard, just …
[Read more]
Dec
16
2020
In the previous blog we provided insights on how the MySQL database has been enhanced to integrate with a native high performance analytics engine – HeatWave: https://blogs.oracle.com/mysql/breakthrough-enhancements-in-mysql-database-service-with-analytics-engine
HeatWave is a new, massively parallel in-memory query engine developed by Oracle Labs designed for accelerating analytic workloads. HeatWave provides 100x-1000x acceleration over MySQL and MySQL compatible databases like Aurora.
There are four key architecture choices which provide compelling performance with HeatWave:
- An in-memory hybrid columnar format which is conducive to vector processing.
- A massively parallel architecture which is enabled by a massively partitioned architecture.
- State of …
Dec
16
2020
In the previous blog we provided insights on how the MySQL database has been enhanced to integrate with a native high performance analytics engine – HeatWave: https://blogs.oracle.com/mysql/breakthrough-enhancements-in-mysql-database-service-with-analytics-engine HeatWave is a new, massively paralle...
Dec
16
2020
MinervaDB Athena 2020 – MySQL 8 Observability by Peter Zaitsev
Peter Zaitsev (Founder and CEO of Percona) spoke in MinervaDB Athena 2020 about MySQL 8 observability, Troubleshooting MySQL performance proactively. In this talk, Peter share about what are MySQL performance metrics we should consider for building optimal MySQL infrastructure performance addressing performance, scalability and reliability.
⊗ MySQL 8 Observability by Peter Zaitsev
The post MinervaDB Athena 2020 – MySQL 8 Observability by Peter Zaitsev appeared first on …
[Read more]
Dec
15
2020
Role of Venture Capital Companies in building Database Systems Companies by Anandamoy Roychowdhary
Anandamoy Roychowdhary (a.k.a Roy) talked about how Venture Capital companies like Sequoia Capital can help you in building successfully Database Systems companies both strategically and technically. In this talk, Roy shared the most common metrics followed by Sequoia Capital to measure business from seed stage to the growth capital phase with more insights to how open source projects get evolved to wider adoption, community development and institutionalization of the business.
⊗ Talk from Roy on how venture capital companies can help you to build the Database Systems startups / business for scale
The post …
[Read more]
Dec
15
2020
The Vitess team had a successful presence at Kubecon + CloudNativeCon North America 2020. This year's event was in a virtual format. It ran from Nov 17-20. We had 2 talks, a project booth and 3 office hours sessions. In addition, we had mentions in 2 major keynote talks. Day 1 # Day 1 was a non-keynote day. It opened relatively quietly for us. We had 25+ attendees at our office hours session hosted by maintainers Alkin Tezuysal, Deepthi Sigireddi and Derek Perkins.
Dec
14
2020
MinervaDB Athena 2020 – Profiling Linux Operations for Performance and Troubleshooting by Tanel Poder
In Athena 2020, Tanel Poder talked about troubleshooting Linux operations performance based on the detailed forensics and evidence collection through0x.tools (Linux Process Snapper from Tanel), Which is a free, open source /proc file system sampling tool which annotates Linux thread handling activities more intuitively. The talk was really interesting for Open Source Database Systems folks who attended the conference because they spend most of their professional hours troubleshooting performance of their Database Infrastructure Operations for optimal performance and also in this talk Tanel’s approach was bottom-up (interpreting performance metrics with Linux probes) compared top-down approach (depending on Database Systems metadata views), You can download the PDF of the talk …
[Read more]