135 reputation
3
bio website
location
age
visits member for 1 year, 9 months
seen Apr 16 at 11:52

Sep
21
comment PostgreSQL replication and large import
I am investigating cascading replication, seems to be similar to the MySQL Distribution Master - thanks for linking it up!
Sep
21
accepted PostgreSQL replication and large import
Sep
21
comment PostgreSQL replication and large import
Since it's long distance replication, I have chosen asynchronous replication, hence the streaming as for now looks OK
Sep
17
asked PostgreSQL replication and large import
Aug
25
comment MySQL cluster - how many hosts are needed for full HA?
@lzac thats actually very true, you need one spare at any time to switch over
Aug
20
accepted How to use MySQL Server 5.6 for GeoIP replication?
Aug
20
comment How to use MySQL Server 5.6 for GeoIP replication?
OKOK I have now idea how to get this to work properly. I'll put one in place, and see how it performs with 4 nodes with 200-300ms distances from the write master in London.
Aug
20
awarded  Supporter
Aug
20
comment SQL server job deployment
It's very hard to say really, I would just submit it and rely on server feedback on errors for the first time.
Aug
20
answered Large scale, hard to model design advice needed
Aug
20
comment Providing an ad-hoc report facility for business users in SQL Server 2008 R2
You mean both setting up the query and rendering the data? This is multi-tier application and it's implemented with Silverlight, LightSwitch and .NET WPF as in Server 2012 but not 2008 R2. There are however different tools to do either query construction and presentation rendering, and as for facility there are OLAP cubes.
Aug
19
asked How to use MySQL Server 5.6 for GeoIP replication?
Jul
20
awarded  Scholar
Jul
20
awarded  Student
Jul
19
comment How to restrict multi-tenant MySQL database?
Many thanks, I am just creating the views, so all multi-portal tables are represented as views instead tables. However I have a big app done the above way, so I cant use multiple tables, because it's way too many, so I thought to use session data in isolated transaction and no auto-commit
Jul
19
accepted How to restrict multi-tenant MySQL database?
Jul
18
asked How to restrict multi-tenant MySQL database?