PlanetMysql.ru — информация о СУБД MySQL

 Oracle VM Administration: Oracle VM Server for x86 - new course just released.

This 3 day hands-on course teaches students how to build a virtualization platform using the Oracle VM Manager and Oracle VM Server for x86. Students learn how deploy and manage highly configurable, inter-connected virtual machines. The course teaches students how to install and configure Oracle VM Server for x86 as well as details of network and storage configuration, pool and repository creation, and virtual machine management.

You can follow this class that brings you great hands-on experience either in-class or from your own desk.

PlanetMySQL Voting: Vote UP / Vote DOWN

 Oracle VM Administration: Oracle VM Server for x86 - new course just released.

This 3 day hands-on course teaches students how to build a virtualization platform using the Oracle VM Manager and Oracle VM Server for x86. Students learn how deploy and manage highly configurable, inter-connected virtual machines. The course teaches students how to install and configure Oracle VM Server for x86 as well as details of network and storage configuration, pool and repository creation, and virtual machine management.

You can follow this class that brings you great hands-on experience either in-class or from your own desk.

PlanetMySQL Voting: Vote UP / Vote DOWN

Virtualizing all parts of today’s software infrastructure has become a priority for many. Creating a more flexible and dynamic environment with improved availability enables organizations to accelerate innovation, reduce time to market, cut costs and deliver higher uptime.

Databases have rarely been the first candidates for virtualization – mainly as a result of fears in consolidating such critical resources, and in I/O overhead that may have degraded service levels. However with improvements in hypervisor designs coupled with more powerful commodity server hardware and repeatable best practices, many of these concerns are rapidly diminishing.

It was in this context that we began development of the Oracle VM Template for MySQL Enterprise Edition, making the world’s leading web database radically simpler to deploy, manage, and support in a virtualized environment.

Along with the development team, we will be hosting a live webinar on Wednesday July 13^th where we will introduce the Template and demonstrate how to deploy it in production environments.

We will show how, in 1-click, users can download the Oracle VM Template - providing a pre-installed, pre-configured, pre-tested virtualized MySQL instance running on Oracle Linux and Oracle VM, packaged and certified for production deployment.

With the download complete, users simply import the template into the Oracle VM Manager and then configure for their local environment via a self-running first boot script. The image is then provisioned to the Oracle VM Server Pool where it is ready for use. It is simple to clone the image to create multiple MySQL instances in seconds and customize the template with additional software stacks to create new Golden Images.

In addition to rapid deployment, users also benefit from the integrated High Availability technologies that are part of the Template. Oracle VM provides native clustering mechanisms that can detect failures in the underlying server, VM or MySQL instances and automatically fail over to the other nodes in the VM Server Pool. User can configure the recovery to a specific server, or can allow Oracle VM to load balance the recovery to any server in the pool.

With downtime resulting from scheduled maintenance activities now representing the majority of outages in today’s data centers, Oracle VM also offers live migration. A user can initiate the migration of a running MySQL instance to another server across secure SSL links, without downtime.

And of course, users can receive support for the entire stack – from hypersior to database – from Oracle, eliminating all that nasty finger pointing that you might find with other VM / Database combinations.

We’ve created a couple of resources you can use to get started with the Oracle VM Template for MySQL Enterprise Edition:

- Register for the live webinar on July 13^th. Don’t worry if you can’t make it – by registering you will automatically be notified when the replay is available

- Download the new whitepaper which discusses the components of the template, and then how to download, configure and deploy it.

In summary, integrating MySQL Enterprise Edition with Oracle VM and Oracle Linux, the Oracle VM Template for MySQL is the fastest, easiest and most reliable way to provision virtualized MySQL instances. By using the template, users are able to meet the explosive demand for web-based services with a low Total Cost of Ownership, while providing a foundation for cloud computing. So download, kick back, and relax.....

PlanetMySQL Voting: Vote UP / Vote DOWN

David Cornelson of TextFyre has embarked on an ambitious plan to create a new open source virtual machine, FyreVM.  This new VM will run Interactive Fiction games (e.g. Zork and newer works written in Inform) on a dozen different mobile platforms such as Android, WinPhone 7, Kindle, iPhone, iPad, Blackberry.  The goal of FireVM is to take advantage of specific user interface capabilities on each platform, whether it's the touch screen of Android tablets or the 5 way button on the Kindle.

To help with this project, TextFyre has started  a fundraising effort on Kickstarter with a goal of raising $5,000.  To make it interesting, Cornelson is offering several incentives for sponsors:

•  $20  -- A copy of all TextFyre's current products
•  $50  -- A copy of all TextFyre's current products plus two in the works
• $100  -- Your IF game will be commercially published by TextFyre
• $500  -- A Kindle loaded with TextFyre games and a t-shirt
• $1000 --An iPad or Android tablet with TextFyre games and a t-shirt

The Kickstarter funding ends Saturday October 16. I hope you'll join me, other MySQLers, and IF fans  in making a donation. I think interactive fiction is an interesting retro area and want to encourage the development of open source tools and platforms.  Note that Cornelson is publishing TextFyre under an open source license.

• TextFyre: Main site, Games, Blog, Kickstarter page
• IFDB: The Shadow in the Cathedral, Jack Toresal and the Secret Letter

PlanetMySQL Voting: Vote UP / Vote DOWN

This is a Request for Input. Dual MySQL masters with MMM in a single datacentre are in common use, and other setups like DRBD and of course VM/SAN based failover solutions are conceptually straightforward also. Thus, achieving various forms of resilience within a single data-centre is doable and not costly.

Doing the same across multiple (let’s for simplicity sake limit it to two) datacentres is another matter. MySQL replication works well across longer links, and it can use MySQL’s in-built SSL or tools like stunnel. Of course it needs to be kept an eye on, as usual, but since it’s asynchronous the latency between the datacentres is not a big issue (apart from the fact that the second server gets up-to-date a little bit later).

But as those who have tried will know, having a client (application server) connection to a MySQL instance in a remote data-centre is a whole other matter, latency becomes a big issue and is generally very noticeable on the front-end. One solution for that is to have application servers only connect to their “local” MySQL server.

So the question to you is, do you now have (or have you had in the past) a setup with MySQL masters in different datacentres, what did that setup look like (which additional tools and infra did you use for it), and what were your experiences (good and bad, solutions to issues, etc). I’m trying to gather additional expertise that might already be about, which can help us all. Please add your input! thanks

PlanetMySQL Voting: Vote UP / Vote DOWN

Of course it’s not quite that simple. I’ve just decomissioned an old Red Hat 7.1 box (hosted dedicated server) that had been in service since 2002, so about 7 years. Specs? Celeron 1.3GHz, 512M, 60GB HD. Not too bad in the RAM and disk realm. It did a good job but goodness am I glad to be rid of it!

Not having that box online is safer for the planet, although it (perhaps amazingly considering the age of some of the externally facing software components) has never been compromised – I consider that mostly luck, by the way, I’m not naive about that. But it’s not easy to move off old servers, it’s generally (and also has been in this case) a lot of work.

Of course hosting has moved on since 2002, places like Linode offer more for less money/month. Of course they virtualise (Xen based in this case) and that’s not been my favourite (particularly for DB servers but depending on the use it really comes down to how you set up the whole infra). It’s a different environment, so different “rules” apply for the optimal setup. The feature/pricing model of the hosting(/cloud) provider actually has more than a little bit to do with that. Distributing tasks like MX relaying, DNS, moderate MySQL tasks, web server, across different virtual machines, with added redundancy across different data-centers, works very well for many use cases. And the funniest thing… more servers, with distributed redundancy, the net cost per month is actually lower than that one single server!

There a many aspects to consider, and I’m intending to write more about that in future posts. I just found it an interesting experience, dealing with this (personal, not even business) server. We handle with these technical environments all the time in our work, but it’s not quite the same perspective. It’s not all technical/financial issues, there’ more to it.