Hi there,
Is it possible to have 2 Matrix instances pointing to the same database schema?
When we try to install another Matrix instance by using an existing database schema. We hit with error in step_03.php.
±-----------------------------------------------------------------------------------------------------+
| MySource Warning |
|------------------------------------------------------------------------------------------------------|
| Unable to create another "Root Folder", it is a System Asset and you are only allowed one [CORE0085] |
±-----------------------------------------------------------------------------------------------------+
±-----------------------------------------------------+
| MySource Error |
|------------------------------------------------------|
| Root Folder NOT CREATED [CORE0001] |
±-----------------------------------------------------+
Thanks,
Alice
No, you can't use the same DB. Matrix has a whole bunch of assets that need to be unique within the system, like the root user.
[quote]
No, you can't use the same DB. Matrix has a whole bunch of assets that need to be unique within the system, like the root user.
[/quote]
In MySource Matrix Architecture Options document, there is an option "Dynamic writable publishing platform" [in page 7 - as attached] allows a slave Matrix server to access/write to the same copy of database using by a master Matrix server.
The document does not specify much details for this imeplementation. So, appreciate if you can provide a little bit more information on this option, especially in your reply saying "Matrix server cannot use the same DB".
Many thanks.
This topic was about 2 independent installs of Matrix using the same DB, which can't be done.
A replicated install of Matrix is totally different. That is a single system with multiple copies of Matrix used to provide load balancing or disaster recovery. In this mode, each copy of Matrix can be told to read from one DB and write to another. DB replication can also be used to allow two copies to write to two different DBs and have the sync'd.
You need to contact Squiz for more information beyond this.
[quote]
This topic was about 2 independent installs of Matrix using the same DB, which can't be done.
A replicated install of Matrix is totally different. That is a single system with multiple copies of Matrix used to provide load balancing or disaster recovery. In this mode, each copy of Matrix can be told to read from one DB and write to another. DB replication can also be used to allow two copies to write to two different DBs and have the sync'd.
You need to contact Squiz for more information beyond this.
[/quote]
Thanks Greg,
A replicated install of Matrix is what we are looking for. Sorry to confuse you.
No problem. It just looked like you were trying to install two copies of Matrix in the same DB, whereas you don't need to do this with replication. You just replicate the file system and make sure the DB connection details are still valid.