473,320 Members | 1,861 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Mirror

Ike
Can anyone describe to me, or point me perhaps to a link, to figure out how
to mirror a MySQL database real-time? I need to create redundancy somehow --
any ideas along these lines would be so appreciated.

Thank you. Ike
Oct 30 '06 #1
1 3391
Ike wrote:
Can anyone describe to me, or point me perhaps to a link, to figure out how
to mirror a MySQL database real-time? I need to create redundancy somehow --
any ideas along these lines would be so appreciated.

Thank you. Ike

Add something like this to the mysqld section your my.ini file

[mysqld]
server-id=2
master-host=miniserver
master-user=account
master-password=apass
master-port=3306
report-host=hostname
Create an account on the master and put the user and password in the
section above and the correct servername.
You will also have to enable binary logging in the masters my.ini.
Oct 30 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Andrew James | last post by:
All, I'd like to be able to use psycopg2's new features for my development work with postgresql, but unfortunately the init.d site seems to be broken and I can't get to the repository there. ...
0
by: barbaros | last post by:
Hi everybody, I am trying to implement a cgi script for mirroring a small part of a large collection of files (the debian distribution). The idea is to mirror only those files which are...
1
by: hikums | last post by:
Can anyone post the procedure to split mirror steps for Veritas or Legato or from any vendor? ,so that I can better it. I understand the suspend i/o and initialization(db2inidb) , but need to...
0
by: code.killer | last post by:
Hi all ! First sorry for my bad english, I'm french... Here is my question : do anyone have ever used Ms "Mirror drivers" ? In fact I want to develop a remote administration plateform (with...
3
by: Dzemo | last post by:
I need way to have text in label and look like in mirror like "ambulance" so when i look text via mirror it print fine. Not "ecnalubma" but exactly like in mirror. thx
3
by: Greg Sabino Mullane | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 A bad link in the ftp source directory inspired me to check the rest of it out: * Main README file needs updating. The URL is given as: ...
3
by: Eduard Witteveen | last post by:
Hello list, I have code the draw MyDrawingObject information on a System.Drawing.Graphics object. The code is more/less the following: I now want to rotate / mirror the object i draw. I've...
0
by: virtualadepts | last post by:
In Ancient time mirrors were held to be sacred, but they only had pools of water and pieces of metal available to observe their own reflection. The only way to get a clear image of what you looked...
0
by: CoreyWhite | last post by:
In Ancient times mirrors were held to be sacred, but they only had pools of water and pieces of metal available to observe their own reflection. The only way to get a clear image of what you looked...
4
by: Mark A | last post by:
I would like to make a split mirror copy of a HADR standby database. Please note that I do not want to create a standby with a split mirror of the primary, but I want to make a split mirror of the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.