Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySQL 5.7 automatic failover steps with GTID=ON

3691094Jan 23 2019 — edited Feb 4 2019

Hello All,

I need help in setting up automatic failover for MySQL 5.7.

I know the steps for the manual failover.

But if i need to automate the failover process please let me know the steps and process.

I have 2 servers only. Master and Slave with GTID=ON.

Please let me know the details.

This post has been answered by Dave Stokes-MySQL Community Team-Oracle on Jan 23 2019
Jump to Answer

Comments

thatJeffSmith-Oracle
Answer

Should be out soon.

Marked as Answer by jdoornae · Jun 29 2022
jdoornae

It's there now. Thanks!

Mal Baird

Is JDK 8 or 11 included?
image.pngimage.png

thatJeffSmith-Oracle

11, fixing the typo now

stom

Downloaded SQL Developer 22.2 with JDK 11
Copied my preferences over from the previous installation (21.4.3.063).
When I try to connect to a database from the connection tree, I get this error.
image.png Any ideas?

thatJeffSmith-Oracle

What type of connection is it?
I'm running the exact same thing you are, 64-bit Windows w/Java 11 included, and on an upgrade can connect just fine.
Maybe, try extracting the zip again using native Windows file explorer to a net-new directory, and try connecting from that location?

stom

It is a basic connection. I specify the host, port and service name. I right clicked on the connection name -> properties -> Test
image.pngI extracted to a new location and I also downloaded the "No Java" version. I get the same error on both attempts.

thatJeffSmith-Oracle

Do you have an oracle client defined in the Advanced Preferences, or are you using a TNS connection type or do you have 'OCI' checked on your advanced connection properties?

stom

I am using a basic connection type. I have a TNSNAMES file but I don't use it.
image.pngI have "OCI/Thick driver" checked. We use Radius authentication for our DB logins and I remember it wasn't working without this box checked.

thatJeffSmith-Oracle

That's probably it, get a newer client and try that, a 19c or 21c client.

user-x79xr

Same issue for me - java.lang.NoClassDefFoundError: oracle/jdbc/datasource/impl/OracleDataSource

I'm using 19c Client with "OCI/Thick driver" checked in SQLDeveloper 22.2 but still facing this issue.

1 - 11

Post Details

Added on Jan 23 2019
2 comments
266 views