In the Zend Framework using MultiDB Resource, how do I set up a database backup?

We use the MultiDB Zend Framework resource ( http://framework.zend.com/manual/1.10/en/zend.application.available-resources.html#zend.application.available-resources.multidb )

I was tasked with adding a new database resource that has three endpoints for redundancy. I would like to configure MultiDB, so if the connection to the first endpoint fails, it will connect to the second and, if necessary, the third endpoint before rejecting.

I tried to set resource.multidb.resourcename.host [], but it failed. It appears that it only accepts one endpoint.

Is there a way to set up a backup? Or do I need to extend Zend_Application_Resource_Multidb?

+5
source share
1 answer

Honestly, I have never tried the software side (not even sure if this is really possible using the zend system itself) to back up database applications. And there is a good reason for this: this is simply the wrong place for this!

There are several stumbling blocks:

  • How do you manage to save data in multiple databases?
  • What happens if one database is down?

Assuming you are using MySQL: you can take a look at MySQL's master-slave replication: 16.1.1. Replication setup

( ). , : , , / !

, , - ( , ) vServer.

, ... .

0

All Articles