Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rickrude11

    Dealing with 750 million records in MYSQL table

    I am logging source / destination IP addresses and ports along with bytes, times etc (netflow) and I want to keep 30 days of data for up to 100 sites. I dumbed down the example table, all the data types are either int(32), int(16),tinyint(4) or varchar(16). The idea is that each branch manager...
  2. rickrude11

    Dealing with 750 million records in MYSQL table

    I gave up on the idea of having mysql handle 750 million records because it obviously can't be done. If it could, it wouldn't be that hard to find a solution. I modified the process of data collection as towerbase had suggested but I was trying to avoid that because it it ugly. Thanks...
  3. rickrude11

    Dealing with 750 million records in MYSQL table

    ok so the table partitioning looks promising. However, would it not be so much simpler to just split them into separate tables? I would rather do that, why am I the only one in the world that wants to do this? I must be missing something.
  4. rickrude11

    Dealing with 750 million records in MYSQL table

    Well DonQ this is why I am asking. now to google 'table partitioning' :D
  5. rickrude11

    Dealing with 750 million records in MYSQL table

    Sort of, sorry for not being clear. I need this done dynamically. Creating the tables manually is ok, but I am unable to write if statements because the device numbers could be anything (not just 1-100). So I need something like this... set _device_table = concat('table_',NEW.device) create...
  6. rickrude11

    Dealing with 750 million records in MYSQL table

    Hi experts, I have a table that will potentially grow to 750 million records. To deal with this, I need to split the table into multiple tables via a trigger or something. Can anyone help with how to do that? I don't need line by line syntax or anything, just some general logic. Here is the...
  7. rickrude11

    mysql trigger to copy data into different tables

    The information I need is network traffic information from each of the senders, such as total amount of 'http' traffic, or smtp traffic etc. Behind each of them is a small network consisting of ~5 - ~50 users, and these devices monitor their internet usage basically. If I could split this large...
  8. rickrude11

    mysql trigger to copy data into different tables

    266 seconds is quicker than I thought! Still needs to be much quicker, because there could be multiple queries queuing up from multiple users :| Yes, I will be needing to upgrade my hardware (don't shoot me for running this on a virtual machine....) Thanks for looking at this Andrew.
  9. rickrude11

    mysql trigger to copy data into different tables

    Thanks for replying. At the moment there are only 4 devices sending data, and there are 30 million records for 30 days worth of data. I won't be keeping any more than 30 days, and I would expect no more than 100 devices. The table is simple... senderip, srcaddr...
  10. rickrude11

    mysql trigger to copy data into different tables

    Hi experts. I have a table that collects netflow traffic from multiple devices and it is MASSIVE. To be able to report on that in a timely manor I would like to split it up into separate tables based on the IP address of the sending device. The reason for this is because all the reports will...
  11. rickrude11

    suggestions for building HA cluster?

    Hey there I have just 4 ubuntu linux servers that are running on ESXi - postfix, mysql, web, ldap - which I would like to replicate to another site. I have a second site that I have bridged, so IP addressing can remain the same for simplicity. Ideally, I would like to replicate the Virtual...
  12. rickrude11

    Windows File Server, MAC domain

    hi all mac guys. i have a scenario where I have a mac domain with all mac servers and clients. I also have a new windows file server with direct attached storage. Is it possible to have the windows server join the mac domain and be able to authenticate mac users with their existing...
  13. rickrude11

    PPPoA bridge on 857 router?

    This is an atm interface, and has to authenticate the ppp session. I have been researching half-bridging, and this is what I need to use. On the dialer interface, the command ppp bridge ip enables half-bridging, but I haven't had any success yet. I only have 1 dynamic IP assigned by the isp. I...
  14. rickrude11

    PPPoA bridge on 857 router?

    I have a FortiGate firewall behind a cisco 857 router, and rather than double-nat I would like to be able to bridge the interfaces on the 857 so that the public IP terminates on the Fortigate firewall. Yes they want the firewall for web filtering. Is this possible? Surely it is. cheers all.
  15. rickrude11

    fax configuration dramas on uc520

    update: I set the compand-type to a-law and cptone to NZ. Getting full pages sometimes, half pages other times. cheers.
  16. rickrude11

    fax configuration dramas on uc520

    I have a uc520 with 2 BRI interfaces and 4 FXS interfaces. My fax line comes in on the BRIs, and the fax machine is hooked up to fxs port 0/0/0. when I test the fax, the fax machine picks up, but errors saying it can't detect a fax or unable to negotiate fax protocol. I need a direction to...
  17. rickrude11

    changes on call manager not working

    whykap, thanks for your help. all is well again, i restarted the server.
  18. rickrude11

    changes on call manager not working

    cheers. you are on the money. my phone and hunt groups registered successfully and i was able to forward my number through the server. I will try rebooting the subscriber on Saturday, or if I grow some balls I will do it this afternoon.
  19. rickrude11

    changes on call manager not working

    whykap, how do you manually register a hunt list?
  20. rickrude11

    changes on call manager not working

    OK I just checked RTMT under Database summary it says 392 replicates created for bot nodes, and replication status is 2 for both nodes. Is this enough to verify replication is ok? Sorry I am fairly new to CUCM. cheers.

Part and Inventory Search

Back
Top