Get Started for FREE
Sign up with Facebook Sign up with X
I don't have a Facebook or a X account
 Your new post is loading...
Scoop.it!
|
|
Scooped by stephane gault |
Scoop.it!
HAProxy's load-balancing algorithms HAProxy supports many load-balancing algorithms which may be used in many different type of cases. That said, cache servers, which deliver most of the time the s...
Very clever use of HAProxy to deliver faster and smarter ! HAProxy to optimize the resources on the cache, mainly its memory, in order to improve the HIT rate with Varnish.
|
|
Scooped by stephane gault |
Scoop.it!
This is guest post by Baron Schwartz, Founder & CEO of VividCortex, the first unified suite of performance management tools specifically designed for today's large-scale, polyglot persistence tier.
Another Great content by Baron Schwartz on VividCortex scalabilty approach.
|
|
Scooped by stephane gault |
Scoop.it!
This is a guest post by Oleksiy Kovyrin, Head of Technical Operations at Swiftype. Swiftype currently powers search on over 100,000 websites and serves more than 1 billion queries every month.
Well, obviously you also can move OUT of EC2 ! This is a very good post of why and how they manage it. I'm not the biggest fan of full "cloud" infrastructure for the exact same reasons !
|
|
Scooped by stephane gault |
Scoop.it!
Guest post by Julien Lemoine, co-founder & CTO of Algolia, a developer friendly search as a service API.
Algolia started in 2012 as an offline search engine SDK for mobile.
Scalability : The main goal of alot of infrastructure, and the dilema of the consistency vs HA vs performances : the CAP theorem.
|
|
Scooped by stephane gault |
Scoop.it!
This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) on Galera-based clusters such as Percona XtraDB Cluster (PXC).
Very complete setup guide to PXC. Clever use of Global Transaction IDs (GTIDs) on Galera-based clusters such as Percona XtraDB Cluster.
|
|
Scooped by stephane gault |
Scoop.it!
If you’ve been studying complex systems you know what minor changes might cause consequences of much greater proportions, sometimes causing some effects that are not easily explained at first.
Very nice analysis on what can hide changes and history list.
|
|
Scooped by stephane gault |
Scoop.it!
HAProxy is frequently used as a software load balancer in the MySQL world. Peter Boros, in a past post, explained how to set it up with Percona XtraDB Cluster (PXC) so that it only sends queries to available nodes.
Ha proxy Failover aware of Replication lag is mandatory ...
|
|
Scooped by stephane gault |
Scoop.it!
MySQL thread status: Waiting for query cache lock. Waiting for query cache lock is a connection status specific to MySQL 5.5 or newer...
Beware of this new feature in MySQL 5.5 or newer. We've learn the hard way, that it can be a killer on your performance at some point in a high concurrent query environnement. When you start to see some logs with : "Waiting for query cache lock", it may be time for disable it totaly !
|
|
Scooped by stephane gault |
Scoop.it!
MySQL table alterations can interrupt production traffic causing bad customer experience or in worst cases, loss of revenue. Not all DBAs, developers, syadmins know MySQL well enough to avoid this pitfall.
ALTER table operations are always a pain on big tables, résulting in downtimes. Here is a good insight of how it can be done.
|
|
Scooped by stephane gault |
Scoop.it!
A deadlock in MySQL happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a transaction system, deadlocks are a fact of life and not completely avoidable.
deadlocks is like prime evil !
|
|
Scooped by stephane gault |
Scoop.it!
MySQL replication is a core process for maintaining multiple copies of data – and replication is a very important aspect in database administration.
Very handy, you will face this error at least one time on replication.
|
|
Scooped by stephane gault |
Scoop.it!
After upgrading to Natty Narwhal I couldn't connect to my Linux based jump host (connected via VPN) ...
Derping with ssh behind cisco VPN annyconnect ... Always a pleasure to work behind those ... Workaround is trully DERP ;)
|
|
Scooped by stephane gault |
Scoop.it!
Parallel replication is a much-expected feature of MySQL. It’s available in MariaDB 10.0 and in MySQL 5.7. Yet, both lose efficiency when replicating through intermediate masters. In this post, we’ll explain how parallel replication works and why it does not play well with intermediate masters. We’ll also offer a solution (hint: it involves Binlog Servers).
Parallel replication taking advantage of the binary log group commit optimization. Well expected feature !
|
|
Scooped by stephane gault |
Scoop.it!
Solutions like PagerDuty improve your Network Operations Center performance. Here are five ways our customers use PagerDuty to enhance their NOCs.
Clever article on the synergy of alerting with real human actions.
|
|
Scooped by stephane gault |
Scoop.it!
Guest post by Tommaso Barbugli the CTO of getstream.io about cassandra migration on EC2
very useful feedback on how to handle the switch from your own infrastructure to the EC2 ecosystem for cassandra. Going multi datacenter is always a real challenge !
|
|
Scooped by stephane gault |
Scoop.it!
Tutorial delivered at Percona Live London 2014, where we explore new features and techniques for faster queries with MySQL 5.6 and 5.7 and MariaDB 10, includin…
|
|
Scooped by stephane gault |
Scoop.it!
In this blog post, we will discuss MySQL performance on eXFlash DIMMs. Earlier we measured the IO performance of these storage devices with sysbench fileio.EnvironmentThe benchmarking environment was the same as the one we did sysbench fileio in.
Great benchmark, with all those new storage techno, you have to figure what you'll really need before requesting a quote. IBM eXFlash and FuisionIO great storage card on the grill !
|
|
Scooped by stephane gault |
Scoop.it!
The other day a customer asked me to do capacity planning for their web server farm.
Back in the days, when HT came out on Xeon (P4 based), as a GSP (Game service provider) you where forced to turn HT off to get good response time, and max Frames. Well ... not much have changed :)
|
|
Scooped by stephane gault |
Scoop.it!
Query caching is one of the prominent features in MySQL and a vital part of query optimization. It is important to know how it works as it has the potential to cause significant performance improvements – or a slowdown – of your workload.
As we learned the hard way, MySQL query cache can be a huge bottleneck !
|
|
Scooped by stephane gault |
Scoop.it!
By default in MySQL 5.6, each time MySQL is started (regular start or crash recovery), it iterates through all the binlog files when GTIDs are not enabled ...
MySQL 5.6 fix for faster start of Percona/MySQL server.
|
|
Scooped by stephane gault |
Scoop.it!
You might have encountered situations where you had to kill some specific select queries that were running for long periods and choking the database. This post will go into more detail with an example of report query offloading.
Very handy tool
|
|
Scooped by stephane gault |
Scoop.it!
This is a guest post by Nikhil Palekar, Systems Architect, FoundationDB. For many organizations that care a lot about strong consistency and low latency or haven’t already built a fault tolerant application tier on top of their database, adding...
Very intresting point of view.
|
|
Scooped by stephane gault |
Scoop.it!
How would you build a chat service that needed to handle 7.5 million concurrent players, 27 million daily players, 11K messages per second, and 1 billion events per server, per day?
What could generate so much traffic?
Very intresting xp shared on this one ( this game is really nice btw ).
|
|
Scooped by stephane gault |
Scoop.it!
Article by Daniel Miessler first posted on his blog lsof is the sysadmin/security über-tool.
"lsof" very handy tool explained with exemples.
MySQL, Percona, HAproxy, Nginx, Zsh, Cassandra, Hadoop, Memcached, Redis, ElasticSearch, Postfix, OpenDKIM, etc ...