Any mysql instance can replicate from any other as long as binary logging is
enabled on the designated master.
Two instances can replicate from one another yes, but precautions must be
taken especially in the case of active-active configuration.
Cheers,
Claudio
On Aug 3, 2011 7:19 AM, Jon Siebert
Any mysql instance can replicate from any other as long as binary logging
is enabled on the designated master.
Two instances can replicate from one another yes, but precautions must be
taken especially in the case of active-active configuration.
Works perfectly indeed, to name the precautions
2011/08/02 12:11 +0530, Adarsh Sharma
select p.* from table A p, B q where p.id=q.id
or
select p.* from table B q , A p where q.id=p.id
Why do people constantly change table names for queries, although, as here,
it gain them nothing? It often makes for less clarity (for which table
I rarely use aliases (unless rarely required in self-join queries).
When I have that option, I create unique columns by prefixing every
table (and its objects) with a number.
Something like:
Create table T1234_Employee
(C1234_Employee_id number(5),
C1234_employee_status char(1)...)
Index
On Aug 3, 2011 9:24 AM, David Lerer dle...@us.univision.com wrote:
I rarely use aliases (unless rarely required in self-join queries).
When I have that option, I create unique columns by prefixing every
table (and its objects) with a number.
Something like:
Create table T1234_Employee
I recently recovered a very large corrupt database with your help. Now I'm
having a problem during the next step, importing all the data back into a clean
system. I have a 24GB dump file, the ibdata1 file was about 100GB when the
disk filled and everything got wrecked. I have a server with a
Quoting supr_star suprstar1...@yahoo.com:
Is there any way to speed up this process? by disabling indexes or
something? I can't afford to be down for 3 more days...
First stop, the mysql documentation:
http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html
--
MySQL General Mailing
Dear MySQL users,
MySQL Installer 5.5.14.1 RC4 has been released. This is the final,
final release
candidate before GA so your feedback is greatly appreciated.
MySQL Installer is the all-in-one installation solution for all your MySQL
software needs. It comes with the latest MySQL Server
The following page has some nice interesting stuff, assuming you have a
reasonable configuration in place (innodb_buffer_pool, etc[1])
http://download.oracle.com/docs/cd/E17952_01/refman-5.5-en/optimizing-innodb-bulk-data-loading.html
[1]