PDA

View Full Version : Database Syncronization on Backup Server

newtsys
11-01-2005, 03:20 AM
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
11-01-2005, 11:12 AM
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
11-01-2005, 04:15 PM
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
11-01-2005, 08:09 PM
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
11-02-2005, 04:00 PM
Per your suggestion posted there yesterday..............
looks like no wants to touch it though :(
Marco van Herwaarden
11-03-2005, 03:27 AM
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
11-05-2005, 06:39 PM
PM sent as a reminder.

It looks like these questions might have stumped the experts :)
newtsys
11-13-2005, 09:38 PM
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
11-13-2005, 09:42 PM
MySQL database replication maybe.