Here’s what Java 17 has in common with Java 11 and Java 8.
Community journal
Follow the feed
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Showing entries 3131 to 3140 of 45487
« Previous |
Next »
The JEPs delivered in Java 17 range from new language features to improvements for core libraries to previews and incubators.
The JEPs delivered in Java 17 range from new language features to improvements for core libraries to previews and incubators.
Oct
13
2021
If you need a structure only .sql file of a MySQL tables’ Data Definition Language (DDL), phpMyAdmin makes this super-easy with just a few clicks. Continue reading and learn how…
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!
Why use a DDL file?
Why would you need a structure-only .sql DDL file anyway?
Maybe you want to build out a tables’ structure on another server to bring in different data or something comparable, and want it void of any existing data.
Rather than creating the …
[Read more]
Oct
13
2021
Why
Marco, why did you write this long article?
Yes, it is long, and I know most of the people will not read it in full, but my hope is that at least someone will, and I count on them to make the wave of sanity.
Why I wrote it is simple. We write articles to share something we discover, or to share new approaches or as in this case to try to demystify and put in the right perspective the “last shining thing” that will save the world.
The “last shining thing” is the use of containers for relational databases management systems (RDBMS) and all the attached solutions like Kubernetes or similar.
Why is this a problem? The use of containers for RDBMS is not really a problem per se, but it had become a problem because it was not correctly contextualized and even more important, the model that should be used to properly design the solutions, was not reviewed and modified in …
[Read more]
Oct
13
2021
Why
Marco, why did you write this long article?
Yes, it is long, and I know most of the people will not read it in full, but my hope is that at least someone will, and I count on them to make the wave of sanity.
Why I wrote it is simple. We write articles to share something we discover, or to share new approaches or as in this case to try to demystify and put in the right perspective the “last shining thing” that will save the world.
The “last shining thing” is the use of containers for relational databases management systems (RDBMS) and all the attached solutions like Kubernetes or similar.
Why is this a problem? The use of containers for RDBMS is not really a problem per se, but it had become a problem because it was not correctly contextualized and even more important, the model that should be used to properly design the solutions, was not reviewed and modified in …
[Read more]
In this blog , i am going to explain how to connect RDS MySQL
With SSL Connections from MySQL Workbench and MySQL / MariaDB
client utility by using command line
--> Make sure RDS MySQL / MariaDB instance is ready for
usage.
Connection Established from MySQL / MariaDB client by using
cmd line
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u admin -p
-h ssl-test-server.cz8z9jo4bowe.us-east-1.rds.amazonaws.com
Enter password: *************
Welcome to the MySQL monitor. Commands end with ; or
\g.Your MySQL connection id is 25.Server version: 8.0.23 Source
distribution.Copyright (c) 2000, 2018, Oracle and/or its
affiliates. All rights reserved.Oracle is a registered trademark
of Oracle Corporation and/or its affiliates. Other names may be
trademarks of their respective owners.Type 'help;' or '\h' for
help. Type '\c' to clear the current input statement.
mysql> show …
Oct
12
2021
Mydumper and Myloader
Installation ----------------------------------
Comparison of MySQL backup tools:
1. mysqldump: belongs to logical backup, there will be lock
tables, but considering that the amount of data is relatively
large, the time to lock the tables will be longer, business is
not allowed...
2. xtrabackup: It is a physical backup, and there is no lock
table, but considering that the two DBs use shared table spaces,
and when the database of business B is restored, one is that the
time is relatively long, and the other is that the data is
definitely incorrect....
3. mydumper: belongs to logical backup. It is a multi-threaded,
high-performance data logical backup and recovery tool, and the
lock table time is very short (40G data, within 10 minutes), and
it will record binlog file and position at the same
time....
Mydumper & Myloader installation in RHEL for MariaDB / …
ProxySQL 2.3.0 was recently released and when I was reading the release notes, I was really impressed with the Group Replication enhancements and features. I thought of experimenting with those things and was interested to write a blog about them. Here, I have focused on the following two topics:
- When the replication lag threshold is reached, ProxySQL will move the server to SHUNNED state, instead of moving them to OFFLINE hostgroup. When shunning a server, it will be performed gracefully and not immediately drop all backend connections.
- The servers can be taken to maintenance through ProxySQL using “OFFLINE_SOFT”.
Test Environment
To test this, I have configured a three-node GR cluster (gr1,gr2,gr3) in my local environment. I have configured a single primary cluster (1 writer, 2 readers).
mysql> select member_host,member_state,member_role,member_version from …[Read more]
I decided to write this article after a discussion with other colleagues. We were wondering how and if the Percona Distribution for MySQL Operator(PDMO) could help a starting business or a new project inside an enterprise. We were also wondering how it behaves in relation to already well established solutions, like Amazon RDS or Google SQL.
In fact, we often see analysis and benchmarking covering huge datasets and instances with very high levels of resources . But we tend to forget that any application or solution started as something small, and it is important to identify a database platform that allows us to scale from zero to a decent amount of load, while keeping the cost as low as possible.
This also happened while I was trying to get a bit more performance and stability out of Percona Operator for MySQL, and identify the possible minimal entrypoint and its usage.
Given all the above …
[Read more]