[Kea-users] KEA MySQL Cluster

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[Kea-users] KEA MySQL Cluster

Jordan Tinsley

Hello,

 

I have a question.

 

I currently have 2 Kea servers that run MySQL locally.  Each server contains subnet pools for 2 separate vLANS ( Server 1 – vLANs 1 & 2, Server 2 – vLANs 3 & 4).  In the future, I may build more Kea servers (such as each vLAN will have a couple servers for redundancy)  as well as build MySQL clusters for each vLAN and their servers.

 

Is it possible to start off in this scenario and then add the databases to a cluster and retain some data from the databases from each vLAN?

 

Or will I have to start over from scratch on database data when adding clusters?

 

Never have setup a cluster nor redundant databases before.

 

Thanks,
Jordan

 

 


_______________________________________________
Kea-users mailing list
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [Kea-users] KEA MySQL Cluster

Klaus Steden

Hi Jordan,

You should be able to do a dump/restore from one database to the other when you spin up the clustered ones. For separate tables, you should be able to do this in stages, rather than migrating all your databases at once.

I would make sure your lease time is sufficiently long -- substantially longer than your standard maintenance window duration -- as you will need to also update your DHCP helper information on your switches, allow for DNS propagation, etc., which will take more than you're likely to need to copy data between databases.

cheers,
Klaus

On Tue, Dec 11, 2018 at 11:02 AM Jordan Tinsley <[hidden email]> wrote:

Hello,

 

I have a question.

 

I currently have 2 Kea servers that run MySQL locally.  Each server contains subnet pools for 2 separate vLANS ( Server 1 – vLANs 1 & 2, Server 2 – vLANs 3 & 4).  In the future, I may build more Kea servers (such as each vLAN will have a couple servers for redundancy)  as well as build MySQL clusters for each vLAN and their servers.

 

Is it possible to start off in this scenario and then add the databases to a cluster and retain some data from the databases from each vLAN?

 

Or will I have to start over from scratch on database data when adding clusters?

 

Never have setup a cluster nor redundant databases before.

 

Thanks,
Jordan

 

 

_______________________________________________
Kea-users mailing list
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users

_______________________________________________
Kea-users mailing list
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users