471,108 Members | 1,291 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

replication question

I work for a small (but very fast-growing) company, and we're about to
start deploying our new website. Because it has a "live inventory"
setup, and because our internal tools are so integrated with the
ecommerce side of things, I figure that replication is the best tool for
us - we'd have a fast database at our colo, and one in the office, and
data would be mirrored as needed.

I can work around issues that might arise with auto-increment fields
when the servers can't talk, but I'm wondering if there is a way to do
table-based replication instead of db-based. I'd prefer it if the
master machine only paid attention to changes on certain tables from the
slave (my code already handles this, but I'm still looking for that
extra bit of security - plus as I understand it, if things are read-only
they will be a bit faster).

Also, is there a good link for how to set up two-way replication? As
noted on the FAQ comments section, there is very little information in
the documentation.


MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 2170

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Craig HB | last post: by
4 posts views Thread by SQLNow | last post: by
1 post views Thread by Andrew Chanter | last post: by
9 posts views Thread by David W. Fenton | last post: by
6 posts views Thread by Alex | last post: by
5 posts views Thread by ken | last post: by
2 posts views Thread by zgb | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.