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 High-Availability for databases having tables without primary key.

3132167Jul 11 2018 — edited Jul 31 2018

I have a requirement to setup MySQL High availability between 2 MySQL instances. I had setup innodb cluster with one RW MySQL instance (master) and the 2nd instance as RO (slave). Some of the databases in the primary mysql instance have tables without primary key and this poses a limitation in setting up this HA. Could you recommend other ways that HA can be setup between 2 mysql instances that replicates everything in a database (without restrictions)?

Version of MySQL is 8.0.11.

I also need to have internal copies of the same or some databases in the primary mysql instance for reporting in another mysql instance. But this could be real time or scheduled copies of everything in the database which is large (~300GB). Hence mysqldump restore is not looked at. Any recommendation for this would also be helpful.

Thanks for your help,

Gayathri

Comments

Mike Kutz

Your procedure is in APP. Correct?

What is your Parsing Schema Name?  It sounds like XXAPEX.

What is your Workspace Schema name? I'm going to guess MILOWSKI

You need to grant permissions to the Parsing Schema in order for the APEX Application to work.

I've found that, under some circumstances, you have to grant permissions to the Workspace Schema too.

I forgot if I still needed the perms after I created the page.

MK

Tomek

Not sure What do you think I missed:

Workspace Name: AIS

Schema connected to the workspace: XXAPEX

Apex Login: MILOWSKI

There is only one schema XXAPEX.

MILOWSKI is my username in Apex with default schema set to XXAPEX.

Mike Kutz

Ok.  I think I understand what is happening.

Creating the synonym should have worked.

However, you need to Create Form on Procedure using the synonym XXAPEX.PAGE_MGR not the underlying package APP.PAGE_MGR.  (current guess)

I haven't had time to try to reproduce the problem.

MK

Tomek

Thanks Mike but this is not working either...

I made sure the synonym is in place. In APPS schema executed the following:

GRANT ALL ON page_mgr to xxapex WITH GRANT OPTION;

DROP SYNONYM xxapex.page_mgr;

CREATE SYNONYM xxapex.page_mgr FOR page_mgr;

When I login to Apex and use "Object Browser" I see the synonym is right in place.

However, when creating the "form on procedure" the package page_mgr is not there listed in the list nor I can just type it in. I specify the XXAPEX as procedure owner.

Tomek

Does anyone experienced this problem?

1 - 5

Post Details

Added on Jul 11 2018
9 comments
1,492 views