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.
Thanks,
-Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw
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.
Thanks,
-Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw