The add database command is used to teach Bucardo about a database that will be involved in replication. It is usually the first step performed after the installation.
Example:
bucardo add database A host=example.com dbname=sales
This will creates a new database entry named A which resides on host example.com and is named sales. Note that “sales” is the actual database name that Bucardo will connect to, while “A” is how Bucardo refers to this specific database, for example when calling add dbgroup. A connection to the database will be attempted right away: see the Verification section below.
Usage:
bucardo add database <name> <dbname=value> [optional arguments]
The alternate form add db is also accepted.
bucardo add db foobar type=oracle host=example.com user=scott conn=sid=abc
Before a new database is added, a simple connection test if performed to make sure everything is working. Thus, you will need to have the database up and running, as well as have installed any extra Perl modules needed to reach the database. The additional Perl modules you need depend on the database type:
New databases cause an insert to the db table. A new database group will cause an insert to the dbgroup table. Databases added to that group will cause an insert to the dbmap table. Adding tables and sequences will cause inserts to the goat table.
End Point Dev offers professional support for Bucardo, as well as specializing in developing, designing, and marketing effective websites. Since 1995, our diverse team of developers has shown that End Point can handle your organization’s greatest web and database challenges.