RE: Design: how to prioritise 1-to-many fields

2010-12-09 Thread Jerry Schwartz
>From: gvim [mailto:gvi...@gmail.com] >Sent: Thursday, December 09, 2010 9:33 AM >To: MySQL >Subject: Design: how to prioritise 1-to-many fields > >I have a typical contact database which caters for multiple email addresses >with a distinct Email table keyed to a foreign key inside the Contact tabl

Re: migrating a split replication

2010-12-09 Thread Robert Citek
On Thu, Dec 9, 2010 at 9:10 AM, Shawn Green (MySQL) wrote: > On 12/8/2010 22:50, Robert Citek wrote: >> >> Greetings to all, >> >> Can I migrate slave databases between slave servers? >> >> Imagine the following scenario: I have one master database server with >> 10 databases.  I also have two sla

Re: Design: how to prioritise 1-to-many fields

2010-12-09 Thread Johan De Meersman
On Thu, Dec 9, 2010 at 3:33 PM, gvim wrote: > I have a typical contact database which caters for multiple email addresses > with a distinct Email table keyed to a foreign key inside the Contact table, > ie. a 1-to-many relationship. However, I want to prioritise these Email > entries for a given

Design: how to prioritise 1-to-many fields

2010-12-09 Thread gvim
I have a typical contact database which caters for multiple email addresses with a distinct Email table keyed to a foreign key inside the Contact table, ie. a 1-to-many relationship. However, I want to prioritise these Email entries for a given Contact entry so all I can think of is to add a nu

Re: migrating a split replication

2010-12-09 Thread Shawn Green (MySQL)
On 12/8/2010 22:50, Robert Citek wrote: Greetings to all, Can I migrate slave databases between slave servers? Imagine the following scenario: I have one master database server with 10 databases. I also have two slave database servers, one replicating 5 of the 10 databases, the other replicati

Re: Resource required

2010-12-09 Thread Machiel Richards
Well, if there is anyone out there interested. We have an opening for a Junior MySQL dba preferably with Linux experience as well. The person must however live in South Africa as the position is in the JHB area. If anyone is interested, let me know and we can discuss offline. Regard

Re: Resource required

2010-12-09 Thread Johan De Meersman
On Thu, Dec 9, 2010 at 1:46 PM, Machiel Richards wrote: >Does anybody know if there is a mysql mailing list where we can > post for a position we have open in terms of MySQL dba. > Here might work, I'm not aware of a specific list for MySQL jobs. -- Bier met grenadyn Is als mosterd by

Resource required

2010-12-09 Thread Machiel Richards
HI Guys Does anybody know if there is a mysql mailing list where we can post for a position we have open in terms of MySQL dba. I know some mailing lists have a specific list for job ads... Regards Machiel