- What are the common approaches to data replication?
- Why do you want to use data replication in your application?
- What MySQL offers with different replication types.
- What are the limitations of different MySQL replication.
- How to evaluate your architecture needs
- A new architecture mindset …
10 Older Entries »
At our June meetup, our guest speaker and Chief Evangelist from MariaDb Colin Charles gave a presentation on “Lessons from database failures”. Some of the details of his presentation included:
- Notable failures causing companies to go out of business
- varying backup commands and options
- Understanding a/semi/synchronous replication
- Replication topology management tools
- Proxy and sharding tools
- Security, SQL injections and encryption
I recently completed a four country tour of Baltic Sea countries presenting this seminar series at:
- Helsinki, Finland on Wednesday August 20.
- Stockholm, Sweden on Thursday August 21.
- Riga, Lavtia on Tuesday August 26.
- Talinn, Estonia on Wednesday August 27.
This seminar of four presentations provided a detailed review of the essential lifecycle components for developing a successful software application and offered a checklist for your company to review the design, development, deployment and support practices of your MySQL business applications. Presentations …[Read more]
Yesterday we had our third MySQL User Group meeting in Trondheim with close to 40 participants, a mix of database administrators, application developers, database developers, and even university professors.
We had all gathered to listen to Truls Bergskaug from Basefarm a leading hosting provider for mission critical business applications. Truls Bergskaug is an experienced database administrator who deals with around 500 MySQL instances in production, all MySQL versions starting from 4.1 up to 5.6. Truls presented the hosting environment, typical set up scenarios, issues related to database upgrades, monitoring, and management. As an example Truls outlined Basefarm’s internally made rpm …[Read more]
You may think that you already know what's the opposite of
"DISABLED", but with MySQL Event Scheduler you'll be wrong.
In fact MySQL Event Scheduler may have three different
DISABLED - The Event Scheduler thread does not run . In addition, the Event Scheduler state cannot be changed at runtime. OFF (default) - The Event Scheduler thread does not run . When the Event Scheduler is OFF it can be started by setting the value of event_scheduler to ON. ON - The Event Scheduler is started; the event scheduler thread runs and executes all scheduled events.
So if you're going to find it in the DISABLED state and
instinctively set it to ENABLED you'll end up with a
non-starting MySQL daemon.
Be warned and stay safe out there!
: When the Event Scheduler is not running does not appear …
MySQL Community team is pleased to announce following events as the ones supported by us with a great MySQL staff attending. Find more details below (or at our Community wikis).
NoSQL Roadshow, Berlin Germany, May 16,
- Talk: NoSQL & MySQL by Mario Beck
Solutions Libres & Open Source, Paris,
France, May 28-29, 2013
- Talk: NoSQL & MySQL by Olivier Zemrag …
We are planning the kickoff meeting of the Bangalore MySQL User
We would like to invite all MySQL enthusiasts at Bangalore to join.
Plan is to have at-least one meeting every quarter and give an opportunity to all to participate, attend and speak.
Agenda for 22 March Meeting:
1715-1730 : Meet the MySQL Development team @ Bangalore
1730-1815 : Introduction to MySQL 5.6
1815-1830 : Q&A & Plan for the next meeting
1830-1900 : Tea and informal networking
Conf Rom 0C001,
Ground Floor, B Wing, Oracle,
Kalyani Magnum Software technology Park
1st Main, J P Nagar 7th Phase,
You can also join the google group "bangalore-mysql-user-camp" where we will be announcing further meetings etc.
If you need to automate backups, you might wonder about the different techniques available to you.
With regards to scheduling backups using built-in features of
MySQL, you have two main options:
- Either run mysqldump (or mysqlbackup if you have an Enterprise licence) from an operating system scheduler, for example in Linux using "cron" or in Windows using the "Task Scheduler". This is the most commonly used option.
- Alternatively, use the Event Scheduler to perform a series of SELECT ... INTO OUTFILE ... commands, one for each table you need to back up. This is a less commonly used option, but you might still find it useful.
Scheduling mysqlbackup with cron
mysqldump is a client program, so when you run it, you run it from a shell script, or at a terminal, rather than inside a MySQL statement. The following statement backs up the sakila …[Read more]
Disclaimer/Bias Warning: For those that don’t know me, I write this as a perspective of a community member. I was the first ever Community Engineer at MySQL, followed by being a Community Relations Manager right up till I left Sun Microsystems. I now work on MariaDB which is a branch of MySQL, so naturally we are in competition for user base. But I’m writing this as a community member at large who cares about MySQL & the ecosystem.
First of, this is a focus on the user ecosystem. I think the …[Read more]
MySQL tries to be smart and to cram as much performance out of
available hardware, and one thing that most MySQLers knows is
that opening a table (ie. opening the frm file, and depending on
the storage engine, any additional files related to the table) is
expensive from a performance point of view. When we see the
opened_tables status variable increasing, we tend to
increase the table_open_cache setting and keep as many
tables as possible open and avoid reopening them.
When it comes to MyISAM though, this has a nasty side-effect. When the server crashes and there are MyISAM tables open, these might well need to be REPAIRed. And if you have big MyISAM tables, this is an issue. Let's say that your application use several MyISAM tables, with the same content, and that you create new tables after a certain time, to keep the size of each individual table down? There are other reasons why you have this effect also, say a large …
10 Older Entries »