Today we announce the availability of MySQL Database Service with HeatWave in four additional regions: Australia East (Sydney), Saudi Arabia West (Jeddah), South Korea Central (Seoul) and South Korea North (Chuncheon). With those new regions, you can now deploy MySQL Database Service with HeatWave i...
Dec
17
2020
Dec
17
2020
Disaster Recovery for Continuous MySQL Operations does not have to be hard, but it does have to be WAN: Multi-Site, Hybrid-Cloud, Multi-Cloud. This blog discusses Business Continuity, Disaster Recovery, or “DR,” and an overlooked clustering feature that makes continuous database operations easy, affordable, and manageable.
Tags: MySQLMariaDBmysql continuous operationsmysql clusteringHigh AvailabilityDisaster …
[Read more]
Dec
17
2020
ProductIP has been a Continuent customer since November 2014 and is sharing its Continuent experience here: from initially setting up their infrastructure in Hong Kong to running a geographically distributed MySQL database replication and clustering environment with Continuent Tungsten, read about their journey with us in this guest post.
Tags: MySQLMySQL Replicationmysql clusteringgeo-distributedtungsten clusteringtungsten replicator …
[Read more]
Dec
17
2020
In one of our previous articles - Setting up Replication with
various methods for MySQL 8 - we reviewed how to create a replica
with multiple tools.
Now, it is time to perform the same action but with MySQL Shell.
The post MySQL SHELL – The new era first appeared on dasini.net - Diary of a MySQL experts.
Dec
17
2020
Learn how to safely rename a column in a MySQL database using a universal multi-featured tool – dbForge Studio for MySQL. To paraphrase Heraclitus, the only constant is change. That concerns databases too. With time, business requirements change forcing the database development process to adapt. Thus, database developers increasingly face the necessity to perform structural database […]
The post How to Change a Column Name in MySQL appeared first on Devart Blog.
Dec
17
2020
Our pleasure to inform & invite you to the MySQL Virtual Meetup hold next week - just before Christmas. Please find details below:
- Date: December 22, 2020
- Time: 6:30 PM to 8:30 PM GMT+4
- Place: VIRTUAL event
- URL with more details: MySQL User Group U.A.E
- Speaker(s):
- Chetan Rao, the Territory Manager MySQL Enterprise Middle East & Africa
- Abdullah Zarour, the MySQL Principal Solution Engineer
- Carsten Thalheimer the MySQL Cloud Evangelist
- Covered topics: MySQL InnoDB Cluster and InnoDB ReplicaSets & Oracle MySQL Cloud Services as two main topics or themes of this meetup.
You are more than welcome to join!
Dec
17
2020
Our pleasure to inform & invite you to the MySQL Virtual Meetup hold next week - just before Christmas. Please find details below: Date: December 22, 2020 Time: 6:30 PM to 8:30 PM GMT+4 Place: VIRTUAL event URL with more details: MySQL User Group U.A.E Speaker(s): Chetan Rao, the Territory Manager M...
Dec
16
2020
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
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.