Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality? I am asking because I am working on a multi-master replication setup
pg has a hidden oid which is unique, can you use that? -- Seven Du http://about.me/dujinfang http://www.dujinfang.com http://www.freeswitch.org.cn Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On Wednesday, October 8, 2014 at 9:44 PM, Joel White wrote:
Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?
I am asking because I am working on a multi-master replication setup
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org (mailto:consulting@freeswitch.org) http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org (mailto:FreeSWITCH-users@lists.freeswitch.org) http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Not sure What I am trying to do is setup a Multi-Master replication of all database entries. This way when the system fails over to the secondary or tertiary servers all call details for recovery etc are on that system. So I am trying to add a primary key to all db tables that I want to be replicated. I just do not want to run into the situation of FreeSWITCH breaking because it does not understand how to handle the added primary key On Thu, Oct 9, 2014 at 1:14 AM, Seven Du <dujinfang@gmail.com> wrote:
pg has a hidden oid which is unique, can you use that?
-- Seven Du http://about.me/dujinfang http://www.dujinfang.com http://www.freeswitch.org.cn
Sent with Sparrow <http://www.sparrowmailapp.com/?sig>
On Wednesday, October 8, 2014 at 9:44 PM, Joel White wrote:
Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?
I am asking because I am working on a multi-master replication setup
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Joel, i use MySQL (i know you're looking for PG) i have added primary keys to most of my tables (Voicemail Preferences, Voicemail Messages, FIFO tables) without any issues, i have yet to test against the the calls & call state tables. I don't think it'd cause any issues except if FreeSWITCH ever tries to rebuild the tables in a later update, at which point you'd have to readd your PK On Wed, Oct 15, 2014 at 10:35 AM, Joel White <joelewhite@gmail.com> wrote:
Not sure
What I am trying to do is setup a Multi-Master replication of all database entries. This way when the system fails over to the secondary or tertiary servers all call details for recovery etc are on that system.
So I am trying to add a primary key to all db tables that I want to be replicated.
I just do not want to run into the situation of FreeSWITCH breaking because it does not understand how to handle the added primary key
On Thu, Oct 9, 2014 at 1:14 AM, Seven Du <dujinfang@gmail.com> wrote:
pg has a hidden oid which is unique, can you use that?
-- Seven Du http://about.me/dujinfang http://www.dujinfang.com http://www.freeswitch.org.cn
Sent with Sparrow <http://www.sparrowmailapp.com/?sig>
On Wednesday, October 8, 2014 at 9:44 PM, Joel White wrote:
Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?
I am asking because I am working on a multi-master replication setup
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Yes, you can add columns to those tables with no issues. Try it and see. William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518 william.king@quentustech.com On 10/8/14 9:44 AM, Joel White wrote:
Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?
I am asking because I am working on a multi-master replication setup
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Chris and William, Can those added PKs have a data type of SERIAL? On Wed, Oct 15, 2014 at 11:33 PM, William King <william.king@quentustech.com
wrote:
Yes, you can add columns to those tables with no issues. Try it and see.
William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518william.king@quentustech.com
On 10/8/14 9:44 AM, Joel White wrote:
Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?
I am asking because I am working on a multi-master replication setup
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.orghttp://www.freeswitchsolutions.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon....
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Serial is identical to mysql's Auto Increment, so i'm going to say yes. On Fri, Oct 17, 2014 at 9:36 AM, Joel White <joelewhite@gmail.com> wrote:
Chris and William,
Can those added PKs have a data type of SERIAL?
On Wed, Oct 15, 2014 at 11:33 PM, William King < william.king@quentustech.com> wrote:
Yes, you can add columns to those tables with no issues. Try it and see.
William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518william.king@quentustech.com
On 10/8/14 9:44 AM, Joel White wrote:
Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?
I am asking because I am working on a multi-master replication setup
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.orghttp://www.freeswitchsolutions.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon....
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Thank you Chris On Fri, Oct 17, 2014 at 2:08 PM, Chris Tunbridge <blasterjr@gmail.com> wrote:
Serial is identical to mysql's Auto Increment, so i'm going to say yes.
On Fri, Oct 17, 2014 at 9:36 AM, Joel White <joelewhite@gmail.com> wrote:
Chris and William,
Can those added PKs have a data type of SERIAL?
On Wed, Oct 15, 2014 at 11:33 PM, William King < william.king@quentustech.com> wrote:
Yes, you can add columns to those tables with no issues. Try it and see.
William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518william.king@quentustech.com
On 10/8/14 9:44 AM, Joel White wrote:
Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?
I am asking because I am working on a multi-master replication setup
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.orghttp://www.freeswitchsolutions.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon....
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Is there another datatype that would be more suitable. I plan to have massive amounts of traffic. Would the time datatype be more suitable? On Mon, Oct 20, 2014 at 12:26 PM, Joel White <joelewhite@gmail.com> wrote:
Thank you Chris
On Fri, Oct 17, 2014 at 2:08 PM, Chris Tunbridge <blasterjr@gmail.com> wrote:
Serial is identical to mysql's Auto Increment, so i'm going to say yes.
On Fri, Oct 17, 2014 at 9:36 AM, Joel White <joelewhite@gmail.com> wrote:
Chris and William,
Can those added PKs have a data type of SERIAL?
On Wed, Oct 15, 2014 at 11:33 PM, William King < william.king@quentustech.com> wrote:
Yes, you can add columns to those tables with no issues. Try it and see.
William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518william.king@quentustech.com
On 10/8/14 9:44 AM, Joel White wrote:
Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?
I am asking because I am working on a multi-master replication setup
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.orghttp://www.freeswitchsolutions.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon....
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
I've used bigint with a default of a sequence in the past to good results. make sure to add the option to not recreate the tables so we don't mess up your fields when we change scheme and when upgrading review for schema changes and make them manually On Monday, November 3, 2014, Joel White <joelewhite@gmail.com> wrote:
Is there another datatype that would be more suitable. I plan to have massive amounts of traffic. Would the time datatype be more suitable?
On Mon, Oct 20, 2014 at 12:26 PM, Joel White <joelewhite@gmail.com <javascript:_e(%7B%7D,'cvml','joelewhite@gmail.com');>> wrote:
Thank you Chris
On Fri, Oct 17, 2014 at 2:08 PM, Chris Tunbridge <blasterjr@gmail.com <javascript:_e(%7B%7D,'cvml','blasterjr@gmail.com');>> wrote:
Serial is identical to mysql's Auto Increment, so i'm going to say yes.
On Fri, Oct 17, 2014 at 9:36 AM, Joel White <joelewhite@gmail.com <javascript:_e(%7B%7D,'cvml','joelewhite@gmail.com');>> wrote:
Chris and William,
Can those added PKs have a data type of SERIAL?
On Wed, Oct 15, 2014 at 11:33 PM, William King < william.king@quentustech.com <javascript:_e(%7B%7D,'cvml','william.king@quentustech.com');>> wrote:
Yes, you can add columns to those tables with no issues. Try it and see.
William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518william.king@quentustech.com <javascript:_e(%7B%7D,'cvml','william.king@quentustech.com');>
On 10/8/14 9:44 AM, Joel White wrote:
Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?
I am asking because I am working on a multi-master replication setup
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <javascript:_e(%7B%7D,'cvml','consulting@freeswitch.org');>http://www.freeswitchsolutions.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon....
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.org <javascript:_e(%7B%7D,'cvml','FreeSWITCH-users@lists.freeswitch.org');>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <javascript:_e(%7B%7D,'cvml','consulting@freeswitch.org');> http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <javascript:_e(%7B%7D,'cvml','FreeSWITCH-users@lists.freeswitch.org');> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <javascript:_e(%7B%7D,'cvml','consulting@freeswitch.org');> http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <javascript:_e(%7B%7D,'cvml','FreeSWITCH-users@lists.freeswitch.org');> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <javascript:_e(%7B%7D,'cvml','consulting@freeswitch.org');> http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <javascript:_e(%7B%7D,'cvml','FreeSWITCH-users@lists.freeswitch.org');> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Well here is what I have done, I think that it should work. The PK is a SERIAL DataType and I went into the sequence properties and set it to CYCLED. The max value is 9223372036854775807 and will re-cycle once that number is reached. I only added this to the channels table right now. I have not seen any issues yet. On Mon, Nov 3, 2014 at 4:50 PM, Michael Jerris <mike@jerris.com> wrote:
I've used bigint with a default of a sequence in the past to good results. make sure to add the option to not recreate the tables so we don't mess up your fields when we change scheme and when upgrading review for schema changes and make them manually
On Monday, November 3, 2014, Joel White <joelewhite@gmail.com> wrote:
Is there another datatype that would be more suitable. I plan to have massive amounts of traffic. Would the time datatype be more suitable?
On Mon, Oct 20, 2014 at 12:26 PM, Joel White <joelewhite@gmail.com> wrote:
Thank you Chris
On Fri, Oct 17, 2014 at 2:08 PM, Chris Tunbridge <blasterjr@gmail.com> wrote:
Serial is identical to mysql's Auto Increment, so i'm going to say yes.
On Fri, Oct 17, 2014 at 9:36 AM, Joel White <joelewhite@gmail.com> wrote:
Chris and William,
Can those added PKs have a data type of SERIAL?
On Wed, Oct 15, 2014 at 11:33 PM, William King < william.king@quentustech.com> wrote:
Yes, you can add columns to those tables with no issues. Try it and see.
William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518william.king@quentustech.com
On 10/8/14 9:44 AM, Joel White wrote:
Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?
I am asking because I am working on a multi-master replication setup
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.orghttp://www.freeswitchsolutions.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon....
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
if you had 100 years of calls, having say 4 channels per call, you could have 63,173,781,074,347 calls per day that's 63 trillion calls... i wouldn't worry too much about seeing repeat/cycle anytime soon. You are talking about having 9 quintillion records, it should be safe to say that with bigint/serial setup like that you will be fine... you're much more likely to have a database server crash than run out of indexes at that point. On Tue, Nov 4, 2014 at 11:03 AM, Joel White <joelewhite@gmail.com> wrote:
Well here is what I have done, I think that it should work. The PK is a SERIAL DataType and I went into the sequence properties and set it to CYCLED. The max value is 9223372036854775807 and will re-cycle once that number is reached.
I only added this to the channels table right now. I have not seen any issues yet.
On Mon, Nov 3, 2014 at 4:50 PM, Michael Jerris <mike@jerris.com> wrote:
I've used bigint with a default of a sequence in the past to good results. make sure to add the option to not recreate the tables so we don't mess up your fields when we change scheme and when upgrading review for schema changes and make them manually
On Monday, November 3, 2014, Joel White <joelewhite@gmail.com> wrote:
Is there another datatype that would be more suitable. I plan to have massive amounts of traffic. Would the time datatype be more suitable?
On Mon, Oct 20, 2014 at 12:26 PM, Joel White <joelewhite@gmail.com> wrote:
Thank you Chris
On Fri, Oct 17, 2014 at 2:08 PM, Chris Tunbridge <blasterjr@gmail.com> wrote:
Serial is identical to mysql's Auto Increment, so i'm going to say yes.
On Fri, Oct 17, 2014 at 9:36 AM, Joel White <joelewhite@gmail.com> wrote:
Chris and William,
Can those added PKs have a data type of SERIAL?
On Wed, Oct 15, 2014 at 11:33 PM, William King < william.king@quentustech.com> wrote:
> Yes, you can add columns to those tables with no issues. Try it > and see. > > William King > Senior Engineer > Quentus Technologies, INC > 1037 NE 65th St Suite 273 > Seattle, WA 98115 > Main: (877) 211-9337 > Office: (206) 388-4772 > Cell: (253) 686-5518william.king@quentustech.com > > On 10/8/14 9:44 AM, Joel White wrote: > > Is it feasible to add Primary Keys to all FreeSWITCH tables or > would this break some functionality? > > I am asking because I am working on a multi-master replication setup > > > > _________________________________________________________________________ > Professional FreeSWITCH Consulting Services: consulting@freeswitch.orghttp://www.freeswitchsolutions.com > > Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.... > > FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com > > FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees... > > > > > _________________________________________________________________________ > Professional FreeSWITCH Consulting Services: > consulting@freeswitch.org > http://www.freeswitchsolutions.com > > Official FreeSWITCH Sites > http://www.freeswitch.org > http://confluence.freeswitch.org > http://www.cluecon.com > > FreeSWITCH-powered IP PBX: The CudaTel Communication Server > http://www.cudatel.com > > FreeSWITCH-users mailing list > FreeSWITCH-users@lists.freeswitch.org > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users > UNSUBSCRIBE: > http://lists.freeswitch.org/mailman/options/freeswitch-users > http://www.freeswitch.org >
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Cool, thanks for the feedback :) On Wed, Nov 5, 2014 at 5:59 PM, Chris Tunbridge <blasterjr@gmail.com> wrote:
if you had 100 years of calls, having say 4 channels per call, you could have 63,173,781,074,347 calls per day
that's 63 trillion calls... i wouldn't worry too much about seeing repeat/cycle anytime soon.
You are talking about having 9 quintillion records, it should be safe to say that with bigint/serial setup like that you will be fine... you're much more likely to have a database server crash than run out of indexes at that point.
On Tue, Nov 4, 2014 at 11:03 AM, Joel White <joelewhite@gmail.com> wrote:
Well here is what I have done, I think that it should work. The PK is a SERIAL DataType and I went into the sequence properties and set it to CYCLED. The max value is 9223372036854775807 and will re-cycle once that number is reached.
I only added this to the channels table right now. I have not seen any issues yet.
On Mon, Nov 3, 2014 at 4:50 PM, Michael Jerris <mike@jerris.com> wrote:
I've used bigint with a default of a sequence in the past to good results. make sure to add the option to not recreate the tables so we don't mess up your fields when we change scheme and when upgrading review for schema changes and make them manually
On Monday, November 3, 2014, Joel White <joelewhite@gmail.com> wrote:
Is there another datatype that would be more suitable. I plan to have massive amounts of traffic. Would the time datatype be more suitable?
On Mon, Oct 20, 2014 at 12:26 PM, Joel White <joelewhite@gmail.com> wrote:
Thank you Chris
On Fri, Oct 17, 2014 at 2:08 PM, Chris Tunbridge <blasterjr@gmail.com> wrote:
Serial is identical to mysql's Auto Increment, so i'm going to say yes.
On Fri, Oct 17, 2014 at 9:36 AM, Joel White <joelewhite@gmail.com> wrote:
> Chris and William, > > Can those added PKs have a data type of SERIAL? > > > > On Wed, Oct 15, 2014 at 11:33 PM, William King < > william.king@quentustech.com> wrote: > >> Yes, you can add columns to those tables with no issues. Try it >> and see. >> >> William King >> Senior Engineer >> Quentus Technologies, INC >> 1037 NE 65th St Suite 273 >> Seattle, WA 98115 >> Main: (877) 211-9337 >> Office: (206) 388-4772 >> Cell: (253) 686-5518william.king@quentustech.com >> >> On 10/8/14 9:44 AM, Joel White wrote: >> >> Is it feasible to add Primary Keys to all FreeSWITCH tables or >> would this break some functionality? >> >> I am asking because I am working on a multi-master replication >> setup >> >> >> >> _________________________________________________________________________ >> Professional FreeSWITCH Consulting Services: consulting@freeswitch.orghttp://www.freeswitchsolutions.com >> >> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.... >> >> FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com >> >> FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users >> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees... >> >> >> >> >> _________________________________________________________________________ >> Professional FreeSWITCH Consulting Services: >> consulting@freeswitch.org >> http://www.freeswitchsolutions.com >> >> Official FreeSWITCH Sites >> http://www.freeswitch.org >> http://confluence.freeswitch.org >> http://www.cluecon.com >> >> FreeSWITCH-powered IP PBX: The CudaTel Communication Server >> http://www.cudatel.com >> >> FreeSWITCH-users mailing list >> FreeSWITCH-users@lists.freeswitch.org >> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users >> UNSUBSCRIBE: >> http://lists.freeswitch.org/mailman/options/freeswitch-users >> http://www.freeswitch.org >> > > > > _________________________________________________________________________ > Professional FreeSWITCH Consulting Services: > consulting@freeswitch.org > http://www.freeswitchsolutions.com > > Official FreeSWITCH Sites > http://www.freeswitch.org > http://confluence.freeswitch.org > http://www.cluecon.com > > FreeSWITCH-powered IP PBX: The CudaTel Communication Server > http://www.cudatel.com > > FreeSWITCH-users mailing list > FreeSWITCH-users@lists.freeswitch.org > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users > UNSUBSCRIBE: > http://lists.freeswitch.org/mailman/options/freeswitch-users > http://www.freeswitch.org >
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (5)
-
Chris Tunbridge
-
Joel White
-
Michael Jerris
-
Seven Du
-
William King