Eric Frazier wrote:
> Oriol Capsada wrote:
>> Hi Norbert,
>>
>> Ok, when I said reboot the server I was referring to restart the
>> mysql proceess. I see that my expression was not clear enough :)
>>
>> And I would prefer not to restart the mysql process because some
>> services may not have persistent connections. Therefore, if I restart
>> the server those connections would be lost...
>>
>> So, any way to add the database without having to restart the mysql
>> process?
>>
>> Regards,
>> Oriol.
>>
>> Norbert Tretkowski wrote:
>>> Am Mittwoch, den 31.10.2007, 11:21 +0100 schrieb Oriol Capsada:
>>>
>>>> Everything I have read about adding a new database to a slave
>>>> replication talks about adding a new line in the configuration file
>>>> (for example a replicate-wild-do-table) and then restart the server.
>>>>
>>>> Is it possible to do so without having to reboot the server?
>>>>
>>>
>>> You don't need to reboot the whole server, it's enough to restart just
>>> the mysqld server process (e.g. with '/etc/init.d/mysql restart').
>>>
>>> Norbert
>>>
>>>
>>>
>>
>>
>
> You just need to NOT specify all of the dbs you are replicating. It is
> like a tradition that people do that, but not needed. Once you specify
> one DB however, you imply that the others are not to be replicated. I
> have done this before and create database statements do get replicated
> as well.
>
> Eric
>
>
As DBs can't be added without rebooting I suppose that this is what I am
finally going to do, not specify the DB names and replicate all of them.
Thanks for your answers.
Regards,
Oriol.
