MCB.guru

Tag: databases

  • Replicating multiple masters to one slave

    As standard, MySQL allows replication from one master to multiple slaves, and that is a common scale-out scenario, but there have been a few comments recently, and some longer standing queries about having a setup that works the other way round, t…

  • MySQL University – quick survey

    MySQL University has been running for the last 18 months, and we’ve covered a wide range of topics, from the internals of MySQL right up to Amazon’s EC2, using MySQL in the Solaris/OpenSolaris Webstack and a description of the forthcoming MySQL On…

  • MySQL on i5/OS

    i5/OS doesn’t immediately strike you as the most natural environment for running MySQL, but in fact, there some advantages and benefits of making use of the hardware and i5/OS environment. The System i environment used with i5/OS is scalable, and …

  • Comparing 32-bit/64-bit MySQL on OpenSolaris

    I’ve been working with the folks working on OpenSolaris for a few months now providing advice and input on getting MySQL and the connectors (C/ODBC and C/J) installed as a standard component. Having got the basics in, the team are now looking at a…

  • Getting Best out of MySQL on Solaris

    I’m still working up some good tips and advice on MySQL on Solaris (particularly the T1000, the new x86 based servers like the X4150 and ZFS, amongst other things), but until then I found Getting Best out of MySQL on Solaris while doing some resea…

  • MySQL Documentation and Debian/Ubuntu

    We’ve got a lot of queries recently on the MySQL docs team address about the documentation (particularly man pages) for MySQL on Debian/Ubuntu. The source of the original problem was reported as a Debian bug. The assumption from the reading of the…

  • MySQL and DBD::mysql on Mac OS X

    I’ve been investigating some recent issues with installations of MySQL on Mac OS X and the Perl DBD::mysql module for accessing MySQL from within Perl through DBI. The problem exists only with binary distributions of MySQL and is related to the in…

  • Bad database design at Oracle

    I was clearing out my email this morning and closing down some of the mailing lists and other elements that I don’t use, and removing others. I’ve been an Oracle OTN member for years, but no longer get as much out of it as I used to. I almost thou…

  • Major rewrite of C/ODBC completed

    One of my first major tasks at MySQL has just been completed – a major rewrite of the Connector/ODBC (C/ODBC) documentation. There were three major focuses for the rewrite: Bring the documentation up to date. We had a mix of information on the lat…

  • One worker in one country

    A recent article at CNN talks about how MySQL operates. As one of the MySQL team, I can attest that works, but it requires a significant amount of coordination, and lots of online communication through email, IRC, Skype and other methods to keep e…