Home
Home

Directory
Directory

Articles
Internet News
Security News
Ecommerce News
Domain News

Site Tools
Site Speed Test
Keyword Research
Resolve Hostname
DNS Tools
Register Domains
Affiliate Programs
Open Source

Shopping Carts
Cart Reviews
SSL Certificates

Enter your email address to subscribe to our updates:

Delivered by FeedBurner


Venue Charts
Channel Traffic Rankings
OAI Stock Quotes and Charts
eBay's Worst Feedback

Forum
Forum Home
TulipTools News
Advertising
Blogging
Computer Hardware
Domain Names
Ecommerce
Financing
Int'l Trading
Graphics and HTML
Internet Access
Legal Issues
Internet Business
Auction Sites
Classified Ad Sites
Fixed Price Venues
Operating Systems
Programming
Search Engines
Internet Security
Software
Web Hosting
Webmaster Issues
Reviews
Announcements
Off Topic Discussion

Web Hosting
TulipHosting

Domain Names
TulipDomains

Web Stats
TulipStats

Forum Rules
Forum Rules
Privacy Policy

Site Map
Forum Sitemap
Sitemap Topics




Directory| Forums| Internet News|Cart Reviews| DNS Tools| Keyword Research| Site Speed Test| Security| | Domain Marketplace| Domain Blog
TulipTools Internet Business Owners and Online Sellers Community
  • Home
  • Search
  • Member List
  • Calendar
Hello There, Guest! Login Register
TulipTools Internet Business Owners and Online Sellers Community › Programming and Databases › Programming and Databases › Databases › MySQL
Running MySQL queries on multiple servers

  
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Threaded Mode | Linear Mode
Running MySQL queries on multiple servers
03-02-2006, 09:13 AM,
Post: #1
mandy Offline
Administrator
*******
Posts: 9,932
Likes Given: 0
Likes Received: 6 in 5 posts
Joined: Feb 2011
Reputation: 0
Running MySQL queries on multiple servers
Quote:You may know how to use SQL to extract data from a table in a MySQL database, and how to run a query that combines data from more than one table. But what about multiple databases? Or even multiple databases on multiple servers?

Quote:You can use MySQL's database replication to help you run queries on data spread over different servers.

With database replication, one server is set up as a master and a second as a slave. Data from the master is then replicated on the slave, and any subsequent changes are automatically passed through. You must remember, however, that this is replication rather than a direct connection, meaning that the slave database is not updated immediately when records in the master database change.
full tutorial: http://www.linux.com/article.pl?sid=06/02/22/2050253

You could also use PostgreSQL instead of MySQL and save youself a lot of troubleĀ  :twistedevil:
Like Post Reply
[+]
« Next Oldest | Next Newest »




Possibly Related Threads…
Thread Author Replies Views Last Post
  Using MySQL Tuner to Tune MySQL Performance mandy 0 2,225 09-08-2008, 10:08 AM
Last Post: mandy
  Sun Agrees to Acquire MySQL for $1 Billion mandy 1 2,396 01-19-2008, 02:31 AM
Last Post: regic
  Google to Contribute Code to MySQL 7.0 mandy 0 2,134 10-25-2007, 10:55 AM
Last Post: mandy
  Backing up MySQL Data mandy 0 2,261 05-30-2007, 10:34 AM
Last Post: mandy
  Using OpenOffice to connect to MySQL and PostgreSQL Databases mandy 0 2,143 05-07-2007, 09:23 AM
Last Post: mandy
  Google Releases Improved MySQL Code mandy 0 2,039 04-26-2007, 10:39 AM
Last Post: mandy
  Database maker MySQL plans IPO as revenues top $50 million mandy 0 2,263 04-26-2007, 08:19 AM
Last Post: mandy
  Tips for Optimizing MySQL Queries mandy 1 2,628 04-12-2007, 07:19 AM
Last Post: misteroriginal
  Open Source Tools for Administering MySQL Databases mandy 0 2,407 10-21-2006, 10:38 AM
Last Post: mandy
  Using phpMyAdmin to manage your MySQL databases mandy 0 2,226 08-11-2006, 12:01 PM
Last Post: mandy

  • View a Printable Version
  • Send this Thread to a Friend
  • Subscribe to this thread
Forum Jump:


Users browsing this thread: 1 Guest(s)
  • Contact Us
  • TulipTools Internet Business Owners and Online Sellers Community
  • Return to Top
  • Lite (Archive) Mode
  • RSS Syndication
  • Help
Current time: 06-07-2023, 08:13 AM Powered By MyBB, © 2002-2023 MyBB Group. Theme created by Justin S.
powered by Apache

powered by Linuxpowered by CentOS

Copyright 2000-2013 TulipTools.com. All rights reserved.