Database Syncronization on Backup Server

[newtsys]

To ensure our Forum uptime we have implimented a backup server in a different location. We are using SQLyog Enterprise to sync the db's. The problem is VBulletin does not install a Primary key for the following tables so there are postindex, Download index post listings and other issues between the databases upon syncronization. Here is the log from SQLyog:

No PRIMARY KEY defined in the table '`affiliates_settings`'
No PRIMARY KEY defined in the table '`attachmentviews`'
No PRIMARY KEY defined in the table '`badwords`'
No PRIMARY KEY defined in the table '`dl_cats`'
No PRIMARY KEY defined in the table '`dl_coms`'
No PRIMARY KEY defined in the table '`dl_files`'
No PRIMARY KEY defined in the table '`imagecategorypermission`'
No PRIMARY KEY defined in the table '`mcpollbooth`'
No PRIMARY KEY defined in the table '`passwordhistory`'
No PRIMARY KEY defined in the table '`posthash`'
No PRIMARY KEY defined in the table '`postindex`'
No PRIMARY KEY defined in the table '`regimage`'
No PRIMARY KEY defined in the table '`strikes`'
No PRIMARY KEY defined in the table '`threadviews`'
No PRIMARY KEY defined in the table '`tournament_players`'
No PRIMARY KEY defined in the table '`tournaments`'
Sync started at Wed Oct 26 16:39:33 2005

I am not certain if the lack of primary keys in the indexes is intentional but for our needs it is a neccesity at this time unless there is another way to sync the DB's. My question is can these tables list a primary key and how do I go about getting them there so our sync's will work correctly??

VBulletin 3.0.6 Mysql 4.0.26

[Marco van Herwaarden]

Not all of these tables are standard vB tables.

About the vB tables you could ask at vb.com if a primary key can be added without problems.

[newtsys]

Originally Posted by MarcoH64

Not all of these tables are standard vB tables.

About the vB tables you could ask at vb.com if a primary key can be added without problems.

The structure is the same for the standard table indexes as well as the hacks which were installed. The reason I asked here was because of the category description led me to believe this was the right place to ask.

PHP / MySQL / JS / (X)HTML
If it's PHP, MySQL, JS or (X)HTML you're having problems with, come in here and get help from the guys that know what they're doing!

[Marco van Herwaarden]

In this case i think the developers of vB can much better give an answer as to wether adding these indexes would cause any problems.

[newtsys]

Per your suggestion posted there yesterday..............
looks like no wants to touch it though

[Marco van Herwaarden]

I don't have time to look into it now, but give me a pm so i won't forget, and i will look into it.

[newtsys]

PM sent as a reminder.

It looks like these questions might have stumped the experts

[newtsys]

It has been said that adding a primary key to a couple of these tables will cause VB to crash.

Is there anyway to accomplish DB synchronization on 2 seperate remote machines. One used as primary and the other as a backup and as server load balancing when traffic is extremely heavy????

[Marco van Herwaarden]

MySQL database replication maybe.