Re: MySql Load balancing Solutions?

From: Drumslayer (drumslayer2_at_yahoo.com)
Date: 02/02/05

  • Next message: Xian: "Re: ee editor rules :)" 
    Date: Wed, 2 Feb 2005 12:09:24 -0800 (PST)
To: Technical Director <trodat@ultratrends.com>

    --- Technical Director <trodat@ultratrends.com> wrote:

    >
    > Drumslayer,
    >
    > I am part of a team running MySQL 4.1.X on 5
    > machines in a replication
    > setup. Our first way to help manage load is the use
    > of useful rules in
    > our connection classes to direct "W"rites to our big
    > server with fast I/O
    > and memory and directing "R"reads to our slower I/O
    > less RAM slaves only.

     The only problem with this is that 4.1 is stil
    considered Beta ("not yet ready for production"). I
    see little chance in convincing managment to utilize
    something beta for something so important. :(
     
     I so far have only seen an alternative from a company
    called Emic. But it only runs any OS but freeBSD
    sadly. (it modifies the kernel so compat won't do it)

     Have you heard of any hardware solutions or FreeBSD
    friendly free or commercial products? I know basic
    clustering and such is supposed to be OK but
    everything that seems OS agnostic says it's Beta.

     We may wind up doing it this way but right now its a
    toss up of a Beta Solution or move to linux with Emic.
    Which I'm not fond of becouse its so convoluted and
    Well Not BSD :)

     Thanks

     M.

    > This one step in itself has done a LOT for keeping
    > uptimes high and
    > queries fast.
    >
    > A positive advantage is that the 5 machines allows
    > us the opportunity to
    > change the configuration if say one fails we can
    > promote another slave to
    > take that position or in the case of the "W"rite
    > server we can promote a
    > slave to a "W"rite server until the original "W"rite
    > server can be recovered.
    >
    > As well whether you use C/C++, Java, PHP or some
    > other scripting language
    > to access your database it shouldn't be too hard to
    > write some sort of
    > algorithm in your connection to spread the
    > connections across your host
    > base.
    >
    > When it comes to management I won't lie, 4.0.XX's
    > handling of Replication
    > was tough. Since though we've made the move to 4.1.X
    > our problems have
    > become less and less.
    >
    > A final advantage to having seperate machines in a
    > replication setup is
    > the ability to upgrade a segment or machine to a
    > newer MySQL version to
    > see how it will operate on your hardware/OS and with
    > your programs. We did
    > this with our move from 4.0.XX to 4.1.X by taking 2
    > slaves out of the main
    > loop, promoting one to the new 4.1.X master and the
    > other slave to a new
    > 4.1.X slave. After testing in pre-production we
    > proceeded with the
    > deployment on our other 3 boxes.
    >
    > INFO: Our 5 machine replication setup consists of:
    >
    > 1) 1 - 4 x P4 Xeon Compaq Server ("W"rite DB Server)
    > 2) 4 - 1 x P3 Compaq Servers ("R"ead DB Server)
    >
    > NOTE: On a smaller scale on my home network I do the
    > same on three
    > machines all sub-server class. I still have great
    > reliability and "robust"
    > performance from such a simple design.
    >
    > I hope this information is helpful, I know it works
    > well for us.
    >
    > Rob.
    >
    > On Tue, 1 Feb 2005, Drumslayer wrote:
    >
    > > Hi
    > > I have been running a fairly heavy duty server
    > for
    > > MySQL on FreeBSD but its starting to peak. I would
    > > like to know what others have done as far as using
    > a
    > > load balancing solution for MySQL or their success
    > > with replication.
    > > Also has anyone done a 64 bit build of MySQL on
    > > FreeBSD successfully?
    > >
    > > Thanks!
    > >
    > > M.
    > >
    > >
    > >
    > >
    > >
    > > __________________________________
    > > Do you Yahoo!?
    > > The all-new My Yahoo! - What will yours do?
    > > http://my.yahoo.com
    > > _______________________________________________
    > > freebsd-questions@freebsd.org mailing list
    > >
    >
    http://lists.freebsd.org/mailman/listinfo/freebsd-questions
    > > To unsubscribe, send any mail to
    > "freebsd-questions-unsubscribe@freebsd.org"
    > >
    > _______________________________________________
    > freebsd-questions@freebsd.org mailing list
    >
    http://lists.freebsd.org/mailman/listinfo/freebsd-questions
    > To unsubscribe, send any mail to
    > "freebsd-questions-unsubscribe@freebsd.org"
    >

            
                    
    __________________________________
    Do you Yahoo!?
    Yahoo! Mail - You care about security. So do we.
    http://promotions.yahoo.com/new_mail
    _______________________________________________
    freebsd-questions@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-questions
    To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"

  • Next message: Xian: "Re: ee editor rules :)"

    Relevant Pages

    • Distribution Agent failed login for user NT AUTHORITYANONYMOUS LOGON
      ... I am new to SQL Server Replication. ... I have 3 SQL Server 2000 machines. ... The Subscriber is ...
      (microsoft.public.sqlserver.replication)
    • MySQL 5.0.22 -> 5.0.24 upgrade replication issue.
      ... I have a strange replication issue since upgrading from the port from 5.0.22 to 5.0.24. ... This is all running on FreeBSD 6.1-p3 on two amd64 machines (one single ... I have a cron job that checks the slave status on the machines so I get ...
      (freebsd-questions)
    • Re: Replace Server 2000 PDC With 2003 rc2 64 Bit
      ... If you purchase the 64 bit o/s, I am unsure if the adprep R2 disk is ... O/S, for your new machines. ... Ensure AD replication has synchronized the domain. ... 130642 How to Move a DHCP Database to Another Windows Server ...
      (microsoft.public.windows.server.active_directory)
    • Re: sql clustering vs load balancing
      ... ALso, i would love to move away from replication, but how could you then ... For example if i have serves in cali, and a server in kentucky for backup. ... > Clustering Actice/Active is not load balancing, it means an instance of SQL ... >> machines also host our web sites. ...
      (microsoft.public.sqlserver.clustering)
    • Re: Removing "permanently offline" DC...
      ... Make sure that at least one of these machines is a Global Catalog ... In the DNS console, use the DNS MMC to delete the cname ... If this was a DNS server before you brought it down, ... Event 13516 OR 13509 which indicate successful replication. ...
      (microsoft.public.windows.server.active_directory)